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.
Let's put the code below:
from urllib import request
from bs4 import BeautifulSoup
conn = pymysql.connect(host = 'localhost', u ...
Posted by amclean on Sun, 06 Oct 2019 04:50:19 -0700
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
mysql 8.0 preparation
Posted by cowfish on Sat, 05 Oct 2019 17:32:53 -0700
SpringBoot e-commerce project mall (20k+star) address: https://github.com/macrozheng/mall
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
ABSTRACT: This paper mainly studies the common commands of operating and querying database.
View the basic information of the database
Query all databases
1 show databases;
1 mysql> show databases;
3 | Database |
5 | information_schema |
6 | m ...
Posted by Inkeye on Sat, 05 Oct 2019 05:12:18 -0700
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
192.168.205.37: as master server
192.168.205.47: as slave server
OS: centos 7 1810 with mini install
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 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
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
The internal network is installed by offline package.
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