CREATE DATABASE library;
CREATE DATABASE IF NOT EXISTS library;
SHOW DATABASES;
SHOW CREATE DATABASE library;
USE library;
create table books
(
    Bookid char(6),
    Bookname varchar(50),
    Author varchar(50),
    Press varchar(50),
    Pubdate date,
    Type1 varchar(20),
    Number int(2),
    Info varchar(255) 
);

show tables;