Connecting Tech Pros Worldwide Forums | Help | Site Map

Declaring variables

santos24@gmail.com
Guest
 
Posts: n/a
#1: Jun 28 '06
Hi, I cant declare a varible in mySQL 4
i've tried:

declare @id as int
declare @id int
declare id int

any ideas?

thaks


Bill Karwin
Guest
 
Posts: n/a
#2: Jun 28 '06

re: Declaring variables


santos24@gmail.com wrote:[color=blue]
> Hi, I cant declare a varible in mySQL 4
> i've tried:
>
> declare @id as int
> declare @id int
> declare id int
>
> any ideas?[/color]

DECLARE only works in stored routines, which is a feature introduced in
MySQL 5.

Regards,
Bill K.
Closed Thread