mysql - 选择语句奇怪的行为

Question

我有下表:

+---------------+----------+------+-----+---------+----------------+
| Field         | Type     | Null | Key | Default | Extra          |
+---------------+----------+------+-----+---------+----------------+
| id            | int(11)  | NO   | PRI | NULL    | auto_increment |
| CAMXTimeStamp | datetime | YES  |     | NULL    |                |
| CAMXMessage   | longtext | YES  |     | NULL    |                |
+---------------+----------+------+-----+---------+----------------+

我正在尝试选择 ID 最低的记录:

select id from camxmessages having min(id);

然后表格丢失了所有记录，我没有得到任何结果，知道我做错了什么吗？

Answer 1

SELECT MIN(ID)
FROM CAMXMESSAGES