mysql - 使用 MySql 插入语句

Question

create table enquiry (
    eqid integer not null auto_increment primary key,
    question varchar(500),
    cusID integer(100),
    tpid integer(100),
    staffid integer(100)
 );

alter table enquiry add foreign key(tpid) references tourpackage (tpid) ON DELETE CASCADE ON UPDATE CASCADE;

alter table enquiry add foreign key(staffid) references staff (staffid) ON DELETE CASCADE ON UPDATE CASCADE;

alter table enquiry add foreign key(cusID) references customer (cusID) ON DELETE CASCADE ON UPDATE CASCADE;

---

insert into enquiry
    values (0, "What is the minimum travel group size?",0,0,0);

insert into enquiry
    values (0, "Can we return at a later date?",0,0,0);

insert into enquiry
    values (0, "I would like to use my KrisFlyer miles points to redeem an air ticket. Is it possible?",0,0,0);

我在插入查询值时遇到问题。无法添加或更新子行的错误状态。

Answer 1

您的插入内容可能看起来像这样:

insert into enquiry (question)
    values ('What is the minimum travel group size?');

您不应该插入到自动递增的主键中。让数据库在那里为您完成工作。

我猜测其他列的“0”值意在表示“无引用”。如果是这样，让数据库只插入 NULL。否则，您需要确保每个引用表都有一个“0”值。