数据库表

weixin_44854918

于 2020-08-04 22:03:31 发布

阅读量136

点赞数

分类专栏： MYSQL 文章标签： mysql 数据库

本文链接：https://blog.csdn.net/weixin_44854918/article/details/107801309

版权

MYSQL 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

创建表

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','A'),
('1111','3','3','2020-2-2','a'),
('1111','3','4','2020-2-12','赵六'),
('2222','4','5','2020-4-2','张齐'),
('3333','8','6','2020-5-2','老七'),
('3333','33','7','2020-4-8','皮卡丘'),
('4444','88','5','2020-4-2','张齐'),
('5555','55','6','2020-5-2','老八'),
('6666','61','7','2020-4-8','皮卡丘'),
('3333','33','7','2020-4-8','皮卡'),
('4444','88','5','2020-4-2','张上'),
('5555','55','6','2020-5-2','老六六'),
('6666','61','7','2020-4-8','卡丘'),
('7777','61','7','2020-4-8','卡丘 ')