mysql question v6

[Richard B. Bartels]

Biar nilai data dalam field bisa terisi campuran antara huruf dan angka secara berurutan gmn…??

Seperti yg di field C

(nilai pada filed C di ambil dari field A trsu dikasih nomer urut gtu)

 

A	B	C
A	B	A1
A	B	A2
B	B	B1
C	B	C1

 

[Teguh Susanto]

SELECT a.kolomA,a.kolomB,concat(a.kolomA,(SELECT row_number FROM <table> b WHERE b.kolomA=a.kolomA)) kolomC FROM <table> a

2009/8/23 Richard B. Bartels <barts...@gmail.com>

--
---------------------------------------------------------
Teguh Susanto
IT/SIM Staff
Jogja International Hospital
Jl.Ring Road Utara No. 160
Condong Catur,Depok,Sleman,Yogyakarta 55283
telp : 0274-4462879 ext 609
website : www.rs-jih.com
email : teg...@rs-jih.com
blog : medicalenvironment.blogspot.com