1、问题:
在代码中使用到了sql删除的功能,最简单的删除sql:
delete from people p where p.id = 1;
但是出现了问题,提示我无法删除,报错为:
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 'delete from people p where p.id = 1;’ at line 1
2、解决:
经过查资料得知,原来在删除时不允许使用简称,这是sql官方防止用户在进行删除时因为使用了简称而出现误操作的风险
标签:语句,your,删除,people,syntax,sql,id From: https://www.cnblogs.com/Silentness/p/17685761.html