创建表
# 创建表 create table department(id int,name varchar(20)); create table employee1( id int primary key auto_increment, name varchar(20), sex enum('male','female') not null default 'male', age int, dep_id int ); # 插入数据 insert into department values(200,'技术'),(201,'人力资源'),(202,'销售'),(203,'运营'); insert into employee1(name,sex,age,dep_id) values('egon','male',18,200),('alex','female',48,201),('tom','male',38,201),('yuanhao','female',28,202),('lidawei','male',18,200),('jinkezhou','female',18,204); # 查看表 mysql> select * from employee1; +----+-----------+--------+------+--------+ (北联网教程,专业提供视频软件下载)
……