Declaring variables

[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

[Bill Karwin]

sa******@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.