mysql的CREATE TABLE IF NOT EXISTS 的使用方法
DROP TABLE IF EXISTS t_bd_shop_bi;
CREATE TABLE IF NOT EXISTS t_bd_shop_bi; (
shop_id INT(11) NOT NULL,
shop_name VARCHAR(25) NOT NULL,
shop_address VARCHAR(200) NOT NULL ,
shop_type VARCHAR(50) NOT NULL,
status TINYINT(4) NOT NULL DEFAULT '0'
) ;
DROP TABLE IF EXISTS t_bd_shop_bi;
CREATE TABLE IF NOT EXISTS t_bd_shop_bi; (
shop_id INT(11) NOT NULL,
shop_name VARCHAR(25) NOT NULL,
shop_address VARCHAR(200) NOT NULL ,
shop_type VARCHAR(50) NOT NULL,
status TINYINT(4) NOT NULL DEFAULT '0'
) ;