how to see the last id in a table

[Fking]

i use unique id for each row
how i can get the value of the last id?

[laserlight]

For MySQL databases there is [man]mysql_insert_id/man, or its own LAST_INSERT_ID()

[Fking]

does it work if the last id is inserted in prevous session, and now we want just to see the last id

[tekky]

I would think it would (I dont have a server to test it on at the moment) however, worst case you can always SELECT id FROM mytable WHERE 1 ORDER BY id DESC LIMIT 1

that should dump them in order of greatest to least and return just the first row (which would be your highest insert value todate)