表记录的增删改
增加一条记录:
Insert into table_name (field1,field2,…,fieldn) values (value1,value2,…,valuen);
- 添加一条记录
insert into em (name,bouns,salary) values("John",350,8000);
修改表记录:
Update table_name set fieldx="valuex",fieldx1="valuex1" where field1="value1";
- 修改表记录
update em set bouns=200, salary=10000 where id=2;
删除表记录:
-
根据条件删除记录
delete from table_name [where ...]
-
删除说有记录(一条一条的删除
Delete from table_name;
-
删除所有记录–初始化一张同名新表
truncate table table_name;