SELECT MAX(id) FROM tablename;
-- To get the last inserted auto-increment row ID: -- SELECT LAST_INSERT_ID( optional_expression ) -- If you have just inserted it using a command in C# use: -- int lastId = (Int32)yourCommand.LastInsertedId;