以前使用oracle写删除语句如下:
delete from t_lcz t where t.id = '1';
可以正常运行。然而在mysql中报错,java运行时报错如下:
Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: #42000; bad SQL grammar [];
经查,是语法错误,原文链接:http://blog.csdn.net/chs_jdmdr/article/details/46708917
所以改为:
delete t from t_lcz t where t.id = '1';