MySQL Forums
Forum List  »  Newbie

DELTE with multiple conditions same column does not execute
Posted by: Gideon Engelbrecht
Date: July 13, 2022 02:20AM

MySQL does not execute the following query :

DELETE FROM debiteure
WHERE groepnaam <> 'SUBSIDIARY' AND
groepnaam <>'UITVOER - ZAR' AND
groepnaam <>'BULK WINE' AND
groepnaam <>'UITVOER - EURO' AND
Debiteur = 'Cash-Kelder' ;

No error messages are display - just no result. Safe Update in workbench is unchecked. What am I missing?

The create statement for the table is :

CREATE TABLE `debiteure` (
`DebiteureID` int NOT NULL AUTO_INCREMENT,
`Debiteur` varchar(20) DEFAULT NULL,
`Naam` text,
`Groepnaam` text,
`VerkopeAreaNaam` text,
`VerkopeGroepNaam` text,
`VerkopeLGroepNaam` text,
`Voorraadklas` text,
`Afleweringsadres` varchar(45) DEFAULT NULL,
`AlkoholTipe` text,
`InUit` varchar(45) DEFAULT NULL,
`PadRoete` varchar(45) DEFAULT NULL,
`SeeRoete` varchar(45) DEFAULT NULL,
PRIMARY KEY (`DebiteureID`),
UNIQUE KEY `DebiteureID_UNIQUE` (`DebiteureID`)
) ENGINE=InnoDB AUTO_INCREMENT=10972 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


Regards

Options: ReplyQuote


Subject
Written By
Posted
DELTE with multiple conditions same column does not execute
July 13, 2022 02:20AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.