How python links databases
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!
