MySQL

CentOS 7 is mariadb by default, to prevent pits, or to install the official MySQL.wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpmsudo rpm -ivh mysql-community-release-el7-5.noarch.rpm#更新yum软件包yum check-update yum update

1. Latency of the networksince MySQL master-slave replication is based on an asynchronous replication of Binlog, transmission of binlog files over the network, it is natural that the network delay is the main reason for the majority of the

1. Update the system before installingsudo apt update2. Installing Apache2sudo apt install apache23. Install PHPsudo apt install phpsudo apt-get Install libapache2-mod-php4. Install MySQLsudo apt-get install Phpmyadminsudo apt-get install

Apply Feedback Action Update one table no response update Dcf_task_program SET run_state = ' 0 ' WHERE ID = ' 552de31dbee011e7b6e26c92bf48173b 'Login 225.7 to verify the lock process, execute the script, and view the lock information through show

Connection query: Select Table_b.type,table_b.title,table_b.content,table_b.author from table_a left join table_b on table_a.type = Table_b.type where table_a.id = 1;Subquery: Select Type,title,content,author from table_b where type = (select type

Group BY, grouping, as the name implies, the data according to what to group, each group has what characteristics.1, we start from the simplest:Select COUNT (*) from TB1 GROUP by Tb1.sex;Query the number of bars for all data, grouped by gender. This

Data lock is mainly used to ensure the consistency of data, database lock from the granularity of the lock can be divided into table-level locks, row-level locks and page-level locks.MySQL's locking mechanism is relatively simple, the most notable

Increase the artifact of MySQL in the dependency of Pom, shape likegroupId = MySQLArtifactid = Mysql-connector-javaVersion = 5.1.25Package Chen;Import java.io.IOException;Import Java.io.InputStream;Import java.sql.Connection;Import

The following are some of the key parameters to focus on. To see a more complete, find MySQL official documentation, note to the corresponding version.max_connect_errorsMaximum number of wrong connections, blocking connections when reached,

I. Background of the problem　　To meet the requirements of the superior, a production database needs to implement a backup; Just the vulnerability Scan report, MySQL version needs to upgrade to 5.7.20, so prepare for a rainy day, first write the

paging operation: Starting position with limit (parameter 1, parameter 2) (parameter 1)=(Page No.-1)*number of bars displayed per page (parameter 2)1. Classification TableCreate TableCategory (CIDvarchar( +)Primary Key, CNAMEvarchar( -));2.

1 Modifying table namesRename table AAA to BBB;OrRename table AAA to BBB;2 Modifying the data type of a fieldALTER TABLE person modify name varchar (20);3 modifying field namesALTER TABLE person change stu_name name varchar (25);4 Adding a field

Create a library operationHttp://www.cnblogs.com/linhaifeng/articles/7211690.html---------------------------------1, create database homework; Create DATABASE)2, show create database homework; Query creation Process3, drop database homework;

Operations on Table RecordsHttp://www.cnblogs.com/linhaifeng/articles/7267587.htmlAdd: Insert1. Insert full data (sequential insertion)Syntax One:INSERT into table name (Field 1, Field 2, Field 3 ...) field N) VALUES (value 1, value 2, value 3 ...)

Remarks about mysql dual-machine hot standby The previous article has already introducedMaster-slave ReplicationThis article only briefly describes master-slave replication. If you are not clear about master-slave replication, you can read the

Ssis odbc connection to the mysql database, ssismysql System Environment: WIN 10 64-bit 1. Install the Mysql odbc ctor plug-in Link to the article description: Https://www.cnblogs.com/santiagoMunez/p/4780301.html Plug-in download link: Https://

SQL high level, sqllevel 1, create like:Use a table to create another same table.Ex: create table if not exists tb_test4 LIKE tb_test3; 2, event: Create event event_testOn schedule every 1 SECONDDo insert into tb_test_e (username, PASSWORD) VALUES ('

Basic syntax for Mysql database Stored Procedures drop procedure sp_name// Before that, I have told you the basic knowledge of MYSQL syntax. In this article, I will explain the basic syntax knowledge to readers through the code in practice through

Instance test the enum type of MySQL, instance mysqlenum Some status fields are often encountered during the development project, such as the order status: Pending payment, paid, closed, and refunded, my previous projects used numbers to store these

Mysql -- index,1. Create and view Indexes Common indexes are created without any restrictions (unique or non-empty ). This type of index can be created on any data type field. (1) create a common index when creating a table Syntax: Example: