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 vote201 views1 answer
Sql column as header
SQL
33 votes208 views6 answers
Change column name in mysql
SQL
-1 vote193 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote256 views9 answers
Linq to sql converter online
SQL
3 votes240 views1 answer
Sql online test questions and answers
SQL
0 vote197 views1 answer
Min mysql
SQL
0 vote213 views1 answer
How to get one year old query from plan cache
SQL
0 vote274 views2 answers
Cascade syntax in sql
SQL
5 votes233 views3 answers
Db begintransaction laravel
SQL
3 votes204 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL