CodePudding user response:

Input (id before, the last line of the semicolon before input)
Recommend watching the create table syntax

CodePudding user response:

Tb_admin have a semicolon to create table ()

CodePudding user response:

The create table book
-> (
-> Id int (11),
-> The name varchar (45),
-> Price float
-> );

The CREATE/TEMPORARY TABLE tbl_name (IF NOT the EXISTS]
(create_definition,... )
[table_options]
[partition_options]
Have a look at it

CodePudding user response:

The create table tb_admin
(
Id int primary key auto_increment,
The 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;

CodePudding user response:

Advice first take a look at the official grammar specification,

CodePudding user response:

 
The create table tb_admin (
Id int primary key (32) auto_increment, 
The user varchar (32) not null, 
Password varchar (32) not null, 
CreateTime datetime not null 
); 

CodePudding user response:

reference 1st floor ZJCXC response:

id before input (, the last line of the semicolon before input)
Recommend watching the create table syntax

Old, long time no see, what to play mysql

CodePudding user response:

I also didn't come up a few years, suddenly see you up, my excitement

CodePudding user response:

Only use soon, so need more practice

CodePudding user response:

Show that after the input ()

CodePudding user response:

Creae table tb_admin
(id int auto_increment primary key,
The user varchar (30) not null,
Password varchar (30) not null,
Createtime datetime
) engine=innodb charset=utf8;