CREATE TABLE student(
id INT(5) PRIMARY KEY auto_increment,
username VARCHAR(40) NOT NULL,
password VARCHAR(40) NOT NULL,
name VARCHAR(20) NOT NULL,
gender VARCHAR(10) NOT NULL,
age INT(3) NOT NULL,
address VARCHAR(40) NOT NULL,
regdate DATE
)
PRIMARY KEY auto_increment:设置id主键自增;
varchar:字符串的可变长度。