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

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);