Java SQLSyntaxErrorException: Key column ‘xxx‘ doesn‘t exist in table问题解决

傷城~ 2022-09-11 01:23 305阅读 0赞

问题描述：

Cause: java.sql.SQLSyntaxErrorException: Key column ‘user_name’ doesn’t exist in table

问题分析：

1、设置主键的字段名称在表格中不存在，导致报错。

  1. CREATE TABLE users(
  2.             `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  3.             `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  4.             PRIMARY KEY (`user_name`, `password`) USING BTREE
  5.                 USING BTREE
  6.         ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

解决办法：

设置主键的字段名称在表格中存在即可。

  1. CREATE TABLE users(
  2.             `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  3.             `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  4.             PRIMARY KEY (`username`, `password`) USING BTREE
  5.                 USING BTREE
  6.         ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

发表评论

表情：
评论列表 （有 0 条评论，305人围观）

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

相关阅读