Creating Custom Automated Serial No in MySQL

Asked Jan 11 '22 at 05:31

Active Jan 11 '22 at 05:31

Viewed 70 times

The Roll No Format for my dataset is 'AC-1201', 'AC-1202', ........ I want to generate the Roll No automatically. I can find various answers to generate serial no like 1, 2, 3, ...., but, that's not what I need.

I think I have to concatenate AC-12 before every generated serial no or something like that. I'm not able to do it so as I'm a beginner.

MySQL version 8.0.27. I am using it in the terminal for learning purpose. Any help will be appreciated.

asked Jan 11 '22 at 05:31

Amartya Sinha

1

Store autoincremented integers 1,2,3 and create your custom number from this value in the query which retrieves the data. – Akina Jan 11 '22 at 05:36
1

https://stackoverflow.com/questions/17893988/how-to-make-mysql-table-primary-key-auto-increment-with-some-prefix – Indra Jan 11 '22 at 05:44
What do you of assigning after `AC-1299` ? – Barbaros Özhan Jan 11 '22 at 06:21
@BarbarosÖzhan My class only has 50 students. So, this situation will never arise and this dataset is just for learning purposes. – Amartya Sinha Jan 11 '22 at 06:43
@Indra Ok, I'll try that answer – Amartya Sinha Jan 11 '22 at 06:43
@Akina thanks for the solution, but a little bit more elaboration will help me as I have already mentioned, I'm a beginner. – Amartya Sinha Jan 11 '22 at 06:45
https://dbfiddle.uk/?rdbms=mysql_8.0&fiddle=5b86289f917298d72dc27afa818aeb59 – Akina Jan 11 '22 at 06:56

Creating Custom Automated Serial No in MySQL

0 Answers0