membuat no urut menggunakan query mysql

Catatan : membuat no urut menggunakan query mysql

Bismillah

q> Misalnya ada tabel barang seperti gambar di bawah ini :

SELECT KODE,NAMA,HARGA FROM BARANG;

Selection_675

SELECT
( @NO_URUT := @NO_URUT + 1 ) NO_URUT,
B.KODE, B.NAMA,B.HARGA
FROM BARANG B ,
(SELECT @NO_URUT := 0 ) VARIABLE_URUT

Selection_676

No urut sudah muncul

Alhamdulillah

Published by

saifiahmada

Begin a big Process with a bit trying

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s