Selasa, 08 Juni 2010
Generate ID
Berikut query simple yang gwe buat untuk membuat Generate ID untuk aplikasi Retur
select concat('RTR-',date_format(now(),'%y%m%d'),'-',(count(0) + 1)) AS rcvid
from receive
where (receive.idate = curdate())
hasilnya kira2 begini : RTR-10Jun09-1
select concat('RTR-',date_format(now(),'%y%m%d'),'-',(count(0) + 1)) AS rcvid
from receive
where (receive.idate = curdate())
hasilnya kira2 begini : RTR-10Jun09-1
Langganan:
Posting Komentar (Atom)
0 comments:
Posting Komentar