MySQL

mysqlm-m SyncA Basic ConfigurationMaster Master IP:192.168.100.123from master IP:192.168.100.124Do the same on both servers firstpremise: Close iptables or add a policy otherwise will be error;Vi/etc/sysconfig/iptables-A input-m state–state new-m

"Zoning Concept"Partitioning is to divide the data of a table into chunks, which can be on the same disk or on different disks, according to certain rules. The partitioned table is still a table.partitions partition data and index files according to

Mysql mysql_connect($db _host,$db _user,$db _password); mysql_select_db($dn _name); $result=mysql_query("Select ' Name ' from ' The Users ' WHERE ' location ' = '$location‘"); while($row=Mysql_fetch_array($result,Mysql_assoc)) { Echo $row[' Name '];

The reason why MySQL is garbled is that there are several reasons:1, stored in the database before the garbled2, stored in the database process garbled3, stored in the database after garbledWant to know where the garbled is very simple, in the

MORE: http://www.webyang.net/Html/web/article_138.htmlMySQL is often used to query specific fields, and occasionally need to show a certain part of the value in a particular field, how to deal with it?Then there are fuzzy queries, if you need to

1. Create a databaseCreate database test; 2. CREATE TABLE student (id int, name char (8), sex char (4));-Create a student table with ID name sex three field 3. View data table fields select columns from student;  show CREATE TABLE student;d Escribe

Master-Slave synchronization principle:Execution of any SQL statement on the primary server will write the statement to the Mysqlbinlog binary log, from the server will always synchronize to update the binary log file to the local, and then the log

Reference: http://www.w3cschool.cc/python/python-mysql.htmlAssume: MySQL has been installed and the database has been created TESTDB The user named "TestUser" is used to connect to the database TestDB and the password is "test123"

Error when using MySQL update inUpdate area set status= "on" where ID in (the Select ID from the area where status= ' "and name like '% City jurisdiction ')[sql]update area set status= ' "Where ID in" (select ID from the area where status= ' to '

First step : Turn on all MySQL server's bin log, each server set a unique Server-id value (default is 1, generally take IP last paragraph)Modifying the my.cnf of the primary server (master)[mysqld] log-bin=Mysql-binserver-id=91Modify the MY.CNF from

For automated operations, such as backup recovery, DBAs often need to encapsulate SQL statements into shell scripts. This paper describes several methods of SQL statements for shell scripts in MySQL database under Linux environment, for your

The last article, "MySQL metadata lock (i)," describes the reasons why the introduction of MDL,MDL action and the MDL lock lead to blocking several typical scenarios, the end of the article left a little doubt. This article will introduce the MDL in

In general, when the MySQL installation is complete, there will be some conditions: seconds back, system services, login not up, etc., need to make some settings.First, add the MySQL bin directory to the PATH environment variable.Then, install the

Google a bit, create a new Python script can run ~ ~ ~ Thank the original author##script to register Python 2.0 or later for use with Win32all#and other extensions that require Python registry settings##written by Joakim Loew for Secret Labs

Problem Description: Through the above statement, you will find that the MySQL like query is not case-sensitive, because my mistake, Joe was written to find this stuff. But, sometimes, we need to be case-sensitive, what should we do? Here's how to

A MySQL stored procedure is actually a function in which you can execute multiple SQL statements and create temporary variables.For example, the following main functions of the stored procedure are(1) Create two temporary variables to count the two

MySQL's storage engine is probably the most distinctive of all relational database products, not only using multiple storage engines at the same time, but also a very loosely coupled relationship between each storage engine and MySQL using the

MySQL engine learning notes MySQL has the following engines: ISAM, MyISAM, HEAP, InnoDB, and Berkley (BDB ). Note: different versions support different engines. Of course, if you feel that you are indeed highly skilled, you can also use MySQL ++ to

MySQL backup and recovery policies It is important to back up your database when database tables are lost or damaged. In the event of a system crash, you must be able to restore as much data as possible from your table to the State at the time of

MySQL Stored Procedure The Mysql stored procedure is actually a function, which can execute multiple SQL statements and create temporary variables.For example, the main functions of the following stored procedure are:(1) create two temporary