How do you fill in or pad a column with zeros with a MySQL query?

Question

I've got a large table (~10,000) and I need one column to take up exactly three spaces. It almost always only takes up one space, but I need the other two spaces to be filled in with zeros (it's an integer column). is there a function for that?

Answer 1

Why would you do this? If it is because you want some report that queries the table to display one digit values as 3 digits, add the padding zeroes when you display it. Don't mix display information into your data.

Answer 2

Add ZEROFILL attribute to the int column.