mysql创建表 mysql创建表

mysql创建表

少了2个逗号.
逗号加号以后,建表成功.

mysql> create table users(
-> userid BIGINT primary key auto_increment,
-> username varchar(30) not null,
-> truename varchar(30) not null,
-> passwd varchar(30) not null,
-> email varchar(40) not null,
-> phone varchar(20) not null,
-> address varchar(30) not null,
-> postcode char(6) not null,
-> grade int default 1,
-> constraint unique_username unique(username)
-> )
Query OK, 0 rows affected (0.08 sec)

mysql创建表

CREATE TABLE graduate_info2(id INT(10) PRIMARY KEY auto_increment,number VARCHAR(100),mingzi VARCHAR(100),sex CHAR(100),birthday VARCHAR(100),nation VARCHAR(100),zhengjian CHAR(100),zhengjianhaoma CHAR(100),department CHAR(100),xueli CHAR(100),college VARCHAR(150))
字段id没有指定类型及长度