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 vote217 views1 answer
Sql select without column name
SQL
0 vote172 views1 answer
How to increase the width of the screen in oracle
SQL
1 vote171 views1 answer
Mamp mysql path mac
SQL
0 vote236 views1 answer
Oracle job session
SQL
0 vote127 views1 answer
Select mysql limit to 2 decimal places
SQL
3 votes260 views3 answers
Mysql get table size
SQL
0 vote197 views1 answer
Query to insert image
SQL
6 votes188 views2 answers
Mysqldump password in file
SQL
2 votes215 views1 answer
Sqlite3 show columns name
SQL
0 vote196 views1 answer
Varchar format not case sensitive sql
SQL