Binary installation and backup of mysql!!

MySQL installation!    1. Download the installation package! [root@lzz ~]# wget https://downloads.mysql.com/archives/get/p/2 three/file/mysql-five.7.33-linux-glibc2.12-x8 six_6 four.tar.gz --2021-05-05 23:42:16-- https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz Resolving host downloads ...

Posted by Rochtus on Thu, 17 Feb 2022 22:10:02 +0100

Introduction to MySql master-slave installation and configuration

1, MySql installation Machine preparation: 10.117.201.80 (slave server, 8 cores), 10.117.201.81 (master server, 16 cores) Download mysql installation package: mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz Upload to two linux servers [root@mon mysql]# pwd /usr/local/mysql [root@mon mysql]# ls mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz decompr ...

Posted by Jaguar83 on Thu, 17 Feb 2022 20:33:08 +0100

SQL ability practice of deep love

@SQL skill improvement MySQL index At present, I'm a junior. I want to be engaged in data warehouse development, but the ability of data development is also particularly high in the market, I also interviewed many small companies and agreed that I didn't have a deeper understanding of the workflow and project expansion of the whole project A ...

Posted by markmil2002 on Thu, 17 Feb 2022 12:54:18 +0100

python crawler diary 01

PYTHON reptile diary 01 Record your learning reptile diary Choose python as the programming language 1. Environmental preparation python3.6+ mysql pycharm 2. Ideas The goal is to climb the top 100 of the cat's eye ​ 1. Analyze the law of url ​ https://maoyan.com/board/4?offset=10 Find their URLs and use the url parameter offset as th ...

Posted by totof06 on Thu, 17 Feb 2022 10:51:49 +0100

Alibaba cloud AI training camp - MYSQL foundation 1:

catalogue 1, First knowledge database 1.1 types of DBMS 1.2 common system structure of RDBMS 1.3 database installation 1.3.1 introduction to Alibaba cloud MySQL server 1.3.2 introduction to building local MySQL environment 2, First knowledge of SQL 2.1 concept introduction 2.2 basic writing rules of SQL 2.3 creation of database (CREATE DATABASE ...

Posted by ducky on Thu, 17 Feb 2022 05:00:23 +0100

MySql - Fuzzy Query, Sorting, Data Processing Functions, Grouping Functions

Fuzzy Query Using like is called a fuzzy query and is also a type of conditional query that supports% or underscore matching: (% is a special symbol, _is also a special symbol) %: match any number of characters _: Any character. For example: Find names that contain O? mysql> select ename from emp where ename like '%O%'; +-------+ | e ...

Posted by woocha on Wed, 16 Feb 2022 18:17:45 +0100

Addition, deletion and modification of MySQL-18-data processing

1. Insert data 1.1 practical problems Solution: use the INSERT statement to INSERT data into the table. 1.2 mode 1: add VALUES Using this syntax, only one piece of data can be inserted into the table at a time. Case 1: insert data in the default order for all fields of the table INSERT INTO Table name VALUES (value1,value2,....); In the ...

Posted by CSB on Wed, 16 Feb 2022 14:46:01 +0100

Mysql database - high-level statement 3 (arrangement, median, accumulation, percentage, regular, stored procedure)

1, Processing of tabular data 1.1 ranking #The table connects itself, and then lists the results in turn to calculate the number of rows before each row (including which row itself) select A1.Name, A1.Sales,count(A2.Sales) Rank from Total_Sales A1, Total_Sales A2 where A2.Sales > A1.Sales or (A2.Sales = A1.Sales and A2.Name >= A1 ...

Posted by csatucd on Wed, 16 Feb 2022 07:36:24 +0100

MySQL database - detailed explanation of five objects (Java)

catalogue 1, DriverManager: drive management object 1. Register driver: tell the program which database driver jar to use 2. Get database connection: 2, Connection: database connection object 1. Get the object executing sql 2. Management services: 3, Statement: object to execute sql 1,boolean execute(String sql) : 2,int executeUpdate( ...

Posted by zuzupus on Wed, 16 Feb 2022 06:04:45 +0100

Spark Day06: Spark kernel scheduling and spark SQL quick start of Spark Core

Spark Day06: Spark Core 01 - [understand] - course content review It mainly explains three aspects: Sogou log analysis, external data sources (HBase and MySQL) and shared variables. 1,Sogou Log analysis Search based on the official log SparkCore(RDD)Business analysis Data format: Text file data, and each data is the log data o ...

Posted by JamesThePanda on Mon, 14 Feb 2022 11:48:56 +0100