MySQL删除语句

Question

我正在创建一个数据库，使用 MYSQL 并插入了数据，但是当我尝试删除一行时，我没有运气，有人可以帮助我理解为什么该行不删除吗？我已经为创建的表提供了我使用的插入语句和删除语句，请记住该表显示为已满。

 CREATE TABLE IF NOT EXISTS `new_schema2`.`Employee` (
  `EID` INT NOT NULL,
  `Fname` VARCHAR(45) NOT NULL,
  `Lname` VARCHAR(45) NOT NULL,
  `AddressID` INT NOT NULL,
  `PayLevel` Decimal NOT NULL,
  `Jobtitle` VARCHAR(45) NOT NULL,
  `DateofEmployment` DATE NOT NULL,
  PRIMARY KEY (`EID`))
ENGINE = InnoDB;

#Inserts begin Here
INSERT INTO new_schema2.Employee 
       (EID, Fname, Lname, AddressID, PayLevel, Jobtitle, DateofEmployment) 
       VALUES 
   (    0,'Andrew','Wiggins','7', 10000.00,'Stock Boy','08/11/12' );

INSERT INTO new_schema2.Employee 
       (EID, Fname, Lname, AddressID, PayLevel, Jobtitle, DateofEmployment) 
       VALUES 
       (1,'Andrew','Wiggins','7', 10000.00,'Stock Boy','08/11/12' );

INSERT INTO new_schema2.Employee  
       (EID, Fname, Lname, AddressID, PayLevel, Jobtitle, DateofEmployment) 
       VALUES 
       ('2','Nick','Smith','8', 20000.00,'Cashier','08/10/09' );


 INSERT INTO new_schema2.Employee 
       (EID, Fname, Lname, AddressID, PayLevel, Jobtitle, DateofEmployment) 
       VALUES 
       ('3','Niko','Jackson','9',40000.00,'Manager','05/10/06' );

INSERT INTO new_schema2.Employee 
       (EID, Fname, Lname, AddressID, PayLevel, Jobtitle, DateofEmployment) 
       VALUES 
       ('4','Dante','Henderson','10', 20000.00,'Cashier','06/15/09' );

INSERT INTO new_schema2.Employee 
       (EID, Fname, Lname, AddressID, PayLevel, Jobtitle, DateofEmployment) 
       VALUES 
       ('5','Jessica','Smith','8',22000.00,'Performer','08/09/11' );

INSERT INTO new_schema2.Employee 
       (EID, Fname, Lname, AddressID, PayLevel, Jobtitle, DateofEmployment) 
       VALUES 
       ('6','Alex','Grossi','15',100000.00,'Owner','08/11/02' );

#Delete statements begin here
DELETE FROM new_schema2.employee
WHERE EID = 0 AND Fname='Andrew' AND Lname='Wiggins' AND AddressID='7' AND  DateofEmployment='11/12/08'  AND PayLevel='10000.00'AND  Jobtitle = 'Stock Boy'; 

Answer 1

您不需要在删除中指定所有列

仅使用这个

   DELETE FROM new_schema2.employee
   WHERE EID = 0