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

15 votes179 views2 answers
Select where duplicate mysql
SQL
0 vote186 views1 answer
Select odd records sql
SQL
5 votes168 views1 answer
Minecraft java port number
SQL
1 vote182 views1 answer
How to select the nth row in a SQL database table?
SQL
0 vote196 views1 answer
Mssql last day of month
SQL
2 votes169 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote170 views1 answer
Create database store
SQL
0 vote152 views1 answer
Postgresql conectar
SQL
2 votes205 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote163 views1 answer
Mysql update sequence with order by
SQL