Declaring variables

am 28.06.2006 22:39:30 von santos24

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

Re: Declaring variables

am 28.06.2006 23:02:07 von Bill Karwin

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

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

Regards,
Bill K.