CREATE DATABASE swuban;
USE swuban;
CREATE TABLE student(
id INT,
studentname VARCHAR(20),
gender ENUM("男","女"),
birthday DATE,
age INT(4),
classid INT(4),
beginyear YEAR,
phone VARCHAR(11),
province VARCHAR(20),
city VARCHAR(20),
email VARCHAR(50)
)