关于mysql "You can't specify target table 'test_zb_scene' for update in FROM clause"的错误
今天写一段SQL,如下,DELETE FROM test_zb_scene WHERE sceneid_bigint IN ( SELECT a.`sceneid_bigint` FROM test_zb_scene a WHERE EXISTS (SELECT scenecode_varchar FROM zb_scene b WHERE a.`scenecode_varchar`=
原创
2016-09-04 23:20:03 ·
218 阅读 ·
0 评论