use_and_drop_anonymous.sql 357 B

123456789101112131415161718192021
  1. /* postgres can not */
  2. /* multirun can not */
  3. use plato;
  4. insert into @tmp select * from Input where key > "100";
  5. commit;
  6. insert into Output
  7. select * from @tmp where key != "150";
  8. drop table @tmp;
  9. commit;
  10. insert into @tmp select * from Input where key > "200";
  11. commit;
  12. insert into Output
  13. select * from @tmp where key != "150";
  14. drop table @tmp;
  15. commit;