mysql查询是做什么的_什么是简单的mysql查询

我想获取客户信息,其中客户ID应为2,log_id应为最大值

我试过下面的查询,但它找到了第一条记录.

什么是简单的查询

mysql> select * from log_customer where customer_id =2 group by customer_id having max(log_id);

+--------+------------+-------------+---------------------+-----------+----------+

| log_id | visitor_id | customer_id | login_at | logout_at | store_id |

+--------+------------+-------------+---------------------+-----------+----------+

| 2 | 56 | 2 | 2010-02-19 19:34:45 | NULL | 1 |

+--------+------------+-------------+---------------------+-----------+----------+

1 row in set (0.00 sec)

mysql> select * from log_customer where customer_id =2 limit 5;

+--------+------------+-------------+---------------------+---------------------+----------+

| log_id | visitor_id | customer_id | login_at | logout_at | store_id |

+--------+------------+-------------+---------------------+---------------------+----------+

| 2 | 56 | 2 | 2010-02-19 19:34:45 | NULL | 1 |

| 3 | 114 | 2 | 2010-02-23 17:31:55 | NULL | 1 |

| 31 | 1854 | 2 | 2010-03-08 18:31:28 | 2010-03-08 18:56:49 | 1 |

| 32 | 1992 | 2 | 2010-03-09 01:12:43 | NULL | 1 |

| 33 | 2304 | 2 | 2010-03-09 14:42:39 | NULL | 1 |

+--------+------------+-------------+---------------------+---------------------+----------+

请不要通过log_id desc建议订单我不想这样做