数据库表

创建表

create table order_list--创建表
(
  order_id int not null,
  order_price float,
  order_count int,
  order_date date,
  order_name nvarchar(20) not null,
)

插入数据

select * from order_list--
insert into order_list(order_id,order_price,order_count,order_date,order_name)
values
('1111','3.2','3','2020-2-1','张三'),
('1111','3','3','2020-2-2','王五'),
('1111','3','4','2020-2-12','赵六'),
('2222','4','5','2020-4-2','张齐'),
('3333','8','6','2020-5-2','老六'),
('3333','6','7','2020-4-8','皮卡丘')