t1(a, b) t2(b, c)删除t1表中所有t1.b 与 t2.b 相等的数据。delete from t1 where t1.b = (select t1.b from t1, t2 where t1.b = t2.b );Error Code: 1093. You can't specify target table 't1' for update in FROM clause
这么写子查询不对吗? 要怎么用子查询来删除呢?delete t1.* from t1, t2 where t1.b = t2.b;这是对的。数据库delete
这么写子查询不对吗? 要怎么用子查询来删除呢?delete t1.* from t1, t2 where t1.b = t2.b;这是对的。数据库delete
delete from t1
from t1,t2
where t1.b=t2.b
delete t1 from t1, t2 where t1.b = t2.b;