mysql最后N条记录/ 系统时间

select * from loginusers order by loginid desc limit n

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2009-09-23 10:55:55 |
+---------------------+
1 row in set (0.00 sec)

mysql>