use mydb;
create table tb_goods(
id varchar(20) primary key,
name varchar(20) not null,
price double not null,
company varchar(100) not null,
leave_date timestamp not null,
`desc` varchar(500)
)
insert into tb_goods values('12323434','桃李面包',6.0,'桃李食品公司','2018-06-09 12:00:05','桃李面包')
insert into tb_goods
values
('9998734','桃李面包1',6.0,'桃李食品公司','2018-06-09 12:00:05','桃李面包'),
('34343434','桃李面包2',12.0,'桃李食品公司','2018-06-09 12:00:05','桃李面包'),
('494594594','桃李面包3',5.50,'桃李食品公司','2018-06-09 12:00:05','桃李面包'),
('458548548','桃李面包4',2.0,'桃李食品公司','2018-06-09 12:00:05','桃李面包')
select id,name,price,company,leave_date leaveDate,`desc` from tb_goods
评论1
最新资源