RESTRICT: The change on the parent table is prevented.The allowed actions for ON DELETE and ON UPDATE are: A TRUNCATE TABLE against a table containing one or more foreign keys is executed as a DELETE without WHERE, so that the foreign keys are enforced for each row.Trying to drop a table that is referenced by a foreign key produces a 1217 error ( SQLSTATE '23000'). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |