[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 alexis.degrugill...@gmail.com wrote: Hi you should have a look at this http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html

[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

[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 toreachdee...@gmail.com wrote: I have two tables as given below. I need to add a column in project_table which is INT and