1 worm Replication
Worm replication: Data is fetched from existing data and then added to the data, which multiplies.
Table creation Advanced Action: Create a new table from existing (duplicate table structure)
Create
MySQL Master-slave Replication (CentOS) 1. Install MySQL 1.1 installation1.2 Starting the MySQL service1.3 Changing the root password1.4 Modifying a logged-on userPrecautionsRefresh Permissions2. Master-Slave Replication 2.1 Modify the configuration
Looks a little bit around the mouth, for instance,Two tables with different field namesField GS and another table GSMC some of the values are the sameAll we have to do is find the same value.Will write this SQL statement can beJust write the
Innodb_flush_log_at_trx_commit and Sync_binlog two parameters are key parameters for controlling MySQL disk write policy and data security.If Innodb_flush_log_at_trx_commit is set to 0,log buffer, it is written to log file once per second, and the
Find out the salary increases for all employees since they entered the job, give the employee number Emp_noy and their corresponding salary increase growth, and follow the growth in ascending orderCREATE TABLE ' Employees ' (' Emp_no ' int (one) is
Stored Proceduresstored procedure abbreviation procedure, procedure, is a function with no return valueTo create a process:Create procedure Procedure name ([parameter list])BeginProcess BodyEndviewing proceduresThe way the function is viewed is
#mysql批量修改字段类型 # Gets the modification statement and stores the use DB to the temporary table; CREATE temporary table Xiugai SELECT CONCAT ( ' alter TABLE ', TABLE_NAME, ' MODIFY COLUMN ', column_name, ' new type D ' Efault NULL; ' ) As Col
MySQL Select field data typeMySQL supports a number of data types, and choosing the right data type is critical to getting high performance. There is a simple principle in choosing to help make better choices.The simple principle:A, usually the
Substring_index (Str,delim,count)STR: The string to be processedDelim: DelimiterCount: CountExample: str=www.baidu.comSubstring_index (str, '. ', 1)The result is: wwwSubstring_index (str, '. ', 2)The result is: Www.baiduThat is, if Count is a
Suppose you want to back up database test on Server A to Server B1. Create a new database on Server B cp_testmysql>1 row affected (0.00 sec) MySQL> show Databases; +--------------------+| Database |+--------------------+|
Foreword: Prior to testing the SOLR several versions were unsuccessful, SOLR is better to download version 5.0,5.5,6.6. solr6.6 combined with TOMCAT8 to do automatic synchronization MySQL data has been error, and then decisively test 5.5 version of
stored Procedure procedureStored procedure, its essence or function--but its stipulation: cannot have the return value;definition form:Description1,in: Used to set the variable is used to "receive real parameter data", that is, "incoming"; default
(store) function:function, also referred to as "storage function", is actually JS or php in the said function! The only difference:the function here must return a data (value);definition form:Precautions:1, within the function, can have a variety of
" No comment Programmer's xxx and comments as long as ", frighten me hurriedly grabbed the note. previous MySQL comment -xxxxnow comment, with the code generator, there are comments. Remember the back default charset =utf8 comment= ' xxx ';650) this.
MYSQL updatexml error injection, mysqlupdatexml
First, understand the updatexml () function.
UPDATEXML (XML_document, XPath_string, new_value );The first parameter: XML_document is in String format and is the name of the XML document object. The
MySQL (III), mysql1 field attribute
Primary keys, unique keys, and auto-increment.
1.1 primary key
Primary key: primary key. Only one field in a table can use the corresponding key, which uniquely restricts the data in the field and cannot be
MySQL (2), mysql1. Data Type (column type)
The so-called data type: Unified Data Classification, from the perspective of the system is to be able to use a unified approach for management, better use of limited space.
SQL divides data types into
MySQL optimization in the production environment and mysql optimization in the environment
A: hardware optimization:
1. Use a 64-bit cpu with at least 4 CPUs. The larger the L2 cache, the better.2. Large Memory, 1-2 instances running 32-64 GB, and 3-
Connection error after mysql installation (error: Access denied for user 'root' @ 'localhost' (using password: YES) ") solution,
After mysql5.7 is installed properly a few days ago, the system prompts "Access denied for user 'root' @ 'localhost' (
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service