How to get the last inserted record from a table in mysql?

Question

I used

select * from equation_table order by type desc limit 1

But it returns 2nd record from the table.

Please include some data to make your question reproducible. — Tim Biegeleisen, Sep 22 '17 at 04:17
Possible duplicate of [MySQL: Get most recent record](https://stackoverflow.com/questions/8523374/mysql-get-most-recent-record) — Syfer, Sep 22 '17 at 04:36

score 1 · Answer 1 · answered Sep 22 '17 at 04:58

1

If you have an autoincrement id in your table which is names as id. then you can simply run below SQL to get last inserted record.

SELECT * FROM TABLE_NAME WHERE id != 0 ORDER BY id DESC LIMIT 0,1

answered Sep 22 '17 at 04:58

Saroj

1

yes. But I write it for syntax purpose. Though we want only 1 record then 1 is enough. – Saroj Sep 22 '17 at 05:35

score 1 · Answer 2 · answered Sep 22 '17 at 05:40

1

try this :

SELECT * 
FROM equation_table 
WHERE Eqtbl_id != 0 
ORDER BY Eqtbl_id DESC
LIMIT 1

You can find more by this answer

answered Sep 22 '17 at 05:40

iamsankalp89

score 0 · Answer 3 · answered Sep 22 '17 at 06:05

0

if id is primary and autoincreament field then.

Select * from equation_table ORDER BY id DESC LIMIT 1;

answered Sep 22 '17 at 06:05

Hardeep Singh

3 Answers3