MySql Create DB and table 遇到的坑

用惯了MSSQL的人刚开始可能不习惯MySQL的脚步，下面的脚步可以判断数据库是否存在，判断表是否存在然后创建。

 

DROP DATABASE IF EXISTS DBName;
CREATE DATABASE DBName;
USE DBName;

DROP TABLE  IF  EXISTS  t_Book;

CREATE TABLE t_Book
(
 bookId INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
 NAME VARCHAR(50) NOT NULL,
 author VARCHAR(20) NOT NULL,
 isbn CHAR(20) NOT NULL,
 edition VARCHAR(10) NOT NULL,
 press VARCHAR(20) NOT NULL,
 publicData DATETIME NOT NULL,
 catagory VARCHAR(50) NOT NULL,
 price DECIMAL NOT NULL,
 description VARCHAR(500) NOT NULL,
 pic VARCHAR(100) NOT NULL,
 sold INT UNSIGNED NOT NULL,
 SUM INT UNSIGNED NOT NULL,
 upShelfDate DATETIME NOT NULL,
 downShelfDate DATETIME NOT NULL
 );