create table t1 (id int)
insert tabel t2 values(2)--error
create table t2 (id int)--don't execute
--------------------------
select * from t1
select * from t2 ---error
select * form t1 ---don't execute
----------------------
drop table t2---error
drop tbale t1--execute
------------------------
请问这是一个什么样的原因，导致第三块drop 执行了

你语法错误，应该为
create table t1 (id int)
insert tabel t2 values(2)--改为：insert into t2 values(2)
create table t2 (id int)--don't execute
--------------------------
select * from t1
select * from t2
select * form t1 --改为 select * from t1
----------------------
drop table t2---error
drop tbale t1--改为drop table t1