> Date: Sun, 17 May 2009 14:25:55 +0800
> From: nathan.vorbei.t...@gmail.com
> To: mysql@lists.mysql.com
> Subject: how to add foreign key in alter command
>
> Hi guys
> Please tell me the command syntax, how to add a colmmen foreign key in
> alter syntax
> thanks
>
Hello Nathan,
Try the syntax below:
ALTER TABLE tbl ADD foreign key(x) references(x);
N.B: Where (x) is your foreign key.
Hope that helps.
Greetings from Nigeria.
Alugo Abdulazeez
www.frangeovic.com
_________________________________________________________________
Show them the way! Add maps and directions to your party invites.
http://www.microsoft.com/windows/windowslive/products/events.aspx