17.03.2018, 13:31
Quote:
Assuming you are using an auto incremented primary key on the House table, why not do
SELECT * FROM `Houses` ORDER BY `HouseID` DESC LIMIT 1 or assuming you are saving a timestamp on the inserted datetime of the house SELECT * FROM `Houses` ORDER BY `InsertedDateTime` DESC LIMIT 1 |
is there a way to get the max unique id? So if I for example have 200 houses, and add one, then delete one it still would be 201, and next 202..?