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 vote145 views2 answers
Change database postgres
SQL
0 vote158 views1 answer
Postgres full text search example
SQL
4 votes155 views1 answer
Describe table mysql
SQL
0 vote128 views1 answer
List mysql tables and views
SQL
0 vote141 views1 answer
Oracle synonym procedure dblink
SQL
7 votes118 views1 answer
Safe mode mysql
SQL
2 votes139 views2 answers
Mysql bidirectional composite primary key
SQL
1 vote131 views2 answers
Drop function in sql
SQL
0 vote134 views1 answer
How to fetch unique records from two tables
SQL
3 votes148 views2 answers
MySQL query to get column names
SQL