MySQL

Yesterday, the character set of the varchar field of all table in MySQL was converted into utf8mb4/utf8mb4_unicode_ci, in order to save some emoji Martian text, the error was as follows when an SQL statement was executed: Illegalmixofcollations (utf8

A netizen asked in MySQL How to use only SQL statements to export files with a date format. Feel a little meaning, and then try it. The export file uses select INTO OUTFILE but the value behind OUTFILE cannot use variables, so it can only be

MySQL federated queries are more efficient, with the following examples to illustrate the benefits of federated queries (inline, leftist, right-click, full-Union): T1 table structure (user name, password) UserID (int) Usernamevarchar

One: configuration file read location, different system my.cnf configuration file location .For example, Debian location:/etc/mysql/my.cnf found mysqld binaries: Find/-name mysqld /usr/bin/mysqld--verbose--help | grep- A 1 "Default Options"Two:

WhyDisadvantages of traditional replication and Gtids switchingWhen the replication fault occurs, the most headache is the adjustment of the replication architectureOnce master is down, you need to configure a slave as MasterThe binary log file is

MySQL restricts the size of packets accepted by the server according to the configuration file.Sometimes large inserts and updates are limited by the Max_allowed_packet parameter, resulting in failure.View current configurationShow VARIABLES like

Summary of commands: SS, Killall, Kill, PkillTo close the database method:Mysqladmin-uroot-ppassword shutdown/etc/inti.d/mysqld stopKILL-USR2 $ (cat path/pid)To change the MySQL data logon prompt:1.mysql> prompt \[email protected] \r:\m\s->PROMPT

0x01MySQL multi-table query and sub-queryJoin query: Two or more tables joined in advance, based on the results of the join queryCross join: Less intersection, equivalent to (a+b) * (c+d+e) of the resulting form with lessNatural Coupling---can only

[Turn]http://blog.csdn.net/lwprain/article/details/10966837 Note: Before the configuration before the master has never been successful, it is best to put the master database directory of mysql-bin.000000x and Mysql-bin.index, and salve

VS does not proactively provide the many connectors that you need to install these third-party packages yourself.MySQL provides a number of packages for Windows platform developers: http://dev.mysql.com/downloads/windows/This includes the connectors

MySQL Connection query:Mysql connection queries support multiple table joinsYou can repeat multiple connections to the same table (aliases are important when you concatenate the same table multiple times)Example 1:Here are 2 sheetsTeams tableMatch

The installation and connection tools for MySQL are explained earlier. This article is the beginning of MySQL in combat, mainly on the start and stop MySQL service, database management, table management and data deletion and modification;

Recently in the study of MySQL, encountered a MySQL stop fail problem, here the problem encountered and the process of writing out, not how difficult this problem, but I did not find a valid solution to the problem in the process of Chinese web page,

Official website: https://www.percona.com/doc/percona-toolkit/2.1/pt-table-checksum.html#dsn-optionsEnvironmentMaster: 10.50.12.33From: 10.50.12.35Simulation **************************************** of master-slave difference phenomenonMain:mysql>

How to Use the FROM and EXISTS clauses in MySQL subqueries, FROM subquerySubquery in the from clauseMySQL FROM subquery refers to the FROM clause as a subquery statement. The primary query then obtains the required data FROM the subquery results.

Comparison of implementation labels between REDIS and MYSQLHere we will illustrate the data conversion problem between REDIS and MYSQL. REDIS is a typical KEY-value nosql database and provides an additional rich data type. Here we briefly list the

Tutorial on column-subquery and row-subquery operations in MySQL, MySQL column subquery and use of the in, ANY, SOME, and ALL operatorsMySQL column subqueryA column subquery is a result set returned by a subquery that contains N rows and one column.

How to Implement read/write splitting in MySQL, Mysql-proxy for read/write splittingMySQL Proxy is a simple program between your client and MySQL server. It can monitor, analyze, or change their communication. It is flexible and has no restrictions.

Install and use Percona XtraBackup to back up and restore MySQL, 1. Install XtraBackup Yum installation method: Automatic $ rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm Then you will see: Retrieving http:

MySQL uses the general query log to find the most frequently queried statements, MySQL enable general query logAfter mysql opens the general log, all query statements can be obtained in a readable manner in the general log file, but the general log