Sadly, MySQL doesn't have (yet) the ROWNUM function. But a simple playing around with variables will give you the desired result.
Here is an example: (Src: dzone)
mysql code
Here is an example: (Src: dzone)
mysql code
SELECT @rownum := @rownum + 1 as rownum, t.* FROM some_table t, (SELECT @rownum := 0) r
thanks this works great
ReplyDeleteWynn's new $3.7 billion Las Vegas casino opened this fall
ReplyDeleteWynn 성남 출장안마 Resorts announced 영주 출장안마 today it will 동해 출장샵 unveil $3.7 여수 출장샵 billion casino project, Wynn Plaza, in the resort's 속초 출장마사지 main lobby,