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

4 votes236 views1 answer
How to check last gather stats on table in oracle
SQL
7 votes186 views3 answers
How to check table name in current database sql
SQL
0 vote203 views1 answer
Insert into select with group by
SQL
0 vote191 views1 answer
Fix sqlite3 ruby on rails
SQL
2 votes205 views1 answer
Where clause for child record apex
SQL
2 votes193 views1 answer
Mysql Incorrect column specifier for column
SQL
1 vote248 views1 answer
Sql comment header
SQL
0 vote236 views1 answer
Sql server datetime
SQL
0 vote182 views1 answer
Find how many table doesn't contain column in mysql
SQL
1 vote196 views2 answers
Mysql remove first and last character from string
SQL