各位前辈,怎样能得到系统时间具体到微秒?下面的这些都不行啊...
mysql> SELECT CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP;+--------------+--------------+---------------------+| CURRENT_DATE | CURRENT_TIME | CURRENT_TIMESTAMP |+--------------+--------------+---------------------+| 2005-05-31 | 21:40:18 | 2005-05-31 21:40:18 |+--------------+--------------+---------------------+
mysql> SELECT CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP;+--------------+--------------+---------------------+| CURRENT_DATE | CURRENT_TIME | CURRENT_TIMESTAMP |+--------------+--------------+---------------------+| 2005-05-31 | 21:40:18 | 2005-05-31 21:40:18 |+--------------+--------------+---------------------+
时间运算在应用程序中完成。
这个对于我来说有些复杂...请问大家,在MySQL中执行完语句都有如下信息:+-------------+-----------------+-----------+--------------+---------------------+
150000 rows in set (0.99 sec)这个“0.99”是不是写在一张系统表里的?能不能通过查询这张表获得它?