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 vote121 views1 answer
Create table employees oracle
SQL
0 vote118 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote135 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
2 votes130 views1 answer
How to select first row of database sql
SQL
0 vote175 views2 answers
SQL BULK INSERT
SQL
0 vote116 views1 answer
Insert thai language sql server
SQL
23 votes137 views6 answers
Create table sql server
SQL
8 votes128 views3 answers
Oracle auto_increment
SQL
10 votes244 views4 answers
Mysql if else
SQL
0 vote123 views1 answer
Oracle gather table statistics
SQL