MySQL的zerofill 零填充-示例

mysql> CREATE TABLE example_table (
    ->     id INT(5) ZEROFILL,
    ->     name VARCHAR(50)
    -> );
Query OK, 0 rows affected (0.02 sec)

mysql> insert into example_table values(1,"张三");
Query OK, 1 row affected (0.01 sec)

mysql> select * from example_table;
+-------+--------+
| id    | name   |
+-------+--------+
| 00001 | 张三   |
+-------+--------+
1 row in set (0.00 sec)
上一篇:Qt day1


下一篇:仿muduo库实现one thread one loop式并发服务器