立即学习:https://edu.csdn.net/course/play/27328/362520?utm_source=blogtoedu
插入 修改 删除 表格中数据
插入数据:
INSERT INTO table_name(field1,field2,...,fieldN) VALUES (valueA1,valueA2,...,valueAN),(valueB1,valueB2,...,valueBN);
修改数据:
UPDATE table_name SET field=newValue1,field2=newValue2[WHERE Clause];
删除数据:
DELETE FROM table_name [WHERE Clause]