Stucked up with MySQL
Posted 29 August 2006 - 06:58 AM
This is my table like:
Now I want to find out the row with 3rd maximum ID. In this case the raw with id 3.
I tried many ways but I am unable to get work arround this. MySQL is not supporting IN construct with my version.
Posted 29 August 2006 - 02:34 PM
SELECT * FROM yourTable ORDER BY ID LIMIT 3,1
Assuming that there are at least 3 entries in your table.
Posted 01 September 2006 - 12:01 AM
How do I increment the max ID value in the table.
SET ID = ID + 1
WHERE ID = (SELECT MAX(ID) FROM t)
but i get
#1093 - You can't specify target table 't' for update in FROM clause
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users