php - NOT NULL 的 MySQL 错误

Question

我正在尝试在我的数据库中运行此查询:

CREATE TABLE users(
    user_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
    username VARCHAR NOT NULL, 
    userpass VARCHAR NOT NULL,
    first_name VARCHAR NOT NULL,
    last_name VARCHAR NOT NULL,
    email VARCHAR NOT NULL,
    address VARCHAR NOT NULL,
    phone BIGINT UNSIGNED NOT NULL,
    PRIMARY KEY(user_id)
)

MySQL 返回此错误:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NOT NULL, userpass VARCHAR NOT NULL, first_name VARCHAR NOT NULL, ' at line 3

我不知道代码有什么问题...

Answer 1

您需要为 VARCHAR 列指定大小:

CREATE TABLE users( user_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
                   username VARCHAR(100) NOT NULL,
                   userpass VARCHAR(100) NOT NULL,
                   first_name VARCHAR(100) NOT NULL,
                   last_name VARCHAR(100) NOT NULL,
                   email VARCHAR(100) NOT NULL,
                   address VARCHAR(100) NOT NULL,
                   phone  BIGINT UNSIGNED NOT NULL,
                   PRIMARY KEY(user_id) );

SqlFiddleDemo

将电话号码存储为 BIGINT 并不是最好的主意。考虑使用普通字符串。