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 vote271 views2 answers
Mysql row_number() example
SQL
1 vote279 views1 answer
Oracle truncate partition
SQL
38 votes348 views6 answers
Ubuntu install mysql client
SQL
0 vote280 views1 answer
In query in sql
SQL
10 votes262 views4 answers
Join with multiple conditions sql
SQL
18 votes263 views3 answers
Mysql number format
SQL
0 vote266 views2 answers
Sql query for getting details by id
SQL
1 vote271 views2 answers
Test sqlsrv connection
SQL
1 vote271 views1 answer
Sql dcl
SQL
0 vote252 views2 answers
Postgresql create role
SQL