1 2 3 4 5 6 7 8 9
USE plato; define subquery $f() as SELECT * FROM Input end define; insert into Output with truncate select * from $f()