MySQL learning notes station B

MySQL learning notes station B DAY01 1. What is a database? What is a database management system? What is SQL? What is the relationship between them? Database: English words DataBase,abbreviation DB. 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. Stored i ...

Posted by jej1216 on Fri, 12 Nov 2021 06:02:16 +0100

MySQL basic usage - MysqlDay1

catalogue 1. Database foundation 2. Database and data table management 3. Simple query and data operation 4. Backup and restore database Import: - MySQL basic usage In the information society, fully and effectively managing and utilizing all kinds of information resources is the prerequisite for scientific research and decision-making m ...

Posted by colforbin05 on Fri, 12 Nov 2021 05:31:43 +0100

MySQL window function, the stranger you are most familiar with~

_Previously, I voted for fans to find the most familiar stranger in MySQL ~~Which technical points in MySQL are you familiar with and unfamiliar with? The top three ranks are not as bad as I expected, respectively: 1. Cursors2. Window Functions3. Cluster Index _Although these three points are rarely used, they are often asked in interviews ...

Posted by playaz on Thu, 11 Nov 2021 17:07:02 +0100

MySQL foundation - properties of columns

Simple queries and inserted statements Simple query statement If we want to see what data has been stored in a table, we can use the following statement: SELECT * FROM Table name; For example, we want to see the first created earlier_ The data in the table can be written as follows: mysql> SELECT * FROM first_table; Empty set (0.01 sec ...

Posted by wintallo on Thu, 11 Nov 2021 05:44:14 +0100

Implementation method of mysql master-slave replication

Prepare two machines with mysql installed (installed on different machines). If it is a machine for virtual machine replication, you need to modify the uuid in the / var/lib/mysql/auto.cnf file to ensure that the UUIDs of the two machines are differentBackup the data from the primary database to the standby database. The two databases are consi ...

Posted by Bauer418 on Wed, 10 Nov 2021 04:19:17 +0100

Mysql add delete modify query (CURD)

1, Database operation 1.1 create database Using sql statements to create Syntax: create database database name charset utf8; For example, create a database named test1 create database test1;Create using the graphical interface Navicat Select connection - right click to select "New Database", enter the database name, and click ok ...

Posted by BenInBlack on Tue, 09 Nov 2021 22:23:07 +0100

MySQL MHA high availability cluster deployment and failover

1, MHA concept MHA (MasterHigh Availability) is a set of excellent software for failover and master-slave replication in MySQL high availability environment. The emergence of MHA is to solve the problem of MySQL single point. During MySQL failover, MHA can automatically complete the failover operation within 0-30 seconds. MHA can ensure th ...

Posted by fireineyes on Tue, 09 Nov 2021 02:02:01 +0100

MySQL non member simple question set 2021-11-08

175. Combine two tables SELECT FirstName, LastName, City, State From Person LEFT OUTER JOIN Address ON Person.PersonId = Address.PersonId; Chapter 16 of MySQL must know and know exercises related to creating advanced connections customers table and orders table [the external chain image transfer fails. The source station may have an ...

Posted by zebrax on Mon, 08 Nov 2021 07:38:30 +0100

Construction of MMM high availability architecture for MySQL database

1, MMM overview 1. What is MMM   MMM (Master Master replication manager for MySQL) is a script program that supports dual master failover and dual master daily management. Mmm is developed in Perl. It mainly monitors and manages MySQL master master replication. Although it is called dual master replication, only one master is allow ...

Posted by sarmad_m_azad on Thu, 04 Nov 2021 12:02:48 +0100

MySQL database notes Day4

Table 6 constraints Non NULL constraint not null DROP TABLE IF EXISTS tb_user; #If the table exists, delete it. If you use it with caution, you will lose data CREATE TABLE tb_user( id INT AUTO_INCREMENT, NAME VARCHAR(30) UNIQUE NOT NULL, age INT, phone VARCHAR(20) UNIQUE NOT NULL, email VARCHAR(30) UNIQUE NOT NULL, PRIMARY KEY ( ...

Posted by doctor_james on Thu, 04 Nov 2021 08:58:17 +0100