Declaring variables

Subject

Author

Date

santos24

06-28-2006

Bill Karwin

Posted by santos24 on June 28, 2006, 4:39 pm

Please log in for more thread options

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

Posted by Bill Karwin on June 28, 2006, 5:02 pm

Please log in for more thread options

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.

Similar Threads	Posted
Macro Variables	April 18, 2006, 11:37 am
Inserting variables in mySQL table!	June 25, 2005, 9:11 am
Replace variables in resulting query	July 25, 2006, 12:58 pm
User defined variables question	July 10, 2007, 8:20 pm
Reading Variables available in shell program into MySQL	September 26, 2005, 12:39 am
Help with Stored Proc in mysql varchar variables	August 29, 2006, 4:36 am
MySQL variables, modifying Microsoft SQL sequence insert for use in mysql	October 7, 2005, 10:54 am

Our other projects:

XML Sitemap