Home / Errors / Question No: 30

Does MySQL support dropping and creating functions and procedures in functions? I want to search stored procedures with prepare statement in MySQL-5.0. It seems that can not use 'drop procedure xxx' in prepare statement , like this:

mysql> create procedure drpsp()
-> begin
-> prepare aa from 'drop procedure ct_tb';
-> execute aa;
-> end
-> //
Query OK, 0 rows affected (0.00 sec)

mysql> call drpsp//
ERROR 1295 (HY000): This command is not supported in the prepared statement protocol yet

mysql> drop procedure ct_tb//
Query OK, 0 rows affected (0.00 sec)

the same, "drop function/trigger xxx" is also not supported in prepare statment. Is it a lack of feature in MySQL-5.0 version?

Exactly. MySQL doesn't support dropping and creating functions and procedures or triggers in functions or triggers.