3 ms·
Can MySQL queries refer to a temporary tables more than once in the same query, yet?
by babyrainbow 10y ago
Can MySQL queries refer to a temporary tables more than once in the same query, yet?
- morgo 10y agoThis limitation had to be lifted for CTEs to be reused, which is in the same labs release as the JSON functions mentioned here. I haven't checked yet if it is lifted for CTEs only, or all cases. But CTEs are a replacement for most (all?) uses of temporary tables that I can think of.