Summer Progress Plan 2: Climb the details of a Top100 movie and store the results in the database
Crawl the top 100 movie information of an eye and store it in the database
It's hard for me to make it today. Cry.
number
picture
Full name
To star
time
score
Let's put the code below:
from urllib import request
from bs4 import BeautifulSoup
import pymysql
conn = pymysql.connect(host = 'localhost', u ...
Posted by amclean on Sun, 06 Oct 2019 04:50:19 -0700
Xtrabackup backup script
Install MySQL
mysql-5.7 (yum mode)
curl -sSL https://dwz.cn/gfcnHqGS -o install-mysql.sh
chmod +x install-mysql.sh
./install-mysql.sh --get-version # View software versions in the repository
# Example
./install-mysql.sh --active install --data-dir /home/hadoop/mysql --version 5.7.23 --root-pass 123abc@DEF
--help # View Help Inform ...
Posted by jtbaker on Sun, 06 Oct 2019 01:57:33 -0700
Knowledge Reasoning Machine Reproduction Based on jena
Knowledge inference machine reappearing
Because csdn grammar support is different from github, you are welcome to visit the GitHub version of this article: https://github.com/JimXiongGM/KnowledgeBasedSearch/blob/master/ knowledge reasoning machine reappears.md
Catalog
mysql 8.0 preparation
Installa ...
Posted by cowfish on Sat, 05 Oct 2019 17:32:53 -0700
Table Analysis of Marketing Module Database: Time-limited Purchase Function
SpringBoot e-commerce project mall (20k+star) address: https://github.com/macrozheng/mall
abstract
This paper mainly analyzes the relevant functions of the limited time purchase (spike) function, and adopts the form of database table and function comparison.
Relevant table structure
Time limit purchase form
Information used to store time-limit ...
Posted by Ne0_Dev on Sat, 05 Oct 2019 09:31:39 -0700
MySQL Management - Commands to Operate and View Databases
ABSTRACT: This paper mainly studies the common commands of operating and querying database.
View the basic information of the database
Query all databases
Syntax:
1 show databases;
Example:
1 mysql> show databases;
2 +--------------------+
3 | Database |
4 +--------------------+
5 | information_schema |
6 | m ...
Posted by Inkeye on Sat, 05 Oct 2019 05:12:18 -0700
Deployment of canal based on docker-compose
canal's Origin and Related Introduction
To understand the introduction of canal framework, installation and source code, please refer towiki The basic installation process and demo are very clear on the official git. It is strongly recommended to read the related introduction on git.
Mysql related s ...
Posted by jdock1 on Fri, 04 Oct 2019 20:53:18 -0700
Implementation of GTID Function Experiments by Binary Installation of MySQL 5.7
Environmental Science:
192.168.205.37: as master server
192.168.205.47: as slave server
Edition:
OS: centos 7 1810 with mini install
mysql-5.7.26-el7-x86_64.tar.gz
Purpose:
GTID(global transaction ID) global transaction identifier, MySQL 5.6 version began to support, GTID replication, unlike traditional replication (asynchronous delayed re ...
Posted by El_Dudereno on Fri, 04 Oct 2019 18:28:19 -0700
python connects mysql server
python connects mysql clients
import pymysql # Import module
conn = pymysql.connect(
host='127.0.0.1', # Host module
port=3306, # Port number
user='root',# User name
password='123', # Password
database='db', # Libraries that need to be connected
charset='utf8' # Specify code utf8
)
cursor = conn.cursor() # Get cursor
# ...
Posted by alexrait1 on Fri, 04 Oct 2019 18:26:08 -0700
Constructing key pair for remote connection between Linux server and client
Client: 192.168.1.10 Zhangsan userServer: 192.168.1.20 Lisi usersCreate key pairs in the client:
[zhangsan@localhost /]$ ssh-keygen -t ecdsa # - t is used to specify algorithm types: ecdsa and dsa
Generating public/private ecdsa key pair.
Enter file in which to save the key (/home/zhangsan/.ssh/id_ecdsa): # Specify the private key ...
Posted by jack_wetson on Fri, 04 Oct 2019 18:03:27 -0700
Linux Centos 7 - MySQL 5.7 Offline Installation
The internal network is installed by offline package.
First, Download
Download address: https://dev.mysql.com/downloads/mysql/
After entering the page, click the link on the right.
Download the corresponding version.
Upload to the server through xftp6 and other tools.
II. Installation and Configuration
2.1 Query and uninstall Ma ...
Posted by thoand on Fri, 04 Oct 2019 13:08:04 -0700