Mysql综合练习题
创建表
创建数据库:
CREATE DATABASE test DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
创建student表
create table student(id int(10) not null unique primary key ,name varchar(20) not null, sex varchar(4),birth year,department varchar(20) ,address varchar(50));
创建score表
create table score(id int(10) not null unique primary key auto_increment,stu_id int(10) not null,c_name varchar(20),grade int(10));
插入数据
插入学生:
insert into student values(901,'张老大','男',1985,'计算机系','北京市海淀区');
insert into student values(9