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 vote188 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
7 votes190 views3 answers
How to check table name in current database sql
SQL
16 votes211 views3 answers
T-SQL Add Column
SQL
0 vote204 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
1 vote196 views1 answer
Sql group by error
SQL
0 vote182 views1 answer
Mysql error 1452
SQL
1 vote229 views1 answer
Apex run 404
SQL
0 vote226 views1 answer
Mysql add text to existing field
SQL
2 votes278 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote260 views1 answer
Two inner joins sql
SQL