编辑代码

CREATE  database  testdb;
use testdb;
CREATE Table student(
  id int(10) NOT NULL AUTO_INCREMENT ,
  name char(20) NOT NULL,
  sex char(20) DEFAULT NULL,
  birth year(4) DEFAULT NULL,
  department char(10) DEFAULT NULL,
  address char(10) NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

insert  into student(id,name,sex,birth,department,address) values (1,'张老大','男',1985,'计算机系','北京市海淀区');
insert  into  student(id,name,sex,birth,department,address) values (2,'张老二','男',1986,'中文系','北京市昌平区');
insert  into  student(id,name,sex,birth,department,address)  values (3,'张三','女',1990,'中文系','湖南省永州市');
insert  into  student(id,name,sex,birth,department,address)  values (4,'李四','男',1990,'英语系','辽宁省阜新市');
insert  into  student(id,name,sex,birth,department,address) values (5,'王五','女',1991,'英语系','福建省厦门市');
insert  into  student(id,name,sex,birth,department,address) values (6,'王六','男',1988,'计算机系','湖南省衡阳市');