mysql - 我的数据库中的 Mysql 语法出现错误 1136

Question

create table doc_list (
    Serial_no int auto_increment,
    First_name varchar (50),
    last_name varchar (50),
    speciality varchar (50),
    address varchar (100),
    area varchar (50),
    phone_no int (15),
    email varchar(100),
    primary key(serial_no)
);

insert into doc_list (Serial_no, First_name, last_name, speciality, address, area, phone_no)
    values ("Abha", "gupta", "Gynaecology", "B-16 Mathur Vaishya Nagar Tonk Road", "Pratap Nagar", 9829133773);

我收到此错误消息:列计数与第 1 行的值计数不匹配我不想在本栏的电子邮件部分输入任何内容，那么我该怎么办？

Answer 1

应该是

insert into 
doc_list 
(First_name, last_name, speciality, address, area, phone_no) 
values 
("Abha", "gupta", "Gynaecology", "B-16 Mathur Vaishya Nagar Tonk Road", "Pratap Nagar", 9829133773);

插入语句中不得包含自动递增列。