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 vote173 views1 answer
Sql get table last modified time
SQL
1 vote202 views1 answer
Get current date in pyspark sql
SQL
0 vote173 views1 answer
Mssql current date
SQL
0 vote185 views1 answer
Get number of rows in every table mysql
SQL
0 vote181 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
0 vote179 views1 answer
C# execute transact sql
SQL
0 vote219 views1 answer
C# sql transaction multiple connections
SQL
4 votes181 views1 answer
Mysql copy table with new name
SQL
1 vote144 views1 answer
Mysql collation
SQL
0 vote182 views1 answer
Incorrect datetime value sql table error 1292
SQL