• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

mysql autoincrement custom key e.g 00001,000002 is this in sql?

 
chrstian ferma
Ranch Hand
Posts: 72
Eclipse IDE Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
help can i make this in sql? when i enter a value it will auto increment into 0001,0002,0003,0004? i already tried this but in 1,2,3,4,5,6,7 thank you
 
Swastik Dey
Rancher
Posts: 1637
6
Android Java Java ME
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I believe you need to produce the output in that format, right? So, instead of storing it in that format why not format it while you display the output.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic