18 lines
674 B
SQL
18 lines
674 B
SQL
drop database if exists bookstore;
|
|
create database bookstore;
|
|
use bookstore;
|
|
create table book(
|
|
id int(11) not NULL,
|
|
title VARCHAR(255),
|
|
author VARCHAR(255),
|
|
publisher VARCHAR(255),
|
|
publishYear int(11)
|
|
)DEFAULT CHARSET=utf8;
|
|
Insert into book (id,title,author,publisher,publishYear) values
|
|
(1002,'平凡的世界', '路遥','新世界出版社',2011),
|
|
(1026,'活着', '余华','东方出版社',2016),
|
|
(1204,'围城', '钱钟书','人名文学出版社',1991),
|
|
(1208,'围城', '钱钟书','文艺出版社',2012),
|
|
(1004,'平凡的世界', '路遥','文艺出版社',2012),
|
|
(1010,'人生', '路遥','文艺出版社',2005),
|
|
(1024,'活着', '余华','作家出版社',2012); |