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 vote274 views1 answer
Kill slow queries mysql
SQL
0 vote241 views1 answer
Output to file mysql
SQL
7 votes264 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote309 views1 answer
How to find unique element in sql
SQL
0 vote235 views1 answer
Import all databases mysql
SQL
0 vote258 views1 answer
Mysql read row
SQL
0 vote254 views1 answer
Denormalise SQL command
SQL
1 vote268 views1 answer
Rails run native ssql query
SQL
32 votes274 views6 answers
How to change column name in sql
SQL
0 vote287 views1 answer
Sql datum formatieren
SQL