摘要:
目前在写程序时,在处理MYSQL时遇到一个问题,问题如下update dealer_admin set is_super_admin=1 where id in (select id from dealer_admin group by dealer_id );此时会报:#1093 - You can't specify target table 'dealer_admin' for update in FROM clause在网上找了一个暂时可以解决的方法create temporary table tmp (id int);insert into tmp (id) 阅读全文
posted @ 2011-03-23 17:19 峰雪 阅读(2126) 评论(1) 推荐(0) 编辑