---
title: check the manual that corresponds to your MySQL server version for the right syntax错误
date: 2018-10-17 11:37:53
categories: mysql
tags:
- mysql
- 关键字
---
昨天程序运行一直报check the manual that corresponds to your MySQL server version for the right syntax这个错。
原因：表里有一个字段是mysql的关键字，导致selectbypk时报错。
将这个字段重命令即可。
拓展一下，MYsql的关键字，以后就不要用这些关键字啦
| ADD | ALL | ALTER |
| ANALYZE | AND | AS |
| ASC | ASENSITIVE | BEFORE |
| BETWEEN | BIGINT | BINARY |
| BLOB | BOTH | BY |
| CALL | CASCADE | CASE |
| CHANGE | CHAR | CHARACTER |
| CHECK | COLLATE | COLUMN |
| CONDITION | CONNECTION | CONSTRAINT |
| CONTINUE | CONVERT | CREATE |
| CROSS | CURRENT_DATE | CURRENT_TIME |
| CURRENT_TIMESTAMP | CURRENT_USER | CURSOR |
| DATABASE | DATABASES | DAY_HOUR |
| DAY_MICROSECOND | DAY_MINUTE | DAY_SECOND |
| DEC | DECIMAL | DECLARE |
| DEFAULT |