[symfony-users] Re: Add Foreign Key to mysql table

Hi, The problem is solved when I run below command ALTER TABLE projecttype_table TYPE=InnoDB; Thanks Deepak Bhatia On 4/2/09, whalexis wrote: > > > Hi you should have a look at this > http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html > Everything you need is there > >

[symfony-users] Re: Add Foreign Key to mysql table

Hi you should have a look at this http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html Everything you need is there On Apr 2, 4:10 am, DeepakBhatia wrote: > I have two tables as given below. I need to add a column in > project_table which is INT and refers to the projectty

[symfony-users] Re: Add Foreign Key to mysql table

I have two tables as given below. I need to add a column in project_table which is INT and refers to the projecttype_table(id) field. project_table { Name Varchar(100) } projecttype_table { id INT AUTO INCREMENT NOT NULL, projecttype_name Varchar(50) } Approach #1 === mysql> alter tabl