mysql创建数据库

DROP TABLE IF EXISTS tbname;
CREATE TABLE tbname (
  id int(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  createTime timestamp not null default current_timestamp comment '当前时间',
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='表注释';

create database dbName character set utf8;