Re: Referential Integrity not working

[John Kuiper]

CREATE TABLE test.tbl_order (
order_id MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
ordr_name VARCHAR(20) DEFAULT NULL,
cust_id MEDIUMINT(9) DEFAULT NULL,
PRIMARY KEY (order_id),
CONSTRAINT tbl_order_FK1 FOREIGN KEY (cust_id)
REFERENCES test.tbl_customer(cust_id)
)
ENGINE = INNODB;