SQL语句详解

2. DDL语句

·Insert Into [表名]（字段1，字段2...）Values（值1，值2...）（值1，值2...） 添加数据

insert into testtable (id, name) values (1,'Tom'),(2,'Lisa'); 
select * from testtable; //用于展示testtable中的所有内容

·Update [表名] Set 字段1 = 值1，字段2 = 值2 [Where 条件] 修改数据

update testtable set name = 'Sam' where id = 1;
select * from testtable;

·Delete From [表名][Where 条件] 删除数据

delete from testtable where id = 2;
select * from testtable;