Modify mysql tp add prefix and to be autoincremented to mysql field -


is there option alter table gather required functionality ?

my table has id(int), pal_id(varchar,50) ... @ time id autoincremented unique , key, need make pal_id auto incremented, field values has prefix ex: pal0001

i have tried solution how make mysql table primary key auto increment prefix doesnt work me.


Comments

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

python Tkinter Capturing keyboard events save as one single string -

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -