Foreign key constraints - Known issues ?

2007-07-19 Thread Ratheesh K J
Hello All,

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?


Thanks  Regards,
Ratheesh

Re: Foreign key constraints - Known issues ?

2007-07-19 Thread Martijn Tonies
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]