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 vote384 views1 answer
Postgre query date
SQL
1 vote350 views1 answer
Mysql batch insert
SQL
2 votes358 views1 answer
How to insert string variable into sqlite database
SQL
2 votes354 views1 answer
How to get weekday from old date in sql
SQL
0 vote393 views1 answer
Sql query to force the database to be drop
SQL
0 vote347 views1 answer
Eliminar ultimo carcacter mysql
SQL
0 vote343 views1 answer
What is the essence of SQL?
SQL
0 vote364 views1 answer
Get who is hired in month in sql
SQL
4 votes356 views1 answer
Is there any command to change postgres password
SQL
0 vote359 views1 answer
Mysql count number of occurrences in a column
SQL