16 lines
574 B
SQL
16 lines
574 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),
|
|
(1204,'围城', '钱钟书','人名文学出版社',1991),
|
|
(1208,'围城', '钱钟书','文艺出版社',2012),
|
|
(1004,'平凡的世界', '路遥','文艺出版社',2012),
|
|
(1010,'人生', '路遥','文艺出版社',2005); |