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

9 votes190 views3 answers
Where clause sql
SQL
1 vote173 views1 answer
Postgresql substring last
SQL
0 vote185 views1 answer
Can we rollback data that are deleted using DELETE
SQL
6 votes212 views1 answer
How to get the size of the database in postgresql
SQL
3 votes164 views4 answers
Stop MySQL
SQL
0 vote187 views1 answer
Postgresql inline table
SQL
5 votes166 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote176 views1 answer
Mysql add root password
SQL
0 vote201 views1 answer
Repeatable read trong sql server
SQL
16 votes170 views3 answers
Delete row psql
SQL