摘要:
mysql中You can't specify target table for update in FROM clause错误的意思是说,不能先select出同一表中的某些值,再update这个表(在同一语句中)。 例如下面这个sql:例如:DELETE FROM jx_test1 WHERE user_id = (SELECT user_id FROM jx_test1 WHERE createtime < '2013-10-01' ORDER BY User_id LIMIT 1)错误码: 1093You can't specify target t 阅读全文