P40:

-- 1,創(chuàng)建數(shù)據(jù)庫

create database if not exists mydb2;

use mydb2;

-- 2,創(chuàng)建商品表：

create table product(

pid int primary key auto_increment,

pname varchar(20) not null,

price double,

category_id varchar(20)

);

-- 3,添加數(shù)據(jù)

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,'海瀾之家衛(wèi)衣',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);