MySQL练习（1）

学生表信息

创建学生表

-- 创建学生表
create table student(
studentNo varchar(50) primary key,
studentName varchar(50),
loginPassword varchar(50),
sex varchar(20),
phone varchar(50) unique,
address varchar(20) default'宿舍',
born datetime,
email varchar(100),
fradeId int(10)
);

插入学生信息数据

insert into studentno values
('s1001','张三','zhangsan','男','13022225555','default','1994-01-01','null','1'),
('s1002','李四','lisi','男','13266669999','default','1991-07-07','null','1'),
('s1003','张丽','123456','女','13099999999','default','1992-05-06','null','1'),
('s1004','王磊','123456','男','15066668888','西安','1991-06-07','null','1'),
('s1005','张丹','zhangdan','女','15036998888','default','1992-06-07','null','1'),
(<