CREATE TABLE user
(
-> pin
CHAR(32) NOT NULL,
-> id
INT NOT NULL,
-> name
VARCHAR NOT NULL,
-> caralod
VARCHAR NOT NULL,
-> PRIMARY KEY ( pin
)
-> );
报错ERROR 1064 (42000): 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 'NOT NULL,caralod
VARCHAR NOT NULL,
PRIMARY KEY ( pin
)
)' at line 4
VARCHAR类型要指定长度,如VARCHAR(20)
试试下面这种
CREATE TABLE user(
-> pin CHAR(32) NOT NULL,
-> id INT NOT NULL,
-> name VARCHAR(20) NOT NULL,
-> caralod VARCHAR(20) NOT NULL,
-> PRIMARY KEY (pin)
-> );
CREATE TABLE user(
pin CHAR(32) NOT NULL,
id INT NOT NULL,
name VARCHAR(10) NOT NULL,
caralod VARCHAR(10) NOT NULL,
PRIMARY KEY (pin )
);