You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 

8 lines
271 B

use test;
drop table if exists t;
create table t(a bigint, b bigint);
explain insert into t values(1, 1);
explain insert into t select * from t;
explain delete from t where a > 100;
explain update t set b = 100 where a = 200;
explain replace into t select a, 100 from t;