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

4 votes207 views4 answers
Mysql get date from datetime
SQL
0 vote168 views1 answer
How to update random rows in sql
SQL
0 vote173 views1 answer
Sql server remove 0 from left
SQL
0 vote180 views1 answer
Retornar apenas o ano mysql date
SQL
4 votes170 views2 answers
Oracle unliock account
SQL
4 votes193 views3 answers
Mysql get column names from table
SQL
0 vote181 views3 answers
Mysql keyword search
SQL
0 vote210 views1 answer
How do I insert a blob in SQL?
SQL
7 votes222 views1 answer
Show line number in sql server
SQL
0 vote182 views1 answer
Sql change column in existing table
SQL