On Tue, 6 Jan 2004, Luc Foisy wrote:
> There was a user comment under the Foriegn Key section of the documentation reading:
> To restore from a mysqldump file that uses foreign keys:
>
> mysql> SET FOREIGN_KEY_CHECKS = 0;
> mysql> SOURCE your_dump_file;
> mysql>
There was a user comment under the Foriegn Key section of the documentation reading:
To restore from a mysqldump file that uses foreign keys:
mysql> SET FOREIGN_KEY_CHECKS = 0;
mysql> SOURCE your_dump_file;
mysql> SET FOREIGN_KEY_CHECKS = 1;
The command I am looking for is the ca
D.K.Dubey,
Monday, July 01, 2002, 2:13:25 PM, you wrote:
DKD> Thanks, I m using MySQl 3.23. Will u please tell me how it is possible.
It's possible to set ON DELETE CASCADE since 3.23.50:
http://www.mysql.com/doc/S/E/SEC446.html
--
For technical support contracts, goto https://order.
Hi Arul,
Thanks, I m using MySQl 3.23. Will u please tell me how it is possible.
Regards
D K Dubey
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the l
Hi Dubey
Actually foreign keys are supporte dfor INNODB Table types..
Whats the version of MYSQL u r using
-Arul
- Original Message -
From: "D.K.Dubey" <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Sent: Monday, July 01, 2002 4:18 PM
Hi All,
Can anybody tell mysql supports foreign constraints. If i use Referential
Integrity cascade then, will MySql delete the same record in another table?
Thanks in advance.
Regards
Daya Krishan Dubey
-
Before posting, plea
