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 vote217 views1 answer
000webhost database values insert
SQL
7 votes179 views2 answers
Mysql db size
SQL
0 vote194 views1 answer
Oracle execute immediate quotes
SQL
0 vote183 views1 answer
Psql get table data types
SQL
9 votes189 views6 answers
Sql insert into
SQL
3 votes233 views1 answer
Oracle function
SQL
-1 vote188 views5 answers
Not in sql
SQL
0 vote196 views1 answer
How to find table lock and row lock in mysql
SQL
3 votes221 views1 answer
Sql online test questions and answers
SQL
0 vote171 views1 answer
Sql compound operators
SQL