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

1 vote216 views1 answer
Mysql limit results to 10
SQL
0 vote225 views1 answer
Mysql remove last character
SQL
0 vote206 views1 answer
Mysql update sequence with order by
SQL
0 vote205 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote216 views1 answer
Install mysql for fedora 34
SQL
0 vote249 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote230 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
1 vote229 views1 answer
Random name function in mysql for nvarchar
SQL
1 vote217 views1 answer
Sql server kill all connections
SQL
0 vote237 views1 answer
Sql gather statistics to increase performance
SQL