Can anyone help me? I have created a table and with a primary key called "ID". However, I want the "ID" be auto increment as well.
Here is my question, how can I do in the following format:
"PIC0001", "PIC0002", "PIC0003", ............ etc.
Anyone can help me?