SQL之DML

INSERT

INSERT INTO EMPLOYEES VALUES ('Smith', 'John', '1980-06-10', 'Los Angles', 16, 45000);

DELETE

DELETE FROM Person WHERE LastName = 'Rasmussen';

UPDATE

UPDATE Person SET Address = 'Zhongshan 23', City = 'Nanjing' WHERE LastName = 'Wilson'