Hi, > I am new to mysql. I am trying to create tables with foreign key constraints. > but the constraintsdoesnt seem to be showing any effect on the table. I am > able to add any info in the foreign key table witout the same info in the main > table. > > what is the problem??
1) are you running the InnoDB version of MySQL? 2) are you using InnoDB tables? If (1) and (2) are not satisfied, MySQL will parse your SQL and totally ignore everything that has to with Foreign Keys. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]