How Python connects to the database and executes add, delete and modify statements

This article mainly explains how Python connects to the database to add, delete and change sentences. Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "Python how to connect to the database to execute add, delete and modify statements"!

Connect to the database to execute the add, delete and modify statement to get the number of rows affected

The previous ones used were:

Sql = 'insert into...'

Cursor = db_conn.cursor ()

Row_count = cursor.execute (sql)

Logger.debug ('influence rows:', row_count)

Db_conn.commit ()

Cursor.close ()

It is found that it is normal under Mysql, but cursor.execute (sql) returns null value under oracle.

Solution:

After cursor.execute (sql) is executed, you can use cursor.rowcount to get the number of affected rows.

Sql = 'insert into...'

Cursor = db_conn.cursor ()

Cursor.execute (sql)

Row_count = cursor.rowcount

Logger.debug ('influence rows:', row_count)

Db_conn.commit ()

Cursor.close ()

At this point, I believe you have a deeper understanding of "Python how to connect to the database to add, delete and change sentences". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!