CODE EXAMPLE FOR SQL

get id from just inserted row mysql server python

Use cursor.lastrowid to get the last row ID inserted on the cursor object, 
or connection.insert_id() to get the ID from the last insert on that connection.