mysql 关键字和保留字有哪些

mysql5.7

参考官网 https://dev.mysql.com/doc/refman/5.7/en/keywords.html

mysql8

1. 参考官网 https://dev.mysql.com/doc/refman/8.0/en/keywords.html

2. 使用语句查询查询

SELECT WORD FROM INFORMATION_SCHEMA.KEYWORDS WHERE RESERVED = 1;

因此, 使用以下语句可以查询列名和表名是否占用mysl关键字

SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'databeName' AND COLUMN_NAME IN (SELECT WORD FROM INFORMATION_SCHEMA.KEYWORDS WHERE RESERVED = 1);

SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'databeName' AND TABLE_NAME IN (SELECT WORD FROM INFORMATION_SCHEMA.KEYWORDS WHERE RESERVED = 1);