Website:Program on:Web server 192.168.1.100 abovedatabase in: MySQL server 192.168.1.123 aboveImplementation Purpose: add a MySQL backup server (192.168.1.124), as a MySQL server (192.168.1.123) from the server, the two MySQL servers to achieve dual-
This article shares the MySQL stored procedure that modifies the table name to uppercase, as follows
1. Conditions:1.1 MySQL settings are case sensitive2. Execute the following stored procedures:
#call uppercase (' Library name ') DROP
Change the names of Mysql database tables to uppercase bitsCN.com in batches.
Change the names of Mysql database tables to uppercase in batches
[SQL] DELIMITER // DROP PROCEDURE IF EXISTS uppercase // CREATE PROCEDURE uppercase (IN dbname VARCHAR
Detailed description of how MySQL queries Time Zone strings with uppercase and lowercase letters, mysql Case
If you insert two rows of values 'A' and 'A' in A column with a unique constraint on mysql, Mysql considers it to be the same, but it does
Install MySQL database using a Binary Package
1.1 install MySQL database in Binary Package
1.1.1 preparations before installation (specifications)
[Root @ Mysql_server ~] # Mkdir-p/home/zhurui/tools # create a specified toolkit storage path[Root @
MySQL master-slave copy read/write separationI. Overview of MySQL read and write separationAs the most widely used free database in the world, MySQL believes that all engineers engaged in system operations must have contacted. However, in the actual
String function string comparison function if the result length is greater than the maximum value of the max_allowed_packet system variable, the return value of the string value function is NULL. See section 7.5.2 "Adjust server Parameters ".
String
Generally, the entire string is used as the operation object, for example: search for a substring in a substring, obtain a substring, insert a substring at a certain position in the substring, and delete a substring.
Generally, the entire string is
String functionsstring comparison functionsIf the length of the result is greater than the maximum value of the Max_allowed_packet system variable, the return value of the string value function is null. See section 7.5.2, "Tuning server parameters."
Mysql uses binlog incremental backup to restore the instance bitsCN.com
Mysql uses binlog incremental backup to restore an instance
I. What is incremental backup?
Incremental backup backs up new data. If you have 10 GB of data in a database, you
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.