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

3 votes185 views2 answers
Coalesce mysql
SQL
9 votes209 views5 answers
Laravel to sql
SQL
1 vote165 views1 answer
Unique vs distinct sql
SQL
1 vote199 views2 answers
Maximum number of tables in mysql
SQL
13 votes166 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote144 views1 answer
Testing sql queries
SQL
0 vote208 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote187 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote207 views1 answer
Sqlite trim
SQL
1 vote238 views1 answer
Drop colum oracle 18c
SQL