Errors?

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 */;;

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.

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?

"tns" <cbdiets@hotmail.com> wrote:
> 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?

You haven't told us which RDBMS you are using. In any case it's
off-topic, but as asked, the question is unanswerable.

miguel
--
Photos from 40 countries on 5 continents: http://travel.u.nu
Latest photos: Malaysia; Thailand; Singapore; Spain; Morocco
Airports of the world: http://airport.u.nu

tns wrote:
> 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_US ER"*/;;
>>>/*!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?
>

You might try asking in a mysql newsgroup - such as comp.databases.mysql.

This newsgroup is for php questions.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================