Demystifying MySQL int(num)
and the Power of Zerofill
1. Confusion
Recently, I encountered a situation where a user_id
field needed to be added to a table, and this field could potentially have large values. So, I submitted an SQL request to alter the…