hello .
I am new to mySQL
I am really surprised on mySQL not supporting 'FOREIGN KEYS'.
Like oracle , foreign keys are used to perform on delete cascade to child tables,
which eventually performs
a delete operation on child table , if any primary key row is deleted from the Parent
table.
I was reading the mySQL documentation where mySQL believes in 'atomic operation' and
claims to obtain
miraculous results in SQL query time performance.
But, what if I have 100 tables in my database which are interrelated..?
Does mySQL wants me to fire more 99 extra SQL queries to the server if I wish to
delete a single row from my Parent table , in order to delete dependant rows..?????
Please guide me.
Thanx
Vj