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

6 votes326 views1 answer
Oracle trigger after logon on database
SQL
0 vote275 views1 answer
Sql server split string and insert into table select
SQL
0 vote318 views1 answer
Implode in sql query
SQL
0 vote261 views1 answer
Postgresql get current user name
SQL
0 vote276 views1 answer
Price-colour
SQL
0 vote319 views1 answer
SQL server datetime compare
SQL
0 vote341 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
1 vote287 views1 answer
List all triggers in SQL Server
SQL
0 vote296 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
31 votes270 views3 answers
Sql count
SQL