问我需要我的系统获取系统当前时间

EN

mysql> create table tableName (`id` int(10) unsigned not null auto_increment, `route` varchar(50), `driver_name` varchar(50), `comment` blob default '', `time_in` timestamp , `time_out` timestamp , primary key(`id`)) engine=MyISAM DEFAULT CHARSET=utf8;
Query OK, 0 rows affected, 1 warning (0.07 sec)

mysql> create trigger tableName_bInsert BEFORE INSERT on tableName for each row set new.time_in=NOW();
Query OK, 0 rows affected (0.11 sec)

mysql> create trigger tableName_bUpdate BEFORE UPDATE on tableName for each row set new.time_out=NOW();
Query OK, 0 rows affected (0.09 sec)

mysql> insert into tableName set route="Belfast-Tralee", driver_name="Ken", comment="Pick up dogs. In.";
Query OK, 1 row affected (0.00 sec)

mysql> select * from tableName;
+----+----------------+-------------+-------------------+---------------------+---------------------+
| id | route          | driver_name | comment           | time_in             | time_out            |
+----+----------------+-------------+-------------------+---------------------+---------------------+
|  1 | Belfast-Tralee | Ken         | Pick up dogs. In. | 2013-12-17 13:51:13 | 0000-00-00 00:00:00 |
+----+----------------+-------------+-------------------+---------------------+---------------------+
1 row in set (0.00 sec)

mysql> update tableName set comment="Dogs - out" where id = 1;
Query OK, 1 row affected (0.02 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from tableName;
+----+----------------+-------------+------------+---------------------+---------------------+
| id | route          | driver_name | comment    | time_in             | time_out            |
+----+----------------+-------------+------------+---------------------+---------------------+
|  1 | Belfast-Tralee | Ken         | Dogs - out | 2013-12-17 13:51:37 | 2013-12-17 13:51:37 |
+----+----------------+-------------+------------+---------------------+---------------------+
1 row in set (0.00 sec)

mysql>