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 vote366 views1 answer
Excel export from sql using python
SQL
0 vote377 views1 answer
Arithmetic expression in sql
SQL
12 votes348 views6 answers
Between in sql
SQL
0 vote379 views1 answer
Oracle current timestamp insert statement
SQL
0 vote329 views1 answer
Selects all the columns from the sailors table
SQL
1 vote358 views2 answers
Sql server concat string and int
SQL
10 votes369 views6 answers
Sql between
SQL
0 vote336 views1 answer
Can sqldatareader be null
SQL
1 vote366 views1 answer
Insert value to new table by joining 2 different tables
SQL
5 votes298 views1 answer
Copy table from one database to another mysql
SQL