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 vote267 views1 answer
How to find unique key in sql
SQL
0 vote265 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
3 votes275 views2 answers
Sql random integer
SQL
3 votes293 views1 answer
Start mysql server by terminal in linux
SQL
27 votes286 views6 answers
Sql update record
SQL
0 vote288 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote262 views1 answer
Mysql connection with sqlalchecmy
SQL
5 votes266 views2 answers
Oracle show procedures
SQL
1 vote248 views1 answer
Stored procedure return value
SQL
2 votes292 views2 answers
Install postgresql
SQL