🍅 Programmer Xiao Wang's blog: Programmer Xiao Wang's blog
🍅 Welcome to like 👍 Collection ⭐ Leaving a message. 📝
🍅 If you have an editor's error and contact the author, if you have a good article, welcome to share it with me, I will extract the essence and discard the dross.
🍅 Learning route of java self-study: Learning route of ...
Received alarm, content: MySQL_ The master-slave replication delay is too high (example: XXXX), current value: 1032.00, threshold: 1000 - 100000000, occurrence time: 12 / 30 / 2021 02:27:16.
Generally, in case of replication delay, let's first look at the replication status and active session of the slave library. ...
Posted by swasheck on Wed, 09 Mar 2022 02:35:03 +0100
Record the whole process of connecting to SQL Server database in detail
System: Windows 10 professionalQt version: Qt 5.14.2 [compilation kit MinGW 32]SQL Sever: SQL Sever 2019Programming language: C++
1, Configuring ODBC data sources
1, Add a new user in SQL Sever Manger
1. Open the MSS Management Studio provided below
Posted by drawmack on Tue, 08 Mar 2022 03:11:55 +0100
The following script is used for domestic brew installation:
/bin/zsh -c "$(curl -fsSL https://gitee.com/cunkai/HomebrewCN/raw/master/Homebrew.sh)"
brew install hive
Hide execute sql statement
hive can directly convert sql statements into mapreduce code (the link below is very good)
Posted by Teen0724 on Mon, 07 Mar 2022 23:39:51 +0100
DQL (data query language): query statements. All select statements are DQL; DML (data operation language): insert delete update to add, delete and modify the data in the table; DDL (data definition language): create drop alter, adding, deleting and modifying the table structure; TCL (transaction control language): commit the tran ...
Posted by gmccague on Mon, 07 Mar 2022 19:37:05 +0100
1. Database and SQL
1-1 introduction to database
Our common mysql, SQL Server, DB2, Oracle Database and Postgresql all belong to relational database management system (RDBMS)
The tables stored in the database are all sheets, which can be compared to excel data sheets. They are basically the same, just like that.
1-2 introduction to SQL
Posted by Hylian on Mon, 07 Mar 2022 14:00:22 +0100
(3) Probability and information theory)
2, Linear algebra
Purpose: it is mainly to reduce the dimension of data and restore or build the target with the least data
2.1 eigenvalue decomposition
Only symmetric positive definite matrix can be decomposed into eigenvalues. Eigenvalue decomposition: A = P * B * PT, where B is the diagonal mat ...
Posted by GeertDD on Sun, 06 Mar 2022 17:43:45 +0100
1. What is a database? What is a database management system? What is sql? What is the relationship between them?
The English word DataBase is called DB for short. A combination of files that store data in a format.
As the name suggests: a warehouse for storing data is actually a pile of files. These files store data in a spe ...
Posted by andrewmay67 on Sun, 06 Mar 2022 12:07:50 +0100
Grabit yes Salmon data kinship analyzer It collects SQL scripts from various data sources and then uploads them to salmon for data kinship analysis. The analysis results can be viewed in salmon. At the same time, the data kinship results will be extracted into the local directory.
At present, grab supports two modes of operation: graphical int ...
Posted by shiva on Sun, 06 Mar 2022 10:37:04 +0100
Note: this content is compiled from the MySQL video of Shangshan Silicon Valley Station B
>>MySQL video of Shangsi valley station B
The previous chapter talked about SQL single line functions. In fact, there is another kind of SQL function, which is called aggregation (or aggregation, grouping) function. It is a function that summari ...
Posted by rcarr on Sat, 05 Mar 2022 15:50:16 +0100