Python sql last insertend

>>> import MySQLdb
>>> connection = MySQLdb.connect(user='root')
>>> cursor = connection.cursor()
>>> cursor.execute('INSERT INTO sometable VALUES (...)')
1L
>>> connection.insert_id()
3L
>>> cursor.lastrowid
3L
>>> cursor.execute('SELECT last_insert_id()')
1L
>>> cursor.fetchone()
(3L,)
>>> cursor.execute('select @@identity')
1L
>>> cursor.fetchone()
(3L,)

Source: stackoverflow.com

Similar codes

0 vote180 views1 answer
Mariadb hours between two dates
SQL
5 votes96 views1 answer
Postgres upsert
SQL
0 vote151 views1 answer
Mysql change innodb to myisam
SQL
0 vote141 views1 answer
Criteria builder select subset of column
SQL
0 vote153 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote136 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote142 views1 answer
Php mysqli install
SQL
-1 vote149 views2 answers
Mysql get day of week
SQL
33 votes139 views6 answers
Change column name in mysql
SQL
0 vote125 views1 answer
Get who is hired in month in sql
SQL