语法:
CREATE TABLE table_name (
column_name column_type [NOT NULL] [AUTO_INCREMENT]
...
primary key (column_name)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
column_name:字段名称
column_type:数据类型
NOT NULL:是否允许为NULL
AUTO_INCREMENT:递增
PRIMARY KEY :用于定义列为主键
ENGINE:设置存储引擎
CHARSET:编码类型
DEMO:
create table p_user(
id int(11) not null auto_increment,
name varchar(20),
age int(11),
birthday date,
address varchar(100),
sex tinyint(1),
other varchar(200),
primary key(id)
)engine=InnoDb default charset=utf8;