要把表中,sale>0的ID最小的那个记录,更新一下,这样写在MYSQL中出错:
update `cw_jie` set sale=555 WHERE id in( select min(id) from cw_jie where sale>0 )
或
update `cw_jie` set sale=555 WHERE id =(select min(id) from cw_jie where sale>0 )都提示:You can't specify target table 'cw_jie' for update in FROM clause
update `cw_jie` set sale=555 WHERE id in( select min(id) from cw_jie where sale>0 )
或
update `cw_jie` set sale=555 WHERE id =(select min(id) from cw_jie where sale>0 )都提示:You can't specify target table 'cw_jie' for update in FROM clause
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货