我照着书上创建了两个表。结果运行都正确,就是插入的时候,出现了问题。帮忙看看,各位,感激不尽。
CREATE TABLE customer
(Cust_no char(6) PRIMARY KEY ,
Cust_name varchar(10) NOT NULL,
Sex char(2) NOT NULL,
Birthdate datetime NULL,
City varchar(10) Null,
Discount Dec(3,2) Not NULL,
)
CREATE TABLE orderdetail
(Order_no char(6) NOT NULL,
CONSTRAINT Order_no_constraint
CHECK(Order_no LIKE'[A-Z][A-Z][0-9][0-9]'),
Cust_no char(6) PRIMARY KEY,
P_no char(6) NOT NULL,
Order_total int NOT NULL,
Order_data datetime NOT NULL,
CONSTRAINT Person_contr
FOREIGN KEY (P_no)
REFERENCES person(P_no)
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT customer_contr
FOREIGN KEY (Cust_no)
REFERENCES customer(Cust_no)
ON DELETE CASCADE
ON UPDATE CASCADE
)
SELECT *FROM orderdetail
INSERT INTO orderdetail
VALUES('AS58','000006','000002','150000','2006-04-05')
提示的错误是。INSERT 语句与 FOREIGN KEY 约束"customer_contr1"冲突。该冲突发生于数据库"master",表"dbo.customer", column 'Cust_no'。
CREATE TABLE customer
(Cust_no char(6) PRIMARY KEY ,
Cust_name varchar(10) NOT NULL,
Sex char(2) NOT NULL,
Birthdate datetime NULL,
City varchar(10) Null,
Discount Dec(3,2) Not NULL,
)
CREATE TABLE orderdetail
(Order_no char(6) NOT NULL,
CONSTRAINT Order_no_constraint
CHECK(Order_no LIKE'[A-Z][A-Z][0-9][0-9]'),
Cust_no char(6) PRIMARY KEY,
P_no char(6) NOT NULL,
Order_total int NOT NULL,
Order_data datetime NOT NULL,
CONSTRAINT Person_contr
FOREIGN KEY (P_no)
REFERENCES person(P_no)
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT customer_contr
FOREIGN KEY (Cust_no)
REFERENCES customer(Cust_no)
ON DELETE CASCADE
ON UPDATE CASCADE
)
SELECT *FROM orderdetail
INSERT INTO orderdetail
VALUES('AS58','000006','000002','150000','2006-04-05')
提示的错误是。INSERT 语句与 FOREIGN KEY 约束"customer_contr1"冲突。该冲突发生于数据库"master",表"dbo.customer", column 'Cust_no'。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货