mysql中default的使用

mysql> create table user(age int(11) default 18);

Query OK, 0 rows affected, 1 warning (0.05 sec)

mysql> insert user values();

Query OK, 1 row affected (0.02 sec)

mysql> select * from user;

+------+

| age  |

+------+

|   18 |

+------+

1 row in set (0.00 sec)