Shulou(Shulou.com)06/01 Report--

This article mainly introduces the relevant knowledge of "how to play Mysql with Python". The editor shows you the operation process through an actual case. The operation method is simple and fast, and it is practical. I hope this article "how to play Mysql with Python" can help you solve the problem.

Premise: mysql has been installed by default here.

Mysql is a relational database that supports large databases and can handle large databases with tens of millions of records. After the data set collected by the crawler is stored in mysql, the relevant data can be extracted in one step with the help of the associated query of mysql. The specific role will not be detailed here, and let's start with the actual operation.

1. Install pymysql

Install with the following command

Pip install pymysql

Pymysql library: Python3 link mysql

Note:

Ps:MYSQLdb is only available for python2.x

Python3 does not support MYSQLdb, instead of pymysql

Run the meeting report: ImportError:No module named 'MYSQLdb'

2.python connection mysqlimport pymysql as pmq

Localhost is the native ip, which is represented by localhost here, otherwise change the localhost to the corresponding database ip.

Root is the database user name, 123456 is the database password, and python_chenge is the database name.

The database python_chenge on the diagram has been established (after it is built, it can be connected with the above code). After it is built, there is currently no table. Now we begin to use Python to create tables, insert, query, modify, delete and other operations (explained with crawlers)

Before storing, create a table through python with four fields (one primary key + movie name, link, score)

# create movie table

Create table movie with fields of (id, title, url, rate), CHARACTER SET utf8 COLLATE utf8_general_ci is string encoding and set to utf8 format

Id is the primary key primary key,int type, AUTO_INCREMENT self-increment, non-empty not null

Title,url is a string type varchar (100), also not empty

The score rate is a decimal number, so it is float, and it is also not empty.

The crawler has collected the data, python has built the table, and then the collected data can be inserted into the database. Here are two ways.

# insert data

Id is self-increasing, so there is no need to pass in the value.

After defining the method of inserting the database, you begin to store it in the database

For i in json_data ['subjects']:

1. Query all

Query all data in the table

# query

two。 Query specified data

For example, the query title is: Chinatown 3, all the fields of this data.

# query a single entry

Update the data, or use the above: Chinatown 3 as an example, id is 7, change Chinatown 3 rating from 5.5 to 6

# Update

Take a look at the database at the same time.

Again, take Chinatown as an example. Its id is 7. If we delete it, we can update id to delete it.

Def delete (Id):

After deletion, there is no Article 7 data, indicating that the deletion was successful.

This is the end of the content about "how to play Mysql with Python". Thank you for your reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

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.