Why so many resulting rows?

Question

PHP

SELECT COUNT(*) FROM page ORDER BY id LIMIT 0, 1
Result: 940
How can this be?

Answer 1

You obviously have a wrong use of LIMIT. LIMIT selects the specified number of rows from the result.
Your result is one line with the value in column 940. It is displayed accordingly.

Answer 2

count(*) always returns one row, whether you set a limit or not. The limit here has nothing to do with line numbers. To get the last line you need to use something like
select * from page order by id desc limit 1

Answer 3

Stop asking questions about small technical details that you are confused about.
Ask immediately about the main task, so that they explain to you how to do it CORRECTLY.
"I get one row from the database" - WHY?
"I want to know with the query above whether the last one is" - why?