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_--