2 ms·
No, you run a SELECT … LIMIT in a CTE, and the main query is an UPDATE … JOIN CTE ON mytable.id = CTE.id
by williamdclt 3y ago
No, you run a SELECT … LIMIT in a CTE, and the main query is an UPDATE … JOIN CTE ON mytable.id = CTE.id
- ElongatedMusket 3y agoBut using a Common Table Expression is a workaround, kind of like using a paper towel as a plate. Just give us a plate...
- williamdclt 3y agoCompletely agree, I’d like a LIMIT on UPDATE too