p176代碼

create table tb_seller(

sellerid varchar(100),

name varchar(100),

nickname varchar(50),

password varchar(30),

status varchar(1),

adress varchar(100),

createtime datetime,

primary key(sellerid)

);

insert into tb_seller values

('alibaba','阿里巴巴','阿里小店','e10abc3949ba59zbbe56e057f20f883e','1','北京市','2088-01-01-12:00:00'),

('baidu','百度科技有限公司','百度小店','e10abc3949ba59zbbe56e057f20f883e','1','北京市','2088-01-01-12:00:00'),

('huawei','華為科技有限公司','華為小店','e10abc3949ba59zbbe56e057f20f883e','0','北京市','2088-01-01-12:00:00'),

('itcast','傳智播客教育科技有限公司','傳智博客','e10abc3949ba59zbbe56e057f20f883e','1','北京市','2088-01-01-12:00:00'),

('itheima','黑馬程序員','阿里小電','e10abc3949ba59zbbe56e057f20f883e','0','北京市','2008-01-01-12:00:00'),

('luoji','羅技科技有限公司','羅技小店','e10abc3949ba59zbbe56e057f20f883e','1','北京市','2088-01-01-12:00:00');

create index idx_seller_name_sta_addr on tb_seller(name,status,adress);