18 lines
496 B
SQL
18 lines
496 B
SQL
drop database if exists bookstore;
|
|
create database bookstore;
|
|
use bookstore;
|
|
create table step7(
|
|
id int(11) not NULL,
|
|
title VARCHAR(255),
|
|
author VARCHAR(255),
|
|
publisher VARCHAR(255),
|
|
publishYear int(11)
|
|
)DEFAULT CHARSET=utf8;
|
|
Insert into step7 (id,title,author,publisher,publishYear) values
|
|
(1002,'平凡的世界', null,'新世界出版社',null),
|
|
(1208,null, '钱钟书',null,null);
|
|
create table transformedBook(
|
|
id int(11),
|
|
column_name VARCHAR(255),
|
|
value VARCHAR(255)
|
|
)DEFAULT CHARSET=utf8; |