delete where
今天写一个存储过程,需要关联删除,结果,delete from table a where a.id =(select b.tbid from table2 b where b.id='11111')一直报错,
我就直接郁闷,而且 delete from table a 这样都不行,Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a'
然后就没有然后了,去掉别名就ok了============================================================