Multi-Table Delete with MySQL 3.23.51

Guys, I know that version 3.23.51 of MySQL does not handle deleting data from multiple tables directly. I am in a situation where i have to delete millions of records from a dozen tables. The delete logic is not simple, i have to check a number of tables before i can actually delete a row from a

RE: Bug with multi-table DELETE in MySQL 4.0.1

Leeuw van der, Tim writes: Hello, Thank you very much for your reply! I was hoping that this was indeed fixed in 4.0.2. I was using 4.0.0 when the bug occurred and upgraded today to 4.0.1; I will retest the query with 4.0.2 as soon as it's released. Apologies btw for not mentioning the

bug in multi-table delete in MySQL-4.0.2 ?

Hi, I'm just testing the new multi-table delete in MySQL-4.0.2 and I wonder if I'm doing something wrong with this query : mysql DELETE FROM searchmainhardwarefr2,searchjoinhardwarefr2 USING searchmainhardwarefr2 as a,searchjoinhardwarefr2 as b,forumconthardwarefr2 as c WHERE b.numreponse

Re: multiple delete for mysql

I have : mysql select version(); +---+ | version() | +---+ | 4.0.2-alpha-debug | +---+ 1 row in set (0.00 sec) But an error too : mysql delete - from - externallink as link, - topic as topic, - topiclink as joiner

Re: multiple delete for mysql

David, Wednesday, April 03, 2002, 3:30:52 PM, you wrote: Dy I have : Dy mysql select version(); Dy +---+ Dy | version() | Dy +---+ Dy | 4.0.2-alpha-debug | Dy +---+ Dy 1 row in set (0.00 sec) Dy But an error too : Dy mysql delete Dy

RE: multiple delete for mysql

mysql version 4.x does this -Original Message- From: David yahoo [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 5:28 PM To: [EMAIL PROTECTED] Subject: multiple delete for mysql Hi all, How can i do a delete from multiple table in mysql? Eg : I want ot delete record

multiple delete for mysql

Hi all, How can i do a delete from multiple table in mysql? Eg : I want ot delete record something like that I dont when to select but delete delete from externallink as link, topic as topic, topiclink as joiner where link.resid = joiner.resid and topic.catid = joiner.catid and topic.rid like

delete old mysql users

Hello, I have a system running MySQL with old user accounts I wish to remove. I am looking for a command to delete all user that do not have access to any databases. Does anyone know of such a command ?? With Thanks, Steve.

RE: delete old mysql users

] Subject: delete old mysql users Hello, I have a system running MySQL with old user accounts I wish to remove. I am looking for a command to delete all user that do not have access to any databases. Does anyone know of such a command ?? With Thanks, Steve

Re: delete old mysql users

Steve Wright queried I am looking for a command to delete all user that do not have access to any databases. Does anyone know of such a command ?? Off-the-wall answer from a newbie: Since the user information is kept in a table, it should be fairly easy to build a short MySQL script to do

Re: delete in mysql

At 10:56 AM +0200 4/24/01, Sven Heising wrote: Hi list When posting help requests, it's always helpful to include the error message you get. You can check quickly this via something like: mysql_query(DELETE FROM $dtable where loginid = '$userto' ) or mysql_error(); One possible