mysql一次记忆深刻的错误教训

建表时，不小心用change字作为表的字段，导致insert into 语句执行失败，百思不解。
错误信息如下：

\r\n### Error updating database. Cause: java.sql.SQLSyntaxErrorException: 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 ‘change, pct_chg, vol, \n amount, gmt_created, gmt_modified\n )\n value’ at line 3\r\n### The error may exist in file [D:\code\bbc\dal\target\classes\com\bbc\mapping\DaDoMapper.xml]\r\n### The error may involve com.bbc.dal.mapper.DaDoMapper.insert-Inline\r\n### The error occurred while setting parameters\r\n### SQL: insert into daily (code, tradedate, change, pct_chg, vol, amount, gmt_created, gmt_modified ) values (?, ?, ?, ?, ?, ?, ?, ? )\r\n### Cause: java.sql.SQLSyntaxErrorException: 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 ‘change, pct_chg, vol, \n amount, gmt_created, gmt_modified\n )\n value’ at line 3\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: 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 ‘change, pct_chg, vol, \n amount, gmt_created, gmt_modified\n )\n value’ at line 3",

}

解决方案：
将字段change 改为其他字样，例如change_y等后，调用mapper的insert接口，执行结果如下：

==> Preparing: insert into dy (code, tradedate, change_y, pct_chg, vol, amount, gmt_created, gmt_modified ) values (?, ?, ?, ?, ?, ?, ?, ?)
==> Parameters: abc(String), 20200403(String), 10.034(String), 10.034(String), 10.034(String), 10.034(String), 10.034(String), 10.034(String)

<== Updates: 1

切记 不能把mysql的关键字作为表的字段