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

-1 vote343 views3 answers
Compute age mysql
SQL
1 vote343 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
23 votes348 views4 answers
Uninstall postgresql ubuntu
SQL
2 votes343 views2 answers
Enable foreign key checks postgres
SQL
7 votes324 views1 answer
Minecraft forge server host
SQL
1 vote344 views2 answers
Get table column names sql laravel
SQL
56 votes620 views5 answers
Psql create user
SQL
0 vote321 views1 answer
Console output pl sql
SQL
0 vote334 views1 answer
Sql server size of every table in a db
SQL
0 vote382 views1 answer
Delete from IN subquery
SQL