Hi all this is what Mysql Reference Manual tells me about creating foreign keys. I understood how to use them, except for the restrict here -------\ | [CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...) | REFERENCES table_name (index_col_name, ...) | [ON DELETE {CASCADE | SET NULL | NO ACTION | | RESTRICT}] <----------------------X [ON UPDATE {CASCADE | SET NULL | NO ACTION | | RESTRICT}] <----------------------/
WHat are they? what's the use of them ? Thank you ! Alx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]