Re: drop stored procedures in prepare statment

[Nils Meyer]

Hi Xian,

xian liu wrote:
 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/creating functions/procedures or
triggers in functions or triggers.

regards
Nils


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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附件