python sql insert and get id code example

Example: 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.