For bosses to help see the sight of the bottom where there is a problem, it's hard to see

CodePudding user response:

Suggested that text, not map, may look is for the use of parentheses is Chinese,

CodePudding user response:

The create table if not exists tb_user (
Id bigint (20) primary key auto_increment comment 'number',
The name varchar (40) not null default (' ChuXin) the comment 'name',
The PWD varchar (50) default null comment 'password',
Sexy char (4) not null default (' female ') check (sexy in (' secret 'and' male 'and' female ')) the comment 'gender',
Birthday datetime default (CURRENT_TIMESTAMP) the comment 'date of birth,
The age int the default (0) the comment 'age',
Remark tinyint default (1) the comment 'effectiveness')
Engine=innodb auto_increment=20 comment='user table;

Tried not parentheses problem, please help to see again big

CodePudding user response:

The create table if not exists tb_user (
Id bigint (20) primary key auto_increment comment 'number',
The name varchar (40) not null default 'ChuXin' comment 'name',
The PWD varchar (50) default null comment 'password',
Sexy char (4) not null default 'female' comment 'gender' check (sexy in (' secret 'and' male 'and' female ')),
Birthday datetime not null default CURRENT_TIMESTAMP comment 'date of birth,
The age int the default 0 comment 'age',
Remark tinyint default 1 comment 'effectiveness')
Engine=innodb auto_increment=20 comment='user table;

CodePudding user response:

Bigint do not specify a width

CodePudding user response:

Positive solution, 3/f
Don't bring the parentheses after the default,