Mysql 执行语句报
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 'group nvarchar(40)' at line 1
这种错是因为用到了Mysql的关键字,修改字段名即可。
这个错在程序中会体现成这个样子:
GenerationTarget encountered exception accepting command : Error executing DDL "alter table sys_task add column group nvarchar(40)" via JDBC Statement
如果使用druid,会出现
merge sql error, dbType mysql, druid-1.1.10, sql : alter table sys_task add column group nvarchar(40)
com.alibaba.druid.sql.parser.ParserException: error pos 37, line 1, column 32, token GROUP