mysql 创建新表

DROP TABLE IF EXISTS `customer`;

create table customer(

customer_id  int(10),

customer_name  VARCHAR(50) not null DEFAULT '',

customer_phone  VARCHAR(20) not null DEFAULT '',

customer_address  varchar(50) not null DEFAULT '',

customer_time datetime not null,

PRIMARY KEY(customer_id)

)ENGINE=INNODB auto_increment=1 DEFAULT CHARSET=utf8;