Notice
Recent Posts
Recent Comments
Link
«   2025/06   »
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30
Tags
more
Archives
Today
Total
관리 메뉴

메모장

MySQL You can't specify target table 'tablename' for update in FROM clause 본문

DataBase

MySQL You can't specify target table 'tablename' for update in FROM clause

doopang 2024. 10. 24. 10:42
-- SELECT 한번 더 해줌
SELECT SEQ
FROM (SELECT COALESCE(SEQ, 0) + 1 AS SEQ
      FROM tablename) AS t