mysql update select from another table的相關文章
mysql update select from another table的相關公司資訊

MySQL UPDATE with SELECT on the same table in the same query | Stickblog
瀏覽:748
日期:2025-04-23
I’ve had the same problem: #1093 – You can’t specify target table ‘my_table’ for update in FROM clause So, my first solution has been with variables (like zag): SELECT @next_value := MAX(some_value) + 1 FROM my_table; UPDATE my_table SET some_value ......看更多