MySQL

Learn notes about backup and recovery in MySQL learning process!Pictures can not be uploaded, you need to download the PDF format it! 51cto Too pit Daddy ~Picture is not clear enough, the following connection when the PDF, a bit large, please

We know the difference between char (m) and varchar (m) is that VARCHAR (m) is a variable-length string, and char (M) is a fixed-length string. For the time being, let's take a look at What is meant by M in CHAR (m) and VARCHAR (m), without regard

First create a table:CREATE TABLE INT(all nullDEFAULTnullVARCHAR(20 nullDEFAULTnull)Insert several data:Mysql> Select * fromT1;+------+------+|Id|Name|+------+------+| 1 |Chen|| 2 |Li|| 3 |Huan|+------+------+3Rowsinch

View all users in the MySQL databasemysql> SELECT DISTINCT CONCAT (' User: ', user, ' @ ', host, '; ') as query from Mysql.user;To view the permissions of a specific user in a databaseMysql> Show grants for ' cactiuser ' @ '%';Delete UserDelete

#查了资料折腾半天, it's coming.#参考http://blog.csdn.net/e421083458/article/details/19697701 This script is good.650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/76/15/wKiom1ZJwd3gcw38AAEoaxJt01w372.jpg "title=" Mysql-proxy "alt="

Ext.: http://blog.chinaunix.net/uid-7692530-id-2567582.htmlIn some databases there is a crosstab, but there is no such function in MySQL, but there are many friends on the Internet to find a solution, special post set the broad

1. Check if it is installed, grep's-i option indicates ignore case when matchingRpm-qa|grep-i MySQL* You can see that the library file has been installed, should be uninstalled first, or there will be overwrite errors. Note unloading: The--nodeps

By the way, a little win8 start running1. Win key + R key2,Win8 Although the Start menu is canceled, but move the mouse to the lower left corner of the screen (the original Start menu), to the Metro interface thumbnail appears, and then click on the

Problem: When using MySQL, using PHP to insert a database, query database information will be garbled to solve: Modify the MySQL configuration file, in its configuration file added code init_connect= ' SET collation_connection = utf8_ Unicode_ci '

Wamp after the installation, MySQL password is empty, then how to modify it? Actually very simple, through a few instructions on the line, below I step by step to operate.1. First, open the MySQL console via Wamp. Prompt for password, because it is

MySQL multiple master one from SyncLab Preparation: HostAand HostBas the main, itsIPthe addresses were192.168.131.129and the192.168.131.130, the hostCas slave server, configure from server aboveMySQLmulti-instance, itsIPaddress is192.168.131.136,

When we design the database table structure, we need to pay attention to the performance of the data operation when we operate the database, especially the SQL statements when we look at the table. Here, we're not going to talk too much about

Faced with the problem of character encoding load to MySQL: It could be gbk/utf-8/or mixed code.To ensure the atomicity of the data, the Rango solution is to convert from Python to 16, and then parse the 16 binary through MySQL parsing, which is

rsync+inotify Synchronizing backup MYSQL data Rsync has the advantages of high security, fast backup, support of incremental backup, and so on, which can solve the requirement of low real-time data backup. , but Rsync is not able to monitor and

MySQL Table Sub-queryA table subquery is a table data in which the result set returned by a subquery is n rows n columns.MySQL Table Sub-query instanceHere are two original data tables for the example: Article table: Aid

1. Understanding the execution efficiency of various SQL through the show status command2. Locating SQL statements that perform less efficientlyTurn on slow query logging:Open the MySQL profile My.ini and find [mysqld] below it to addLong_query_time

We all know that the MySQL stored procedure is starting from MySQL 5.0 to gradually add new features. Stored procedures are also more advantageous than disadvantages in practical applications. But the main thing is the execution efficiency and the

Based on UTF8MB4 than UTF8 more coding, can better support the emoji expression (http://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html), So I want my MySQL server to use UTF8MB4 encoding by default.So I got the config file

My project is MVC4, there are two versions, the first version of the direct operation is no problem, but the second version of the time to give me a hint of this error. Well, Baidu is really omnipotent. Below is the solution.1. Find

The group by syntax can group the results of a query based on each member of a given data column, resulting in a grouped summary table. The column name in the SELECT clause must be a grouping column or a column function. The column function returns