MySQL

The mysql-utilities in the Yum package within CentOS is not the latest version. So the installation is done by compiling the method. mysql-utilities-1.6.5 is implemented based on Python2 , so Python does not need to be upgraded to 3. Installation

MySQL master-slave replication principle1. First master records data updates to a binary Binlog file2.slave requests the Binlog log file to the master via the I/O thread to specify the content after the location3.master receives slave IO request, it

Concatenation of strings1,mysqlIn Java, C # and other programming languages, the concatenation of strings can be achieved by the plus "+", such as: "1" + "3", "a" + "B".You can also use the plus sign "+" to connect two strings in MySQL, such as the

IndexAn index is a special kind of file that contains reference pointers to all the records in the data table. More generally, the database index is like a directory in front of a book, which can speed up the database query.Federated IndexAlso known

Joint queries are more efficient, with examples to illustrate Federated queries: The benefits and usage of inline inner join, leftist left outer join, right-outer JOIN, full-union, fully outer join.The efficiency of joint queries is high, and the

1.float, double, decimalfloat: Floating point type, 4 bytes, 32bit.Double: two-precision, 8-byte, 64-bitDecimal: Digital type, 128bit, no loss of precision, commonly used in bank account calculation. (28 significant digits)2.decimal Instructions for

1./* Query database Test all table comments */SELECT from WHERE Table_schema='test';2, to query the table field commentsSELECT from WHERE table_name='class' and Table_schema=' test';3, one-time query database "test" the following table comments

First, install MySQL under CENTOS6Check if the system has its own Mysql:yum list installed | grep MySQL,If there is already, execute the command yum-y remove mysql-libs.x86_64 Uninstall the MySQL that is already installed.1. System

1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to

A good memory is better than a bad pen, a record.MySQL is installed by default to deny remote connections.First enter the database and use the system database MySQL.1 mysql-u root-p MySQL #回车, then the system database is used for inputThe password

1, respectively open the host and slave my.cnf command to setVim/etc/my.cnfUnder [mysqld], fill in the numbers yourself, but not repeat them.Log-binServer-id=?2, in the host to operate, into the MySQLHost gives slave permission: Grant replication

After we have installed MySQL, enter the MySQL command at the terminal and find that we cannot see the database you installed because you do not have the environment variable configured.installing MySQL database in OS system is saved by default

There was an error in the MySQL insert data today with Chinese characters appearing incorrect string valueNow UTF8 is the mainstream, the use of GBK has a lot of inconvenience, and often go around.Today encountered a mistake, is about emoji

"Ready to Work" Build FTP server: Windows server R2 Build FTP service If the native Access report 530 error: 1, check the user name, password, 2, check the FTP directory user rights. If the remote host is inaccessible, check the firewall.

PHP sends data to MySQL, PHP operation MySQL database is the focus of emphasis.To give you some examples: To register a user, send the form's data post to PHP to write to the database To buy a product is to write the product information

ClassificationThe installation development sequence is divided into: Web-based database Hierarchical database relational database Object-oriented database Mainstream: relational databaserelational databaseTransaction

Incorrect string value garbled problem in MySQL solutionHave you ever encountered an error similar to the following?Java.sql.SQLException:Incorrect string value: ' \xf0\x9f\x92\x9c ' for column ' content ' at row 1.The reason for this exception is

First, download1, choose the appropriate installation package, I download here is the latest installation package, 8.0.11, and I choose to download the decompression version of the installation version, the installation will be more

When configuring MySQL master and slave, check the slave status, find the error message,The Error ' The MySQL server is running with the--skip-grant-tables option so it cannot execute this statement ' on query.mysql> show slave status\g**************

software versionmysql:5.7mha:0.56centos:7.4MySQL servermaster:192.168.1.224 mysql01slave1:192.168.1.225 mysql02slave2:192.168.1.226 MYSQL03MHAmanager:192.168.1.224 mysql01node1:192.168.1.225 mysql02node2:192.168.1.226