Thread: Zeros in query?
View Single Post
Old 09-30-2007, 07:24 PM   #2 (permalink)
Karl
The Reckoner
Advanced Programmer Top Contributor 
 
Karl's Avatar
 
Join Date: Sep 2007
Posts: 437
Thanks: 22
Karl is on a distinguished road
Default
When your adding the column simply specify zerofill, such as:

Code:
post_code int(6) zerofill default NULL
Karl is offline   		Reply With Quote