MySQL数据库事件调度(Event)(二)

2015-01-21 12:31:45 · 作者: · 浏览: 8
-----------+
| t? ? ? ? ? ? ? ? |
+-------------------+
1 row in set (0.00 sec)


mysql> desc t;
+-------+-----------+------+-----+-------------------+-----------------------------+
| Field | Type? ? ? | Null | Key | Default? ? ? ? ? | Extra? ? ? ? ? ? ? ? ? ? ? |
+-------+-----------+------+-----+-------------------+-----------------------------+

| a? ? | int(11)? | YES? |? ? | NULL? ? ? ? ? ? ? |? ? ? ? ? ? ? ? ? ? ? ? ? ? |
| b? ? | char(10)? | YES? |? ? | NULL? ? ? ? ? ? ? |? ? ? ? ? ? ? ? ? ? ? ? ? ? |
| c? ? | timestamp | NO? |? ? | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+-------+-----------+------+-----+-------------------+-----------------------------+
3 rows in set (0.01 sec)


mysql>