Re: How to On DELETE CASCADE

2002-07-04 Thread Egor Egorov
multivac, Thursday, July 04, 2002, 12:22:42 AM, you wrote: m> I'm quite new in MySQL and PHP, so I guess my question is stupide. Sorry m> for that but I really need the solution... m> I have 2 tables [skip] m> The primary Keys are ClientID on table Client and CommandID on table m> Command. m>

Re: How to On DELETE CASCADE

2002-07-03 Thread Bhavin Vyas
You can use the InnoDB table type which supports foreign keys. http://www.mysql.com/doc/S/E/SEC446.html If you want to use MyIsam table types, the only solution is to send a specific request to delete records in both the tables. Regards, Bhavin. - Original Message - From: "multivac" <[EMA