how to add foreign key in alter command

how to add foreign key in alter command

am 17.05.2009 08:25:55 von Nathan Huang

Hi guys
Please tell me the command syntax, how to add a colmmen foreign key in
alter syntax
thanks

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: how to add foreign key in alter command

am 17.05.2009 11:02:22 von abdulazeez alugo

--_2374c17d-f02a-4f06-b43f-01a85de33c92_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



=20

> Date: Sun=2C 17 May 2009 14:25:55 +0800
> From: nathan.vorbei.tech@gmail.com
> To: mysql@lists.mysql.com
> Subject: how to add foreign key in alter command
>=20
> Hi guys
> Please tell me the command syntax=2C how to add a colmmen foreign key in=
=20
> alter syntax
> thanks
>=20


Hello Nathan=2C

=20

Try the syntax below:

ALTER TABLE tbl ADD foreign key(x) references(x)=3B

N.B: Where (x) is your foreign key.

Hope that helps.

=20

Greetings from Nigeria.

Alugo Abdulazeez

www.frangeovic.com

____________________________________________________________ _____
Show them the way! Add maps and directions to your party invites.=20
http://www.microsoft.com/windows/windowslive/products/events .aspx=

--_2374c17d-f02a-4f06-b43f-01a85de33c92_--