创建MySQL数据表需要以下信息:
表名
表字段名
定义每个表字段
语法结构为:
CREATE TABLE table_name (column_name column_type);
例:CREATE TABLE IF NOT EXISTS `runoob_tbl`
( `runoob_id` INT UNSIGNED AUTO_INCREMENT,
`runoob_title` VARCHAR(100) NOT NULL,
`runoob_author` VARCHAR(40) NOT NULL,
`submission_date` DATE,
PRIMARY KEY ( `runoob_id` ))
ENGINE=InnoDB DEFAULT CHARSET=utf8;