auto filling varchar column in MySQL

Asked Mar 30 '22 at 15:55

Active Mar 30 '22 at 15:55

Viewed 12 times

StudentID	Name
stu001	Ann
stu002	James

I want to create a table with auto filling StudentID column (it's a varchar column).

I found various methods to use identity in SQL Server. but I couldn't find anything similar in MySQL. can I do it with using Auto increment? I think we can use auto increment only with INT.

asked Mar 30 '22 at 15:55

Damidu Shalinda

You can do it with a `BEFORE INSERT` trigger. – Barmar Mar 30 '22 at 15:59
But why do this? Why not just use a normal `AUTO_INCREMENT` column? If you also want a string, you can use a generated column that combines `stu` with the numeric ID. – Barmar Mar 30 '22 at 16:00
@Barmar, Have you tried this with a trigger or a generated column? – Bill Karwin Mar 30 '22 at 16:03

auto filling varchar column in MySQL

0 Answers0