关于Mysql delete where

 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了============================================================

我勒个擦擦擦，mysql删除的时候不能用别名 - -#