delete from my_employees;
select * from my_employees;
显示:数据全没了
select * from my_employees;
显示:数据全是delete之前的[/quote]
再比如:
update my_employees
set salary =1000
where id =1;
select * from my_employees;
显示:id为1的salalry 1000
select * from my_employees;
显示: id为1的salary 850(改之前的数据)