From dba3868523674d9871de6444823ad6f869c7c69b Mon Sep 17 00:00:00 2001 From: "heikki@hundin.mysql.fi" <> Date: Wed, 2 Oct 2002 20:54:21 +0300 Subject: manual.texi: InnoDB does allow a foreign key constraint name to be specified --- Docs/manual.texi | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Docs/manual.texi b/Docs/manual.texi index e655c0c9a67..2d35dd5302c 100644 --- a/Docs/manual.texi +++ b/Docs/manual.texi @@ -39260,7 +39260,7 @@ constraints to guard the integrity of your data. The syntax of a foreign key constraint definition in InnoDB: @example -FOREIGN KEY (index_col_name, ...) +[CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...) REFERENCES table_name (index_col_name, ...) [ON DELETE CASCADE | ON DELETE SET NULL] @end example @@ -39319,7 +39319,7 @@ Starting from version 3.23.50 InnoDB allows you to add a new foreign key constraint to a table through @example ALTER TABLE yourtablename - ADD CONSTRAINT FOREIGN KEY (...) REFERENCES anothertablename(...) +ADD [CONSTRAINT symbol] FOREIGN KEY (...) REFERENCES anothertablename(...) @end example Remember to create the required indexes first, though. -- cgit v1.2.1