Home How to automatically generate a unique identification in MySQL like S000012?
Reply: 0

How to automatically generate a unique identification in MySQL like S000012?

t. tivorc
1#
t. tivorc Published in 2017-12-07 18:33:20Z

I want to automatically generate a code for a student. Example:

| id      | code    |
| 1       | S000001 |
| 3       | S000003 |
| 14      | S000014 |

Does anyone have suggestions?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.309392 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO