Programmer Think

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 ...

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 ...

@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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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( ...

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 ...