MySQL

Ensure the system is installed with Perl-dbd-mysql Yum Install Perl-dbd-mysql Install Xtrabackup The Xtrabackup 2.1 version does not support the InnoDB engine, so you need to download the 2.0.* version. Wget

Today found MySQL's master-slave database is not synchronized First on the Master library: Mysql>show processlist; Check to see if the process is too much sleep. Found to be normal. Show master status; is normal. Mysql> Show master status; +----

MySQL large table repeating fields How do I find it? This is a lot of people have encountered problems, below teach you a MySQL large table repeat field Query method for your reference.There is a large table in the database, and you need to find a

Import and export are mainly involved in two command source and mysqldump: 1: Import: Enter the MySQL command line, enter any database that will be imported, and then import. The specific commands are as follows: Enter the Windows DOS command line '

Customer Requirements mysql-5.1.32 is a GBK versionI downloaded the binary source from the mysql.com, do not have to compile their own installation is good. Later I looked at the language of Latin1 ~Online search for a half-day, a useful article

We all know that the only MySQL 5 after the stored procedures, these usages, then we want in the SQL with if else while these, we have to use a stored procedure or function to instance. Mysql> DELIMITER// mysql> CREATE FUNCTION myfunction

See an article on the web about the partition tableCREATE TABLE Users (UID INT UNSIGNED not NULL PRIMARY KEY,Name VARCHAR not NULL DEFAULT ',Email VARCHAR not NULL DEFAULT ')PARTITION by RANGE (UID) (PARTITION p0 VALUES less THAN (3000000)DATA

Create a table that is a primary key column and one that is an indexed column. It then inserts a batch of data, invokes the select * from Test_b, and finds that the output is not ordered according to the ID, but is ordered according to type. If you

1: Installed in the data server MySQL database, this is necessary, in their own SSH or virtual machine, data MySQL can see the relevant prompts, indicating the installation success: 2: I am using a tomcat server, where you need to install a

If you want to partition on a table that has already been built, MySQL prompts for an error if you add the partition using alter:The code is as follows: ERROR 1505 The correct approach is to create a new partitioned table with a consistent

This article illustrates MySQL's right and left internal connection usage. Share to everyone for your reference. Specifically as follows: Use an example to resolve the MySQL left connection, the right connection and the inner joinThe code is as

Case problems when you perform a lookup command By default, MySQL does not differentiate between uppercase and lowercase when performing a lookup. When you use like ' a% ' on a lookup, the default returns all column values starting with a or a, and

I. Creating a stored Procedure 1. Basic grammar: CREATE PROCEDURE Sp_name () Begin ......... End 2. Parameter transfer Two. Call the stored procedure 1. Basic syntax: Call Sp_name () Note: The stored procedure name must be followed by parentheses,

1, modify the MySQL configuration file If the configuration file is My.ini, you can add the following two items to the My.ini: Skip-locking Skip-name-resolve Note: In the new version of MySQL, skip-locking has been replaced with

Hint: "Starting MySQL ... error! Manager of Pid-file quit without updating file "solution. After you delete the MySQL binary log file, restarting MySQL appears this error, because the disk space is small, those binaries occupy a lot of space. So to

A. 10 words1. Do not rely on register_global=on environment, from you just know how to configure PHP to run the environment not even understand Register_global On/off will have any impact on their own day, you should be brave to set it off.2. See

What is a collection operation? Generally, a join operation is considered a horizontal operation between tables because the operation generates a virtual table that contains columns from two tables. And I've summarized the set operations here, and

This article mainly introduced the MySQL most common Operation statement summary, with the table and the library related these statements is the study MySQL most basic knowledge, needs the friend may refer to under Here are a few days I have been

String index and numeric index there are some aspects that would be very slow if not done, and today we'll take a look at the small collation of some of the MySQL string indexing problems and examples, because the character index is relatively

Grant all on * * to username @ "%" identified by "password";Mysql> select Host,user,password from user;+-----------------------+-------+-------------------------------------------+| Host | user | password |+-----------------------+-------+-----------