bikin id kombinasi huruf dan angka ??

[Qonita Hanifah]

salam..

saya newbie..salam kenal semua nya,,

baru gabung langsung tanya gpp yah..

mau tanya...kalo di mysql mau bikin No.ID pke kombinasi huruf dan angka gimana settingan nya ya??

misal: format ID nya : AB-000

nah, mau di autoincrement juga..

biar otomatis nambah 1 angka..jdi AB-001 dst....

mohon pencerahan nya,,

terima kasih banyak... :-)

[aceng nursamsudin]

Pake prosedur ato function buat bikin ny

--
You received this message because you are subscribed to the Google Groups "Belajar SQL" group.
To unsubscribe from this group and stop receiving emails from it, send an email to belajar-sql...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.