Question

myspl创建数据表出现问题

create table user{
id int primary key auto_increment,
name varchar(255) not null,
blogs varchar(255) not null,
password varchar(255) not null

}
错在哪里了
#1064 - 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 primary key auto_increment,
name varchar(255) not null,
blogs ' at line 1
已知道了问题，忘记把{}换成（）

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励10（财富值+成长值）+提问者悬赏10（财富值+成长值）

Answer 1

create table customers
(
cust_id int not null auto_increment,
cust_name char(50) not null,
cust_sex char(50) not null,
cust_adderss char(50) null,
cust_contact char(50) null,
primary key(cust_id)
)