Mysql zerofill

CREATE TABLE yourtable (x INT(8) ZEROFILL NOT NULL, y INT(8) NOT NULL);
INSERT INTO yourtable (x,y) VALUES
(1, 1),
(12, 12),
(123, 123),
(123456789, 123456789);
SELECT x, y FROM yourtable;

Source: stackoverflow.com

Similar codes

8 votes185 views1 answer
Mac restore mysql database command line
SQL
3 votes194 views1 answer
Oracle apex warn on unsaved changes
SQL
0 vote195 views1 answer
Mysql faster delete
SQL
1 vote159 views1 answer
Median mysql
SQL
3 votes158 views1 answer
V$session not found in oracle
SQL
0 vote141 views1 answer
Get first name and last name from full name string in SQL
SQL
1 vote156 views1 answer
Postgresql define pk sequence next number
SQL
0 vote165 views1 answer
Oracle concat datetime
SQL
10 votes157 views4 answers
SELECT FROM WHERE
SQL
0 vote141 views1 answer
Stuff in sql server
SQL