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 vote360 views1 answer
Default order by in mysql
SQL
0 vote339 views1 answer
Window function to forward fill
SQL
0 vote347 views1 answer
Database traccar
SQL
-1 vote273 views1 answer
Mysql how to set update or create
SQL
0 vote349 views1 answer
Transaction database with php
SQL
11 votes314 views2 answers
Having keyword sql
SQL
1 vote356 views1 answer
ORA-01950
SQL
0 vote327 views1 answer
Price-colour
SQL
0 vote334 views1 answer
How to use select union and loop
SQL
6 votes341 views2 answers
Database url postgres
SQL