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

2 votes275 views3 answers
Oracle show column of table
SQL
0 vote252 views1 answer
Provera dupliranih konatakata
SQL
0 vote285 views1 answer
What does leave do in mysql
SQL
0 vote274 views1 answer
List column names of multiple tables psql
SQL
3 votes253 views1 answer
What is having clause
SQL
8 votes322 views2 answers
Default sql server port
SQL
0 vote267 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
-1 vote217 views3 answers
Ubuntu install mssql
SQL
0 vote263 views1 answer
Postgressql uuid
SQL
3 votes283 views1 answer
Oracle list user grants
SQL