数据库插入数据错误
2024-11-13 13:32:39 202人阅读
使用Hibernate，SpringMVC
出错语句为（自动生成的语句）
insert into MESSAGE (CONTENT, TIME, FROM_ID, READ, TITLE, USER_ID) values(‘123‘, ‘2015-01-22‘, 1, ‘no‘, ‘123‘, 2)
原因：READ字段出错，此为MySql保留字段
处理：修改字段名，如改成：ISREAD
所有保留字段
| 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 |
|
数据库插入数据错误
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉：
投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。
