A.truncate table table_name;B.truncate from table_name;C.drop table table_name;D.delete from table_name;
A.update temp set age =18where name =’zhangsan’;B.update table temp set age ==18where name =’zhangsan’;C.update temp set age ==18where name =’zhangsan’;D.update table temp set age =18where name =’zhangsan’;
A.update temp set age =18where name =’zhangsan’age =23;B.update table temp set age =18where name =’zhangsan’and age =23;C.update temp set age =18where name =’zhangsan’and age =23;D.update table temp set age =18where name =’zhangsan’;