mysql select auto increment number

[thondchen]

mysql select auto increment number

http://idanny.blogspot.tw/2013/09/mysql-select.html

[thondchen]

http://stackoverflow.com/questions/11861799/mysql-query-to-select-results-with-auto-increment-as-a-new-column-added-in-the-r

[thondchen]

ex:

SELECT @s:=@s+1 serial_number,student_id,student_name,student_avg FROM students, (SELECT @s:= 0) AS s WHERE student_avg > 4;

this is will fail in view, need use uuid_short

[thondchen]

select uuid_short()