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

1 vote306 views1 answer
Psql search table
SQL
5 votes293 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote293 views1 answer
Jdbc sql connection string
SQL
0 vote297 views1 answer
When mysql server would not work in xampp
SQL
0 vote298 views1 answer
Sql select most frequent value in column
SQL
2 votes296 views2 answers
Change mysql password from command line
SQL
0 vote302 views1 answer
Sql select random procentage from rows
SQL
1 vote308 views1 answer
Oracle undo usage per session
SQL
0 vote294 views1 answer
Mysql could not fetch tables
SQL
6 votes297 views5 answers
Mysql get last insert id
SQL