Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?
I believe the answer is that there isn't a way to fix the syntax for 3.23, because 3.23 simply doesn't support multi-table deletes. An alternative solution is needed. One option would be to do this programmatically. Collect the sectionids with a SELECT, then delete them with a separate
Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?
The Nice Spider wrote: Hi, This query running fine on 4.0.25 but when trying on 3.23 an error occurs. can one help me to find correct command for 3.23? DELETE FROM A USING A RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null This task is deleted any row in A that have no items on
Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?
You are not being honest with us on the list. Firstly, the error you got: You have an error in your SQL syntax near 'USING USING A RIGHT JOIN B ON B.id = A.sectionid' at line 1 SQL=DELETE FROM A USING A RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null indicates that you used the
Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?
This query running fine on 4.0.25 but when trying on 3.23 an error occurs. can one help me to find correct command for 3.23? Probably if you post the error message you get. DELETE FROM A USING A RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null error message on 3.23 is: You have an
How to convert this DELETE command from MySQL 4.0.25 to 3.23?
Hi, This query running fine on 4.0.25 but when trying on 3.23 an error occurs. can one help me to find correct command for 3.23? DELETE FROM A USING A RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null This task is deleted any row in A that have no items on B.
Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?
The Nice Spider schrieb: Hi, This query running fine on 4.0.25 but when trying on 3.23 an error occurs. can one help me to find correct command for 3.23? Probably if you post the error message you get. -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL
Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?
2006-05-02
Thread
Adam i Agnieszka GÄ…siorowski FNORD aka ALinkA ak a symbol '( { .A. } )'' ||~ { A.A }
On 2006-05-02, at 08:51, The Nice Spider wrote: Wow, impressive pseudonym...Are you strong enough to be my man? ;-} DELETE FROM A USING A RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null ...AND the_reader IS a_fool. Hell and damnation! SQL POETRY! :-} This task is