check the manual that corresponds to your MySQL server version for the right syntax错误

逃离我推掉我的手 2022-01-14 07:41 199阅读 0赞

假设使用如下命令建立了一个grade表：  
create table grade(low number(3,0),upp number(3),rank char(1));  
insert into grade values(90,100,’A’);  
insert into grade values(80,89,’B’);  
insert into grade values(70,79,’C’);  
insert into grade values(60,69,’D’);  
insert into grade values(0,59,’E’);  
commit;

做这个技术题，最开始那个grade表在sql里面无法建立。MySQL server version for the right syntax错误，查了以后发现，可能rank冲突？所以我把rank改成了ranking就过了。  
我改成了这样，可能跟mysql版本有关？新手不知道  
CREATE TABLE grade  
(low NUMERIC(3,0) NOT NULL,  
upp NUMERIC(3) NOT NULL,  
ranking VARCHAR(1)NOT NULL);

check the manual that corresponds to your MySQL server version for the right syntax错误  
2017年07月29日 09:15:36 hello\_\_word\_\_ 阅读数 110218  
版权声明：本文为博主原创文章，未经博主允许不得转载。 [https://blog.csdn.net/hello\_\_word\_\_/article/details/76287062][https_blog.csdn.net_hello_word_article_details_76287062]  
昨天晚上，用Hibernate做多对多映射，然后测试，结果直接报check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Order (moneys, orderNumber) values (0.0, ‘A001’)’。晚上检查半天都没检查出来，后来就和女票出去玩了。

早上再次运行还是报同样的错误，然后突然脑子一想会不会是Order表，出现关键字吧，果不其然，把表名从order改为t\_order就运行成功了。。。。。

拓展一下，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 DELAYED DELETE  
DESC DESCRIBE DETERMINISTIC  
DISTINCT DISTINCTROW DIV  
DOUBLE DROP DUAL  
EACH ELSE ELSEIF  
ENCLOSED ESCAPED EXISTS  
EXIT EXPLAIN FALSE  
FETCH FLOAT FLOAT4  
FLOAT8 FOR FORCE  
FOREIGN FROM FULLTEXT  
GOTO GRANT GROUP  
HAVING HIGH\_PRIORITY HOUR\_MICROSECOND  
HOUR\_MINUTE HOUR\_SECOND IF  
IGNORE IN INDEX  
INFILE INNER INOUT  
INSENSITIVE INSERT INT  
INT1 INT2 INT3  
INT4 INT8 INTEGER  
INTERVAL INTO IS  
ITERATE JOIN KEY  
KEYS KILL LABEL  
LEADING LEAVE LEFT  
LIKE LIMIT LINEAR  
LINES LOAD LOCALTIME  
LOCALTIMESTAMP LOCK LONG  
LONGBLOB LONGTEXT LOOP  
LOW\_PRIORITY MATCH MEDIUMBLOB  
MEDIUMINT MEDIUMTEXT MIDDLEINT  
MINUTE\_MICROSECOND MINUTE\_SECOND MOD  
MODIFIES NATURAL NOT  
NO\_WRITE\_TO\_BINLOG NULL NUMERIC  
ON OPTIMIZE OPTION  
OPTIONALLY OR ORDER  
OUT OUTER OUTFILE  
PRECISION PRIMARY PROCEDURE  
PURGE RAID0 RANGE  
READ READS REAL  
REFERENCES REGEXP RELEASE  
RENAME REPEAT REPLACE  
REQUIRE RESTRICT RETURN  
REVOKE RIGHT RLIKE  
SCHEMA SCHEMAS SECOND\_MICROSECOND  
SELECT SENSITIVE SEPARATOR  
SET SHOW SMALLINT  
SPATIAL SPECIFIC SQL  
SQLEXCEPTION SQLSTATE SQLWARNING  
SQL\_BIG\_RESULT SQL\_CALC\_FOUND\_ROWS SQL\_SMALL\_RESULT  
SSL STARTING STRAIGHT\_JOIN  
TABLE TERMINATED THEN  
TINYBLOB TINYINT TINYTEXT  
TO TRAILING TRIGGER  
TRUE UNDO UNION  
UNIQUE UNLOCK UNSIGNED  
UPDATE USAGE USE  
USING UTC\_DATE UTC\_TIME  
UTC\_TIMESTAMP VALUES VARBINARY  
VARCHAR VARCHARACTER VARYING  
WHEN WHERE WHILE  
WITH WRITE X509  
XOR YEAR\_MONTH ZEROFILL

[https_blog.csdn.net_hello_word_article_details_76287062]: https://blog.csdn.net/hello__word__/article/details/76287062

check the manual that corresponds to your MySQL server version for the right syntax错误

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 check the manual that corresponds to your MySQL server version for the right syntax to use near ‘key

相关 check the manual that corresponds to your MySQL server version for the right syntax to use完美解决

相关 Mysql错误:check the manual that corresponds to your MySQL server version for the right syntax

相关 check the manual that corresponds to your MySQL server version for the right syntax的解决方法

相关异常“check the manual that corresponds to your MySQL server version for the right syntax to use near ”

相关 check the manual that corresponds to your MySQL server version for the right syntax错误

相关 check the manual that corresponds to your MySQL server version for the right syntax to use near

相关修改mysql密码错误：check the manual that corresponds to your MySQL server version for the right syntax

相关 check the manual that corresponds to your MySQL server version for the right syntax错误

相关 check the manual that corresponds to your MySQL server version for the right syntax to use near