怎么查找数据库里最后一条记录?

Question

我这里有一个例子，不知道对你有没有启示：
mysql> select * from de;
+------+------+------+------+------+
| id   | a    | b    | c    | d    |
+------+------+------+------+------+
|    1 | "a1" | b1   | c1   | d1   |
|    2 | a2   | b2   | c2   | d2   |
|    3 | a2   | b2   | c2   | d2   |
|    4 | a5   | b8   | c1   | d1   |
|    5 | a3   | b3   | c6   | d4   |
+------+------+------+------+------+
5 rows in set (0.00 sec)mysql> select * from de limit 1;
+------+------+------+------+------+
| id   | a    | b    | c    | d    |
+------+------+------+------+------+
|    1 | "a1" | b1   | c1   | d1   |
+------+------+------+------+------+
1 row in set (0.00 sec)mysql> select * from de order by id desc limit 1;
+------+------+------+------+------+
| id   | a    | b    | c    | d    |
+------+------+------+------+------+
|    5 | a3   | b3   | c6   | d4   |
+------+------+------+------+------+
1 row in set (0.00 sec)

Answer 1

select * from table order by id desc limit 1