MySQL 如何选择ID最大的行？

您可以使用ORDER BY与LIMIT OFFSET来选择MySQL中的最高ID行。

语法如下 –

select *from yourTableName order by yourColumnName desc limit 1 offset 0;

为了理解上述语法，让我们创建一个表。创建表的查询语句如下 –

mysql> create table HighestIdOrderBy
   −> (
   −> EmployeeId int,
   −> EmployeeName varchar(200)
   −> );
Query OK, 0 rows affected (0.58 sec)

使用insert命令在表中插入记录。查询语句如下 –

mysql> insert into HighestIdOrderBy values(200,'David');
Query OK, 1 row affected (0.20 sec)

mysql> insert into HighestIdOrderBy values(1000,'Bob');
Query OK, 1 row affected (0.18 sec)

mysql> insert into HighestIdOrderBy values(600,'John');
Query OK, 1 row affected (0.16 sec)

mysql> insert into HighestIdOrderBy values(300,'Johnson');
Query OK, 1 row affected (0.18 sec)

mysql> insert into HighestIdOrderBy values(100,'Carol');
Query OK, 1 row affected (0.12 sec)

使用select语句显示表中的所有记录。查询语句如下 –

mysql> select *from HighestIdOrderBy;

以下是输出 –

+------------+--------------+
| EmployeeId | EmployeeName |
+------------+--------------+
|        200 | David        |
|       1000 | Bob          |
|        600 | John         |
|        300 | Johnson      |
|        100 | Carol       |
+------------+--------------+
5 rows in set (0.00 sec)

以下是从MySQL表中选择最大ID的查询语句。查询语句如下 –

mysql> select *from HighestIdOrderBy order by EmployeeId desc limit 1 offset 0;

以下是输出 –

+------------+--------------+
| EmployeeId | EmployeeName |
+------------+--------------+
|       1000 | Bob          |
+------------+--------------+
1 row in set (0.00 sec)

阅读更多：MySQL 教程