当数据库字段涉及到mysql保留字，插入数据不成功

简述

今天在编写项目的时候遇到一个问题，通过java项目向mysql数据库插入数据时，报下面的问题

com.mysql.jdbc.exceptions.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 'desc) values ('123', 1, 1.0, 1.0, null, null, null, null, '1')' at line 1

原因在于我使用了mysql的保留字，导致始终无法插入数据，但是从表面来看还没什么问题

mysql保留字

ADD ALL ALTERANALYZE AND ASASC ASENSITIVE  BEFOREBETWEEN BIGINT  BINARYBLOB    BOTH    BYCALL    CASCADE CASECHANGE  CHAR    CHARACTERCHECK   COLLATE COLUMNCONDITION   CONNECTION  CONSTRAINTCONTINUE    CONVERT CREATECROSS   CURRENT_DATE    CURRENT_TIMECURRENT_TIMESTAMP   CURRENT_USER    CURSORDATABASE    DATABASES   DAY_HOURDAY_MICROSECOND DAY_MINUTE  DAY_SECONDDEC DECIMAL DECLAREDEFAULT DELAYED DELETEDESC    DESCRIBE    DETERMINISTICDISTINCT    DISTINCTROW DIVDOUBLE  DROP    DUALEACH    ELSE    ELSEIFENCLOSED    ESCAPED EXISTSEXIT    EXPLAIN FALSEFETCH   FLOAT   FLOAT4FLOAT8  FOR FORCEFOREIGN FROM    FULLTEXTGOTO    GRANT   GROUPHAVING  HIGH_PRIORITY   HOUR_MICROSECONDHOUR_MINUTE HOUR_SECOND IFIGNORE  IN  INDEXINFILE  INNER   INOUTINSENSITIVE INSERT  INTINT1    INT2    INT3INT4    INT8    INTEGERINTERVAL    INTO    ISITERATE JOIN    KEYKEYS    KILL    LABELLEADING LEAVE   LEFTLIKE    LIMIT   LINEARLINES   LOAD    LOCALTIMELOCALTIMESTAMP  LOCK    LONGLONGBLOB    LONGTEXT    LOOPLOW_PRIORITY    MATCH   MEDIUMBLOBMEDIUMINT   MEDIUMTEXT  MIDDLEINTMINUTE_MICROSECOND  MINUTE_SECOND   MODMODIFIES    NATURAL NOTNO_WRITE_TO_BINLOG  NULL    NUMERICON  OPTIMIZE    OPTIONOPTIONALLY  OR  ORDEROUT OUTER   OUTFILEPRECISION   PRIMARY PROCEDUREPURGE   RAID0   RANGEREAD    READS   REALREFERENCES  REGEXP  RELEASERENAME  REPEAT  REPLACEREQUIRE RESTRICT    RETURNREVOKE  RIGHT   RLIKESCHEMA  SCHEMAS SECOND_MICROSECONDSELECT  SENSITIVE   SEPARATORSET SHOW    SMALLINTSPATIAL SPECIFIC    SQLSQLEXCEPTION    SQLSTATE    SQLWARNINGSQL_BIG_RESULT  SQL_CALC_FOUND_ROWS SQL_SMALL_RESULTSSL STARTING    STRAIGHT_JOINTABLE   TERMINATED  THENTINYBLOB    TINYINT TINYTEXTTO  TRAILING    TRIGGERTRUE    UNDO    UNIONUNIQUE  UNLOCK  UNSIGNEDUPDATE  USAGE   USEUSING   UTC_DATE    UTC_TIMEUTC_TIMESTAMP   VALUES  VARBINARYVARCHAR VARCHARACTER    VARYINGWHEN    WHERE   WHILEWITH    WRITE   X509XOR YEAR_MONTH  ZEROFILL