Declaring variables

Hi, I cant declare a varible in mySQL 4
i've tried:

declare [at] id as int
declare [at] id int
declare id int

any ideas?

thaks
santos24 [ Mi, 28 Juni 2006 22:39 ] [ ID #1373515 ]

Re: Declaring variables

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

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

Regards,
Bill K.
Bill Karwin [ Mi, 28 Juni 2006 23:02 ] [ ID #1373517 ]
Datenbanken » mailing.database.mysql » Declaring variables

Vorheriges Thema: Cumulative calculation
Nächstes Thema: column definition that references other data in same row