Question

MySQL总是报错，我快疯了！！大神救命啊！！在线等~~

mysql> create table yh
-> <
-> id int<6> not null primary key,
-> name char<10> not null,
-> profession char<20> not null
-> >;
ERROR 1074(42000)：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 '<id int<6> not null primary key, name char<10> not null, profession char<20> no' at line 2
我在输入的时候用的是英文半角

Answer 1

create table yh
(
id int (6) not null primary key,
name char (10) not null,
profession char(20) not null
);

尖括号改成圆括号