In MySQL, what is the "zerofill" column attribute exactly and when should it be used?
Example: You have a varchar column that can hold 10 spaces/digits, you put something in it that is only 3 digits (123) it does this: 0000000123 When it should be used is really up to you.
Common use is when you are building an IDNumber and you want them to look and sort correctly:
'9' will sort after '10' because they are strings, not numbers.
but
'09' will sort before '10' as you probably want.
