Search code examples
databaselastinsertid

How to select last inserted row by id?

that my problem:

I have database table like that:

id (AI)    market_id
1             6       
2            10      
3             6       
4            10   
5            11

How to select last inserted market_id by id?

Solution

  • You could do something like this:

    SELECT * FROM <your_table> ORDER BY id DESC LIMIT 1;

    If you only are interested in the market_id you could change the * in the above query to market_id.