Re: stored procedure and create table

[Robin Schumacher]

Christian -

Are you sure your source table exists in the database from which you're working? If my test table (t1) exists in the database, my call goes fine; if not, I get your error:

mysql> CREATE PROCEDURE show_test()
-> BEGIN
-> DROP TABLE IF EXISTS temp_show;
-> CREATE TABLE IF NOT EXISTS temp_show AS SELECT * FROM t1
-> ;
-> END
-> //
Query OK, 0 rows affected (0.00 sec)

mysql> call show_test() //
Query OK, 0 rows affected (0.02 sec)

mysql> drop table t1 //
Query OK, 0 rows affected (0.00 sec)

mysql> call show_test() //
ERROR 1146 (42S02): Table 'test.t1' doesn't exist
mysql>