drop stored procedures in prepare statment

[xian liu]

hi guys,
   
  I'm searching stored procedures with prepare statment in mysql-5.0.
  It seems that can not use 'drop procedure xxx'  in prepare statment , 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 ??
   
  Thanks!


@@@^_^@@@
                
---------------------------------
 雅虎免费邮箱-3.5G容量，20M附件