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 vote126 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote127 views1 answer
PSQL qith variables
SQL
3 votes152 views2 answers
Oracle sql first day of month
SQL
-1 vote135 views2 answers
Installing mysql on centos 7
SQL
6 votes124 views1 answer
What is where clause in sql
SQL
0 vote130 views1 answer
Oracle allow space to user
SQL
1 vote149 views1 answer
How do you use sql in you company
SQL
8 votes129 views1 answer
Oracle tablespace datafile max size
SQL
0 vote118 views1 answer
Test connection to sql server
SQL
0 vote131 views1 answer
Drop CHECK constraint sql
SQL