MySQL8.0版本 function关键字采坑记

自己本地测试环境MySQL:5.7。
线上生产环境MySQL:8.0

新功能中添加了一张表，表中有个function字段

测试环境运行一切正常。

生产环境报如下错误

Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'function = 'recordQuestions') ORDER BY create_time DESC' at line 3\n### The error may exist in com/pisolution/auth/mapper/SysUserPersonalizationMapper.java (best guess)\n### The error may involve defaultParameterMap\n### The error occurred while setting parameters\n### SQL: SELECT  `id`,`user_id`,`page`,`function`,`value`,`type`,`disabled`,`create_user_id`,`create_time`,`update_user_id`,`update_time`,`ver_num`,`deleted`  FROM sys_user_personalization     WHERE (user_id = ? AND page = ? AND function = ?) ORDER BY create_time DESC\n### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'function = 'recordQuestions') ORDER BY create_time DESC' at line 3\n; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'function = 'recordQuestions') ORDER BY create_time DESC' at line 3","data":null}}

经过一番查找。MySQL：8.0保留了function字段。

解决办法，在sql中的关键字字段上添加``。将字段包起来即可。