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

0 vote171 views1 answer
Month mysql
SQL
5 votes150 views2 answers
Oracle rename table
SQL
2 votes137 views1 answer
Oracle generated column
SQL
1 vote89 views1 answer
Full text index mysql
SQL
14 votes163 views3 answers
Inner join sql oracle
SQL
10 votes169 views2 answers
Select nextval from sequence oracle
SQL
0 vote134 views1 answer
Lost connection to mysql
SQL
0 vote156 views1 answer
Sql server phone constraint
SQL
0 vote139 views1 answer
Mysql in clausule string array
SQL
4 votes138 views1 answer
Mysql set max connections
SQL