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

13 votes103 views3 answers
Uninstall mysql centos 7
SQL
0 vote101 views1 answer
Postgres 11 add primary key
SQL
0 vote104 views1 answer
Mysql récupérer le code création de vue
SQL
10 votes100 views4 answers
Drop primary key
SQL
0 vote117 views1 answer
Mysql error 1251
SQL
0 vote116 views1 answer
Drop database using terminal postgres
SQL
1 vote107 views2 answers
Change table name phpmyadmin
SQL
3 votes104 views2 answers
How to load files in mysql
SQL
0 vote101 views1 answer
Change schema of all tables postgres
SQL
0 vote103 views1 answer
See Foreign Key
SQL