1 year ago

#355179

test-img

Damidu Shalinda

auto filling varchar column in MySQL

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.

mysql

auto-increment

0 Answers

Your Answer

Accepted video resources