建立关系表
create table goods(
id int unsigned primary key auto_increment not null ,
name varchar (150 ) not null ,
cate_name varchar (50 ),
brand_name varchar (50 ),
price int not null ,
is_show bit not null default 1 ,
is_delete bit not null default 0
);
insert into goods values (0 ,'r510vc 15.6英寸笔记本' ,'笔记本' ,'华硕' ,'3399' ,default ,default );
insert into goods values (0 ,'y400n 14.0英寸笔记本电脑' ,'笔记本' ,'联想' ,'4999' ,default ,default );
insert into goods values (0 ,'g150th 15.6英寸游戏本' ,'游戏本' ,'雷神' ,'8499' ,default ,default );
insert into goods values (0 ,'x550cc 15.6英寸笔记本' ,'笔记本' ,'华硕' ,'2799' ,default ,default );
insert into goods values (0 ,'x240 超极本' ,'超级本' ,'联想' ,'4880' ,default ,default );
insert into goods values (0 ,'u330p 13.3英寸超极本' ,'超级本' ,'联想' ,'4299' ,default ,default );
insert into goods values (0 ,'svp13226scb 触控超极本' ,'超级本' ,'索尼' ,'7999' ,default ,default );
insert into goods values (0 ,'ipad mini 7.9英寸平板电脑' ,'平板电脑' ,'苹果' ,'1998' ,default ,default );
insert into goods values (0 ,'ipad air 9.7英寸平板电脑' ,'平板电脑' ,'苹果' ,'3388' ,default ,default );
insert into goods values (0 ,'ipad mini 配备 retina 显示屏'</