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 vote136 views1 answer
Connect to nginx server mysql remotly
SQL
0 vote175 views1 answer
Ms sql print more than 1 variable
SQL
0 vote160 views1 answer
Mysql where sum > 0
SQL
0 vote174 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote125 views1 answer
Restart sql server command line linux
SQL
0 vote328 views1 answer
Redirection 301 htaccess nom de domaine
SQL
5 votes132 views2 answers
Update all rows mysql
SQL
0 vote87 views2 answers
Delete query sql server
SQL
0 vote152 views1 answer
Mysql aspas simples
SQL
0 vote166 views1 answer
Offset in postgresql example
SQL