is it right that mysql doesnt support any reference integrity ?

It depend on type of database.
I think only InnoDB supports reference integrity...

RTFM

Matt.

sorry, but what do you mean with RTFM ???

Hi mate,

RTFM is an internet acronym that stands for Read The F****** Manual.

(It's not really meant in an offensive manner though, just as 'did you check the manual??', hence the winking smilies).

In my post above, the text is a link to a page in the MySQL manual that details the usage of foreign keys in MySQL. Here's the link again:

http://www.mysql.com/doc/en/InnoDB_f...nstraints.html

Hope this helps.

Regards,

Matt.

http://www.databasejournal.com/featu...le.php/2248101

HTH,
Max