基础sql语言 增删改查

1.新增表数据 INSERT INTO [TABLE_NAME] (column1, column2, column3,...columnN) VALUES (value1, value2, value3,...valueN); 例:insert into person(id,name,age,phone,address) values (1,'yang',22,'123232323','中国上海'); 2.删除表数据 DELETE FROM [table_name] WHERE [condition]; 例:delete from person where id = 1; 3.修改表数据