Re: Re: Fwd: urgent: problem in deleting multi table

2002-07-29 Thread Sinisa Milivojevic
Thank you for your fine bug report, thanks to which, I was able to fix a problem. Final fix will come up in 4.0.3, but this is a patch that fixes it temporarily : = /mnt/work/mysql-4.0/sql/sql_delete.cc 1.80 vs edited = *** /tmp/sql_delete.cc-1.80-1656Tue Jul 23 18:31:17 2002

Problem in deleting multi table

2002-07-24 Thread Michael Widenius
Hi! Minjie == Minjie Qiu [EMAIL PROTECTED] writes: Minjie Hello, Minjie I'm working on a purge utility to purge 3 tables: call_record, Minjie modem_call_rec and makrup. Those 3 tables are related with foreign key Minjie recid, so I used the following sql to purge data that is older than 30

urgent: problem in deleting multi table

2002-07-23 Thread Minjie Qiu
Hello, I'm working on a purge utility to purge 3 tables: call_record, modem_call_rec and makrup. Those 3 tables are related with foreign key recid, so I used the following sql to purge data that is older than 30 days: delete call_record, modem_call_rec, markup from call_record,