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

2 votes180 views1 answer
Oracle Column Names of a table
SQL
0 vote136 views1 answer
Sql counter column
SQL
0 vote175 views1 answer
Postgres extract number from string
SQL
20 votes148 views4 answers
Sql count if
SQL
0 vote87 views1 answer
How to get last client id sql
SQL
0 vote151 views1 answer
Sql server current time without date
SQL
0 vote150 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote133 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote130 views1 answer
Postgres float to int
SQL
1 vote153 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL