Gossamer Forum: General: Databases and SQL: Re: [Paul] Delete query not working: Edit Log

Gossamer Threads

Home : General : Databases and SQL :

General: Databases and SQL: Re: [Paul] Delete query not working: Edit Log

Here is the list of edits for this post

Jan 21, 2003, 1:59 PM

WoSkI

User (57 posts)

Jan 21, 2003, 1:59 PM

Re: [Paul] Delete query not working

i just about memorized that page yesterday trying to do it, but that was no help. And ive taken that field out of it as well and it still dont work, gives same old error.
Ive tried.

DELETE FROM cartcontents.*
sid RIGHT JOIN cartcontents ON sid.sid_sid = cartcontents.carsid
WHERE sid.sid_sid Is Null

DELETE FROM cartcontents
RIGHT JOIN cartcontents ON sid.sid_sid = cartcontents.carsid
WHERE sid.sid_sid Is Null

and a few other combinations, all give the same error. Another thing im thinking of is does MySQL support this type of delete query?

Last edited by:

WoSkI: Jan 21, 2003, 2:02 PM

Edit Log:

Post edited by WoSkI Post edited by WoSkI (User) on Jan 21, 2003, 2:01 PM
Post edited by WoSkI Post edited by WoSkI (User) on Jan 21, 2003, 2:02 PM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676