Shulou(Shulou.com)05/31 Report--

Editor to share with you how python links to the database, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to understand it!

MySQLdb module is a method to provide MySQL database API for Python, which mainly aims at MySQL database.

Yum install MySQL-python-y

1. Database connection object

Conn = MySQLdb.connect (host = "localhost", user = 'root',passwd =' 123 magic db = 'test')

Common parameters:

Host: database hostname, default is local host

User: database login user. The default is the current user.

Passwd: database login user password. Default is empty.

Db: the name of the database for the operation

Port:MySQL database service uses port

Charset: database coding

two。 Object method

Cursor (): create a cursor

Commit (): transaction commit, database change operation, must have this method

Rollback (): transaction rollback

Close (): closes the database connection

3. Cursor object (all sql statements are executed under the cursor object)

What is a cursor?

The cursor is a data buffer set up by the system for users, which stores the results of the execution of SQL statements.

Execut (): execute the sql statement

Executemany (): executes multiple sql statements

Close (): close the cursor

Fetchone (): fetch the first record from the execution result

Fetchmany (n): fetch multiple records from the result

Fetchall (): fetch all records from the result

Scroll (): cursor scrolling

The above is all the contents of the article "how to Link a Database in python". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.