Java All parts of a PRIMARY KEY must be NOT NULL；if you need NULL in a key,use UNIQUE instead问题解决

最新推荐文章于 2024-06-30 13:24:02 发布

旭东怪

最新推荐文章于 2024-06-30 13:24:02 发布

阅读量9.1k

点赞数

分类专栏： ORM框架关系型数据库文章标签： java sql

本文链接：https://blog.csdn.net/qq_38974638/article/details/120413474

版权

关系型数据库同时被 2 个专栏收录

86 篇文章

订阅专栏

ORM框架

85 篇文章

订阅专栏

问题描述：

Cause: java.sql.SQLSyntaxErrorException: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

问题分析：

1、设为主键的字段设置了可以为null。

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

解决办法：设为主键的字段设置为not null即可。

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