Yep,
That's exactly what you are supposed to do. It's just like the old days, we
have to do it manually.
BTW, technically speaking, MySQL does support the concept of FKs. It simply
does not enforce them. The up-side is you will never have a deadlocked
stored procedure in MySQL! :)
But seriously, having designed and coded databases in everything from FoxPro
to Oracle, I can say that I don't miss them. Inn the last database I
worked, on (Oracle) the DA ripped out all the constraints for the sake of
performance. (They do cost and sometimes dearly)
Anyhow, if you feel that you cannot code without them then I suggest either
postGres or Interbase. Both are open source projects and both support FK
constraints.
Cal
http://www.calevans.com
-----Original Message-----
From: vijay khanna [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 10, 2001 9:30 PM
To: mysql (E-mail)
Subject: no forign keys.????
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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
