create table book -> ( -> id int(11), -> name varchar(45), -> price float -> ); CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name (create_definition,...) [table_options] [partition_options] 看一下吧
create table tb_admin ( id int primary key auto_increment, user varchar(20) not null default '', password varchar(30) not null default '', createTime datetime not nul default '0000-00-00 00:00:00' )engine myisam charset utf8;
create table tb_admin( id int(32) primary key auto_increment, user varchar(32) not null, password varchar(32) not null, createTime datetime not null );
老趋,好久没见上来,什么来玩mysql了
creae table tb_admin (id int auto_increment primary key, user varchar(30) not null, password varchar(30) not null, createtime datetime ) engine=innodb charset=utf8;
-> (
-> id int(11),
-> name varchar(45),
-> price float
-> ); CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
(create_definition,...)
[table_options]
[partition_options]
看一下吧
(
id int primary key auto_increment,
user varchar(20) not null default '',
password varchar(30) not null default '',
createTime datetime not nul default '0000-00-00 00:00:00'
)engine myisam charset utf8;
create table tb_admin(
id int(32) primary key auto_increment,
user varchar(32) not null,
password varchar(32) not null,
createTime datetime not null
);
老趋,好久没见上来,什么来玩mysql了
(id int auto_increment primary key,
user varchar(30) not null,
password varchar(30) not null,
createtime datetime
) engine=innodb charset=utf8;