sql怎么添加語句

三、新建一個(gè)SQL,創(chuàng)建一個(gè)表

use demo;

create table seckill (

seckill_id bigint NOT NULL AUTO_INCREMENT COMMENT '商品庫存id',

name varchar(120) NOT NULL COMMENT '商品名稱',

number int NOT NULL COMMENT '庫存數(shù)量',

start_time timestamp NOT NULL COMMENT '秒殺開啟時(shí)間',

end_time timestamp NOT NULL COMMENT '秒殺結(jié)束時(shí)間',

create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',

PRIMARY KEY (seckill_id),

key idx_start_time(start_time),

key idx_end_time(end_time),

key idx_create_time(create_time)

)ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8 COMMENT='秒殺庫存表';

然后繼續(xù)添加數(shù)據(jù)：

insert into

seckill(name,number,start_time,end_time)

values

('100秒殺iphone9',100,'2018-8-1 00:00:00','2018-9-1 00:00:00'),

('200秒殺iPad',200,'2018-8-1 00:00:00','2018-11-1 00:00:00'),

('300秒殺小米8',300,'2018-8-1 00:00:00','2018-11-1 00:00:00'),

('400秒殺小米筆記本電腦',400,'2018-8-1 00:00:00','2018-11-11 00:00:00');

四、繼續(xù)鍵入查詢：

select * from seckill;

選中運(yùn)行，輸出添加結(jié)果，如圖所示：