Re: drop stored procedures in prepare statment

2007-03-07 Thread 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

drop stored procedures in prepare statment

2007-03-06 Thread 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 - //