mirror of
https://github.com/MariaDB/server.git
synced 2025-02-04 21:02:17 +01:00
6 lines
209 B
SQL
6 lines
209 B
SQL
--let $query= CREATE PROCEDURE p1() AS var $type; rec ROW(var $type); BEGIN CREATE TABLE t1 AS SELECT var,rec.var FROM DUAL;END
|
|
--eval $query
|
|
CALL p1();
|
|
SHOW CREATE TABLE t1;
|
|
DROP TABLE t1;
|
|
DROP PROCEDURE p1;
|