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 vote247 views1 answer
Oracle INTERVAL DAY to second to number
SQL
1 vote329 views1 answer
Mysql get max value and id
SQL
0 vote252 views1 answer
Postgresql delete multiple rows
SQL
0 vote254 views1 answer
Pl sql round
SQL
0 vote247 views2 answers
Sql update top 100
SQL
0 vote252 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote267 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
11 votes278 views6 answers
Mysql else if
SQL
0 vote264 views2 answers
Psql commande \gset
SQL
0 vote283 views1 answer
Oracle string length
SQL