Query for generate increament Row Number Column
try this query code :
select @rownum:=@rownum+1 ’NO’, p.barang_name from barang p, (SELECT @rownum:=0) r order by barang_name asc limit 5;
result :
NO | barang_name
---------------------
1 | Barang name 1
2 | Barang name 2
3 | Barang name 3
4 | Barang name 4
5 | Barang name 5
Leave a Comment