>I just wanted to know whether there are any known issues in defining and using Foreign key constraints in MySQL 4 and >MySQL 5. >To be specific, are there any issues on using ON DELETE CASCADE and ON UPDATE CASCADE? > >Would there be any performance issues when we define Foreign key constraints? > >We dont define Foreign Key constraints here. But at the conceptual level we know that there are foreign keys. But we do not >create foreign keys at the physical level. Is this right?
No, that is not "right", cause it means anyone (or any mistake in your software) can still bugger up your data. Make sure to install your constraints, it is able to save you countless hours in the future. Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]