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]
