MySQL - Select the last inserted row easiest way

Question

I simply need to select the last entered row specified by condition  e g   SELECT ID from bugs WHERE user Me   I need to return only the very last ID entered by user  Me   Is there a simple way to do this  Thank you

User · Answer

You can use ORDER BY ID DESC  but it s WAY faster if you go that way   SELECT   FROM bugs WHERE ID    SELECT MAX ID  FROM bugs WHERE user    me     In case that you have a huge table  it could make a significant difference   EDIT  You can even set a variable in case you need it more than once  or if you think it is easier to read    SELECT  bug id    MAX ID  FROM bugs WHERE user    me   SELECT   FROM bugs WHERE ID    bug id

User · Answer

In concurrency  the latest record may not be the record you just entered  It may better to get the latest record using the primary key   If it is a auto increment field  use SELECT LAST INSERT ID    to get the id you just created

User · Answer

It would be best to have a TIMESTAMP column that defaults to CURRENT TIMESTAMP    it is the only true predictive behavior you can find here   The second-best thing you can do is ORDER BY ID DESC LIMIT 1 and hope the newest ID is the largest value

User · Answer

MySqlCommand insert meal   new MySqlCommand  quot INSERT INTO meals category Id  Name  price  added by  added date  VALUES   GTX-00145    Lunch    23 55    User Username    2020-10-26   quot   conn   if  insert meal  ExecuteNonQuery      1        long Last inserted id   insert meal LastInsertedId      MessageBox Show msg   quot Success quot   MessageBoxButtons OK  MessageBoxIcon Information                             else                               MessageBox Show  quot Failed to save meal quot

User · Answer

One way to accomplish that is to order you records and limit to 1  For example if you have the following table   data          id   user   price    -------------------     1     me    40 23     2     me    10 23   Try the following sql query    select   from data where user  me  order by id desc limit 1

User · Answer

SELECT MAX ID  from bugs WHERE user Me

User · Answer

SELECT   FROM  table name   ORDER BY  table name   column name  DESC LIMIT 1

User · Answer

Just after running mysql query from php  get it by    lastid mysql insert id      this give you the alst auto increment id value

User · Answer

SELECT ID from bugs WHERE user Me ORDER BY CREATED STAMP DESC   BY CREATED STAMP DESC fetches those data at index first which last created   I hope it will resolve your problem

[mysql] MySQL - Select the last inserted row easiest way

Examples related to mysql

Examples related to select