I tried on MySQL 4.0.12, 4.0.14 and 4.1 and I am getting the same error. Whether these servers were on Windows or on Linux, it does not help. I also initialized the variables but the same error came. I even tried to run the example given in the MySQL documentation with the same results.
MySQL thinks ``:='' is a NULL character. Maybe it's a problem with the character set. Thanks Emery ----- Original Message ----- From: "Pete Harlan" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]> Cc: "Petr Vileta" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, September 23, 2003 18:49 Subject: Re: Using SQL variables > You have to initialize @var to something first, or it's just null. So > try "set @var := 0;" before your query. > > Also, you don't say which version of MySQL you're using, but I'm using > 4.0.14 and I can't say "... as number, * from ...", but have to say > "... as number, tableName.* from ...". > > HTH, > > --Pete > > > On Tue, Sep 23, 2003 at 04:54:03PM +0300, Director General: NEFACOMP wrote: > > Can you run this query and tell me if it works on your machine? > > SELECT (@var := @var + 1) AS Number, * FROM any_table_with_records; > > As per the manual, this should give something like: > > +---------------------- > > Number FieldOne > > 1 Value > > 2 Value > > 3 Value > > ... > > But when I run it the error is :You have an error in your SQL syntax near > > 'NULL @var + 1) AS Number BLAH BLAH BLAH > > > > I have read everything about Using Variables (in the manual) and I apply > > what it says but it can't run. > > Even the simple example given by MySQL > > This is the example MySQL has given in the manual: > > SELECT @t1:=(@t2:=1)[EMAIL PROTECTED]:=4,@t1,@t2,@t3; > > > > When I run this query, the error message is: You have an error in your SQL > > syntax near '(@t2NULL1)[EMAIL PROTECTED],@t1,@t2,@t3' at line 1 > > Where do you think these NULL stuffs are coming from? > > Do I have to change the character set? > > > > > > Thanks > > Emery > > ----- Original Message ----- > > From: "Petr Vileta" <[EMAIL PROTECTED]> > > To: "Director General: NEFACOMP" <[EMAIL PROTECTED]> > > Sent: Tuesday, September 23, 2003 01:45 > > Subject: Re: Using SQL variables > > > > > > > > Can someone tell me what's wrong with my query? > > > > My Query was: > > > > SELECT (@num := @num + 1) as RecNum, AnotherField FROM tbl WHERE > > > condition. > > > > > > > > When I change the := into =, the query returns results with a non > > changing > > > RecNum. > > > Because > > > "=" mean "some IS EQUIAL to another" > > > but > > > ":=" mean "SET MYSQL VARIABLE to some value" > > > > > > Consult your MySQL manual and look for "Using variables" :-) > > > > > > Petr Vileta, Czech republic > > > > > > > > > > > > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]