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 vote349 views1 answer
Primary key start from number
SQL
0 vote306 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote327 views1 answer
Mysql error 1251
SQL
1 vote356 views2 answers
Intersect sql
SQL
10 votes342 views4 answers
SELECT FROM WHERE
SQL
12 votes316 views1 answer
Docker mysql random root password
SQL
0 vote312 views1 answer
RowDataPacket
SQL
0 vote311 views1 answer
Sql server port 1434
SQL
0 vote307 views1 answer
How to check even or odd in sql
SQL
0 vote320 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL