Bug #45315 rownumber not increase, use select (@s = @+1) as rownumber, others from tbl1 ,
Submitted: 3 Jun 2009 22:55 Modified: 4 Jun 2009 5:35
Reporter: liu yj Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:5.1.34 OS:Windows
Assigned to: CPU Architecture:Any

[3 Jun 2009 22:55] liu yj 
Description:
rownumber not increase, use select (@s = @s+1) as rownumber, others from tbl1 , 

How to repeat:
use :

set @s =0 ;
select (@s=@s+1 ) as rownum ,others from table1

result : rownum allways 0.
[4 Jun 2009 5:35] Sveta Smirnova 
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

You have syntax error. Correct syntax is "@s:=@s+1"