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 vote261 views1 answer
How to install mysql without admin rights
SQL
0 vote264 views1 answer
Mysql failed to login as root@localhost
SQL
0 vote318 views1 answer
Sql query to select even numbers
SQL
5 votes311 views1 answer
Mysql count lines
SQL
0 vote272 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote244 views1 answer
Clone table structure mysql
SQL
2 votes277 views1 answer
Sql percentage with % rounded down
SQL
0 vote271 views1 answer
Sql dmv to capture updates
SQL
0 vote256 views1 answer
Sql query for displaying age from oldest to youngest
SQL
2 votes258 views1 answer
Possgress drop if exists table
SQL