how to select last_insert_id?
user123456789
I have an sql statement that returns more than one value: 
In my code I then need to call the last ID that was inserted. I have seen some examples about SELECT LAST_INSERT_ID() but they all seems to be for insert statements. I just want to show the last inserted id.
So from the image below I would only need to select ID 13
Ullas
Use ORDER BY and LIMIT .
Query
SELECT dl.* FROM driver_log dl
WHERE dl.Company_ID = 76 AND dl.Manifesr=tNo = 8199
ORDER BY ID DESC LIMIT 1;
If you want to select only the ID, then use MAX function.
SELECT MAX(dl.ID) as ID
FROM driver_log dl
WHERE dl.Company_ID = 76 AND dl.Manifesr=tNo = 8199;
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
Related
Related Related
- 1
SELECT LAST_INSERT_ID() not generating correctly
- 2
SELECT LAST_INSERT_ID() returning zero
- 3
SQL, select last insert ID by LAST_INSERT_ID()
- 4
How efficient is Last_insert_id?
- 5
Thread safety of MySQL's Select Last_Insert_ID
- 6
Using select last_insert_id() from php not working
- 7
How to do a multiple insert using LAST_INSERT_ID() MySQL?
- 8
How to do a multiple insert using LAST_INSERT_ID() MySQL?
- 9
MySQL LAST_INSERT_ID() - how does it works
- 10
how to get LAST_INSERT_ID via stored procedure in php
- 11
MYSQL LAST_INSERT_ID not working as intended. How do I fix?
- 12
How to store LAST_INSERT_ID() in database as foreign key in another table
- 13
How to use LAST_INSERT_ID() when using uuid as a default value?
- 14
MYSQL last_insert_id() and concurrency
- 15
LAST_INSERT_ID after restarting MySQL
- 16
MYSQL last_insert_id() and concurrency
- 17
use of where cluase for last_insert_id
- 18
Java Spring JDBC last_insert_id()
- 19
MariaDB Columnstore LAST_INSERT_ID() alternative
- 20
SQL Add a prefix to LAST_INSERT_ID()
- 21
How to select the last record of each ID
- 22
In SQLite, how to insert an id field in select result?
- 23
How not to select the last element
- 24
Invalid descriptor index on LAST_INSERT_ID after insert
- 25
INSERT INTO double select - how?
- 26
Is it possible to get LAST_INSERT_ID() from different database?
- 27
MySQL : Stored procedure returns null for last_insert_id
- 28
MySQL retrieve last_insert_id from stored procedure
- 29
MySQL: Can't get LAST_INSERT_ID()
Comments