MySQL

In MySQL, each connection executes the Init-connect first, and the connection is initialized. Here we can get the user's login name and the thread ID value. Then with Binlog, we can trace the operation time of each operation statement, operator, etc.

In some applications, you need to know who is working on the table, what has been done, and what is responsible for the pursuit. In MySQL, you can use a trigger implementation.1: Create a test table Mysql> CREATE Table A (a

If you encounter mysql-libs-5.1.73-3.el6_5.x86_64 conflicts with a file from the package Percona-server-server error, there are two situations that cause this problem:1) Uninstall the Mysql-libs package preinstalled by the operating systemRpm-qa |

Today's dev script colleague needs to connect to B server using MySQL command on a server A.The previous steps were to install a MySQL client onto a machine, so that using the command MySQL on a can connect to the B server. Testing Another method

basic commands for MySQLstart: net start MySQL; Enter: MySQL-U root-P/Mysql-h localhost-U root-p databaseName; list database: show databases; Select database: UsedatabaseName; List table: show tables; Show table column properties: Show Columns

How does the MySQL database query data for the previous day based on time? This article has sorted out several solutions that are needed by a friend under reference.The content of this section:How to use MySQL to query the data of the previous day

Sorting by index optimization: ORDER BYSingle-Table query:The order of the indexed columns is exactly the same as the ORDER BY clause, and all columns are sorted in the same direction,MySQL can use an index to sort the results. The ORDER BY clause

Mysql-proxy IntroductionMySQL Proxy is such an intermediary agent layer,The MySQL proxy is a connection pool that forwards the connection requests from the foreground application to the backend database, and through the use of Lua scripting, enables

MySQL ReplicationMySQL replication refers to the transfer of DDL and DML operations on the main library to the library from the binary log, keeping the master and the data from the library in syncMySQL Master-slave Architecture: Advantages: Can cut

Master-master Mutual Primary Preparation1: According to the master and slave configuration steps to configure Masterb to Mastera from the library;2: Make sure that Masterb is not written, get its sync point on Masterb by the show Master Status

MySQL data tables support six types, namely: BDB, HEAP, ISAM, MERGE, MYISAM, Innobdb.These six types are divided into two categories: "Transaction-Safe" (Transaction-safe), including BDB and InnoDB, while the rest fall into the second category,

The customer provides the MySQL environment, but does not support Chinese, Use the following command to view the MySQL character set Connect to the MySQL service and enter the following command Mysql>show variables like ' character_set% '; Shown

Reprint: Http://blog.csdn.net/jaketseng/archive/2007/06/03/2206513.aspxMySQL's numeric data types can be roughly divided into two categories, one is an integer and the other is a floating-point or decimal. Many different subtypes are available for

Create a function in the master database of the MySQL master-slave replication machine, reporting the following error:Error code:1418. This function has none of the deterministic, NO SQL, or READS SQL DATA in its declaration and binary logging is

Isolation Level Concepts:First, read UNCOMMITTED (read-uncommitted)When the transaction isolation level is set to read-uncommitted (Read UNCOMMITTED), in this state, the data updated by one session is immediately visible to the other session, even

First, login MySQL view with show VARIABLES like ' character% '; The following character set, shown below:+--------------------------+----------------------------+| variable_name | Value

Today, the development of a requirement, you need to import the data in Excel into MySQL, originally wanted to import Excel into CSV format automatically has a comma, so with a comma as a delimiter, and then copy the data to a text file using MySQL

Install, configure, and set the encoding format for mysql 5.6.20. I,Install Installation environment System: Window 32 Version: Mysql 5.6.20 1,First download Mysql 5.6.20 Win32 version from the official website http://dev.mysql.com/downloads/mysql/

Problems caused by MySQL 5.6 upgrade: mysql 5.6 upgrade The MySQL database of the Project was upgraded from 5.5 to 5.6 yesterday. As a result, some tables cannot be updated. The following error is reported: When @ GLOBAL. ENFORCE_GTID_CONSISTENCY =

Notes on detaching MySQL 5 using RPM in SUSE Linux, suserpm For mysql installed in rpm mode in Linux, we can remove these rpm packages and delete the project directories to uninstall them. This article demonstrates how to uninstall MySQL 5.5.37 in