CREATE DATABASE day09;
CREATE TABLE celebrity(
sid INT PRIMARY KEY AUTO_INCREMENT,
sname VARCHAR(255),
sage VARCHAR(255),
ssex VARCHAR(255)
)
INSERT INTO celebrity VALUES
(NULL,‘李白’,‘34’,‘男’),
(NULL,‘杜甫’,‘24’,‘男’),
(NULL,‘白居易’,‘31’,‘男’),
(NULL,‘李商隐’,‘40’,‘女’),
(NULL,‘苏轼’,‘26’,‘男’),
(NULL,‘辛弃疾’,‘22’,‘男’);
CREATE TABLE works(
wid INT PRIMARY KEY AUTO_INCREMENT,
wwork VARCHAR(255),
wdynasty VARCHAR(255)
);
DELETE FROM celebrity
INSERT INTO works VALUES
(NULL,‘将进酒’,‘唐代’),
(NULL,‘蜀道难’,‘唐代’),
(NULL,‘夜雨寄北’,‘唐代’),
(NULL,‘静夜思’,‘唐代’),
(NULL,‘望岳’,‘唐代’),
(NULL,‘钱塘湖春行’,‘南宋’),
(NULL,‘念奴娇赤壁怀古’,‘北宋’),
(NULL