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 vote338 views1 answer
Xampp mysql version
SQL
0 vote345 views1 answer
Replace \n sql
SQL
0 vote332 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote333 views1 answer
Sql count null as 0
SQL
2 votes422 views1 answer
Install postgresql centos 5
SQL
6 votes411 views4 answers
Mysql group by month
SQL
0 vote332 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
1 vote389 views1 answer
Alter constraint in sql
SQL
0 vote324 views1 answer
Oracle list dblink
SQL
8 votes365 views10 answers
Sql
SQL