黑马程序员MySQL知识精讲+mysql实战案例_零基础mysql数据库入门到高

P40:

-- 1,创建数据库

create database if not exists mydb2;

use mydb2;

-- 2,创建商品表：

create table product(

pid int primary key auto_increment,

pname varchar(20) not null,

price double,

category_id varchar(20)

);

-- 3,添加数据

insert into product values(null,'海尔洗衣机',5000,'c001');

insert into product values(null,'美的冰箱',3000,'c001');

insert into product values(null,'格力空调',5000,'c001');

insert into product values(null,'九阳电饭煲',5000,'c001');

insert into product values(null,'啄木鸟衬衣',300,'c002');

insert into product values(null,'恒源祥西裤',800,'c002');

insert into product values(null,'花花公子夹克',440,'c002');

insert into product values(null,'劲霸休闲裤',266,'c002');

insert into product values(null,'海澜之家卫衣',180,'c002');

insert into product values(null,'杰克琼斯运动裤',430,'c002');

insert into product values(null,'兰蔻面霜',300,'c003');

insert into product values(null,'雅诗兰黛精华水',200,'c003');

insert into product values(null,'香奈儿香水',350,'c003');

insert into product values(null,'SK-II神仙水',350,'c003');

insert into product values(null,'资生堂粉底液',180,'c003');

insert into product values(null,'老北京方便面',56,'c004');

insert into product values(null,'良品铺子海带丝',17,'c004');

insert into product values(null,'三只松鼠坚果',88,nu11);