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

5 votes200 views2 answers
Oracle tables with column name
SQL
3 votes340 views2 answers
Oracle sql first day of month
SQL
0 vote207 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote187 views1 answer
Sql column as header
SQL
10 votes221 views6 answers
Sql between
SQL
0 vote269 views2 answers
Return the number of records in a single table mysql
SQL
1 vote244 views1 answer
Postgresql can you have null foreign key
SQL
0 vote216 views2 answers
Starts and end with vowel sql
SQL
0 vote213 views1 answer
Group by 15 minute interval sql server
SQL
0 vote224 views3 answers
Join
SQL