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
sql语句
DELETE FROM test t WHERE t.abc = 'abc'
原因:再删除语句中加了别名了
两种解决办法:
第一种:去掉别名
DELETE FROM test WHERE abc = 'abc'
第二种:
在delete 后加上别名
DELETE t FROM test t WHERE t.abc = 'abc'