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

Asked Aug 14 '17 at 19:24

Active Aug 14 '17 at 19:45

Viewed 28 times

Is there a option to alter my table to gather the required functionality ?

My Table has id(int), pal_id(varchar,50) ... At this time id is autoincremented as unique and key, but i need also to make pal_id to be auto incremented, but the field values has a prefix ex: PAL0001

I have tried the solution from How to make MySQL table primary key auto increment with some prefix but it doesnt work for me.

edited Aug 14 '17 at 19:45

cn007b

16,596
7
59
74

asked Aug 14 '17 at 19:24

JamesDooh

1

There are a number of usable answers on the question you linked. What did you try, and how did it not work? – Kai Aug 14 '17 at 19:28
A `view` might be a better choice. – Paul Spiegel Aug 14 '17 at 20:14
If you're using MySQL 5.7 you could create a calculated column. – Barmar Aug 14 '17 at 20:30
@Barmar "The AUTO_INCREMENT attribute cannot be used in a generated column definition." :-( – Paul Spiegel Aug 14 '17 at 21:29

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

0 Answers0