Hi all, I make a new delete query (mysql 4.02) delete t1,t2 from t1,t2 ....
i t takes a long it displays 100931 rows affected. i count all the rows into t1 it give the same result before the delete. I make a du -h of the database dir it give the same results ?. So i have some doubt (it seems to not work) I make the queries it again 0 rows affected. it seems to work. And when selecting rows that should be deleted it gives me these rows ? I think there a bug in this new functonnality ! Making three deletes (for my three tables) is very long ! Thanks. _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- 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
