Posted by tns on 08/08/06 12:39
Armando Padilla wrote:
> tns wrote:
> > The following code produces an error when I try to run it under
> > putty.exe (telent connection to mysql database). Can anyone identify
> > the error in the code? The server is running PHP5.
> >
> > Thanks
> >
> > DELIMITER ;;
> > /*!50003 DROP PROCEDURE IF EXISTS `aaa` */;;
> > /*!50003 SET SESSION
> > SQL_MODE="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER"*/;;
> > /*!50003 CREATE PROCEDURE `aaa`()
> > begin
> > declare iTest int;
> > set iTest = 5;
> > end */;;
> >
> This isnt php code (i think you know this already) its a stored
> procedure in SQL.
Check that :). is there something obviously wrong with the syntax?
Navigation:
[Reply to this message]
|