What is the benefit of zerofill in MySQL?
When you select a column with type ZEROFILL it pads the displayed value of the field with zeros up to the display width specified in the column definition. Values longer than the display width are not truncated. Note that usage of ZEROFILL also implies UNSIGNED. Using ZEROFILL and a display width has no effect on … Read more