insert:
INSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....)
update:
UPDATE Person SET Address = 'Zhongshan 23', City = 'Nanjing' WHERE LastName = 'Wilson'
delete:
DELETE FROM Person WHERE LastName = 'Wilson'
insert:
INSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....)
update:
UPDATE Person SET Address = 'Zhongshan 23', City = 'Nanjing' WHERE LastName = 'Wilson'
delete:
DELETE FROM Person WHERE LastName = 'Wilson'
转载于:https://www.cnblogs.com/zhima-hu/p/7998529.html