mysql - 如何使用 MySQL 命令显示数据库中最后一分钟(即当前分钟)的行？

Question

mysql> SELECT * FROM master_name;

+---------+---------------------+---------------------+-----------+----------+
| name_id | name_dateadded      | name_datemodified   | firstname | lastname |
+---------+---------------------+---------------------+-----------+----------+
|       1 | 2001-10-29 13:11:00 | 2001-10-29 13:11:00 | John      | Smith    |
|       2 | 2001-10-29 13:11:00 | 2001-10-29 13:11:00 | Jane      | Smith    |
|       3 | 2001-10-29 13:11:00 | 2001-10-29 13:11:00 | Jimbo     | Jones    |
|       4 | 2001-10-29 13:11:00 | 2001-10-29 13:11:00 | Andy      | Smith    |
|       7 | 2001-10-29 14:16:21 | 2001-10-29 14:16:21 | Chris     | Jones    |

<小时/>

预期输出:

| 7 | 2001-10-29 14:16:21 | 2001-10-29 14:16:21 | Chris  | Jones |

Answer 1

SELECT t.*
FROM master_name
WHERE id = (SELECT MAX(name_id) FROM master_name)