1)创建test6数据库
CREATE database test6;
(2)在test6数据库中创建 work_info表,表结构在《MySQL入门教程》的第8章P146表8.1
use test6;
CREATE table work_info(id int(10) not null unique primary key,
name varchar(20) not null,
sex varchar (4) not null,
age int(5),
address varchar(50),
tel varchar (20)
);
(3)向work_info表中插入数据,需要插入的数据在《MySQL入门教程》的第8章P147表8.2
insert into work_info values(1,'张三','M',18,'北京市海淀区','1234567');
insert into work_info values(2,'李四','M',22,'北京市昌平区','2345678');
insert into work_info values(3,'王五','F',17,'湖南省永州市','3456789');
insert into work_info values(4,'赵六','F',25,'辽宁省阜新市','4567890'