有一个表的数据比较大，然后需要进行关联删除，删除的时候发现如下sql报错： delete from test.test1 a where exists (select 1 from test.test2 b where a.recordid=b.smsinfoid and b.receivetime 报错如下： error code: 1064you 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 where exists (select 1 from test.test2 b where a.recordid=b.smsinf' at line 1 开始以为是exists的问题，于是更改成in再测试，也报同样错： delete from test.test1 a where a.recordid in (select b.smsinfoid from test.test2 b where b.receivetime