product_id) - Eduguru

Asterisk Databse linux

SQL FOREIGN KEY Constraint

October 18, 2013 eduguru 4 Comments ...) [ON DELETE reference_option] [ON UPDATE reference_option], ...) REFERENCES tbl_name (index_col_name, CREATE TABLE product ( category INT NOT NULL, customer_id INT NOT NULL, FOREIGN KEY (customer_id) REFERENCES customer(id) ) ENGINE=INNODB; Adding foreign keys ALTER TABLE tbl_name ADD [CONSTRAINT [symbol]] FOREIGN KEY [index_name] (index_col_name, FOREIGN KEY (product_category, id INT NOT NULL, id) ) ENGINE=INNODB; CREATE TABLE customer ( id INT NOT NULL, id) ON UPDATE CASCADE ON DELETE RESTRICT, INDEX (customer_id), INDEX (product_category, price DECIMAL, PRIMARY KEY (id) ) ENGINE=INNODB; CREATE TABLE product_order ( no INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(category, PRIMARY KEY(no), product_category INT NOT NULL, product_id INT NOT NULL, product_id), product_id) REFERENCES product(category

CREATE TABLE product ( category INT NOT NULL, id INT NOT NULL, price DECIMAL, PRIMARY KEY(category, id) ) ENGINE=INNODB; CREATE