Declaring variables

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

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

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

any ideas?


Re: Declaring variables wrote:
Quoted text here. Click to load it

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

Bill K.

Site Timeline