MySQL reports an error when creating a table. I can't understand it when I check the manual. Can you please solve it?

Question

MySQL reports an error when creating a table. I can’t understand it when I check the manual. Can you please solve it? {Code...} Error: you have an error in your sql syntax;check the manual that corresponds to your MySQL server version for the right syntax to use near 'primary_key...

伊谢尔伦 · Answer

Creating an indexed database table requires adding back-quotes to the table name and attributes, and the position of your current primary key needs to be adjusted:

create table `abc`(
   `id` int unsigned auto_increment,
   `usename` char(20) not null default '',
   `gender` char(1) not null default '',
   `weight` tinyint unsigned not null default 0, 
   `birth` date not null default 0,
   `salary` decimal(8,2) not null default '000000.00',
   `lastlogin` timestamp not null default 0,
   `intro` varchar(1500) not null default '',
   primary key (`id`)
)engine myisam charset=utf8;

I just tried it. Except for primary key, other attributes and table names can be used without back-quotes. Even this is also possible:

create table abc(
   id int unsigned auto_increment,
   usename char(20) not null default '',
   gender char(1) not null default '',
   weight tinyint unsigned not null default 0, 
   birth date not null default 0,
   salary decimal(8,2) not null default '000000.00',
   lastlogin timestamp not null default 0,
   intro varchar(1500) not null default '',
   primary key (`id`)
)engine myisam charset=utf8;

Reference: mysql create and delete tables

天蓬老师 · Answer

The declaration of primary_key is wrong, please solve it upstairs