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 vote250 views1 answer
How to fetch data from database in sql
SQL
0 vote223 views1 answer
Data directory postgresql
SQL
0 vote234 views1 answer
Set classpath for mysql-connector.jar
SQL
-1 vote197 views1 answer
Mysql #1064 error
SQL
0 vote226 views1 answer
Ubuntu connect to mssql database
SQL
-1 vote207 views1 answer
Can pandas fetch data from sql
SQL
1 vote202 views1 answer
How to remove identity from a column in sql server
SQL
5 votes204 views1 answer
JBDC
SQL
0 vote203 views1 answer
Sql replace id with name from another table
SQL
0 vote287 views1 answer
Sqlite display headers on columns
SQL