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

2 votes156 views1 answer
Match in sql server
SQL
0 vote153 views1 answer
Longtext sql
SQL
1 vote164 views1 answer
Mysql average of multiple columns
SQL
1 vote150 views1 answer
Postgres check blocking
SQL
31 votes153 views1 answer
Postgresql add column with constraint
SQL
0 vote154 views1 answer
Mysql begin statement
SQL
0 vote157 views1 answer
Eliminar ultimo carcacter mysql
SQL
3 votes154 views1 answer
Only join in sql
SQL
2 votes163 views1 answer
Apex execute batch job
SQL
12 votes175 views1 answer
Run mysql instance in docker
SQL