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

1 vote130 views1 answer
Pl sql ptint
SQL
0 vote152 views1 answer
Wordpress sql find and replace
SQL
0 vote128 views1 answer
Sum value by month sql
SQL
4 votes153 views4 answers
Remove duplicate old value in mysql
SQL
0 vote267 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote151 views2 answers
Mysql add column tinyint default 0
SQL
8 votes131 views1 answer
Oracle create datafile
SQL
0 vote124 views1 answer
Oracle locked objects
SQL
0 vote189 views1 answer
How to rename a database in tsql
SQL
2 votes122 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL