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 vote161 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote202 views1 answer
Osm2pgsql mac
SQL
0 vote145 views1 answer
How to select only a certain date sql
SQL
0 vote163 views1 answer
Mssql + bit + in python orm
SQL
0 vote211 views1 answer
Do you know sql
SQL
0 vote158 views1 answer
Select year from dual oracle
SQL
0 vote147 views1 answer
Mysql max number not returning correct value
SQL
1 vote151 views3 answers
Epoch to datetime
SQL
1 vote148 views1 answer
Oracle difference between two dates in years
SQL
2 votes157 views1 answer
How to show the whole table in sql
SQL