>>>>>>soft_wsx>>>>>>--Data backup and restore >> synchronous standby server--1, fully backing up the primary database--2, using a RESTORE DATABASE statement with a sandby clause to recover from a full backup of the primary database to build the
-- added create trigger yqhl_htjs_b_htjbxx_insert before insert on table name for each row begin if (NEW. F_sync_update is null) or (NEW. f_sync_update = 0) then set new. f_sync_update=null; -- inserting newly added records
Data insertionSyntax: INSERT into table_name (FIELD1,FIELD2......FIELDN) VALUES (value1,vlaue2,... Valuen)Single-line Insert user typeINSERT into Usertype (typename,typedescript) VALUES (' admin ', ' admin ')MultiRow Insert User TypeINSERT into
MySQL stored procedure creation, deletion, invocation and other common commandsI QQ group also has a lot of technical documents, I hope to provide you with some help (non-technical not to add).QQ Group: 281442983 (click the link to join the group:
MySQL supports a variety of data types, and the big nephew can be divided into three categories: numeric type, Time type, string type, and conforming type;Numeric type:
Type
Size
Range (signed)
Range (unsigned)
Use
Instance:For SQL Fuzzy queries, using the like comparison keyword, plus the wildcard characters in SQL, refer to the following:1. Like ' mc% ' will search for all strings (such as McBadden) that begin with the letter Mc.2. Like '%inger ' will search
MySQL's Lock1. Shared lock, which is read lock, can be forced by select ... lock in share mode, the default SELECT statement is unlocked2. Exclusive lock, that is, write lock, you can force write lock by select ... for UPDATE, INSERT, UPDATE, DELETE
MySQL master-slave replication and read/write separation2016.3.16 by linuxfan.cnEnvironment Introduction:Primary server (Master): 192.168.100.155Slave Server (slave1,slave2): 192.168.100.153-154Proxy Server (amoeba): 192.168.100.156App Client (APP):
when using in Mysql's master-slave replication architecture, there are two more headache issues: 1. how to deal with master-slave data after different steps2. How to solve the problem of master-slave synchronization delayThis article will be based
An index is a specific sort of algorithm for a particular MySQL field, such as a two-tree algorithm and a hashing algorithm. MySQL default is the two fork tree algorithm BTREE.Explain optimized query detectionExplain can help developers analyze SQL
Getting started with SQL (4): Creating and modifying data tables
This chapter describes how to use scripts to create databases, how to use scripts to create tables, and how to delete and modify objects.
CREATE statement: CREATE
Basic syntax for
Mysql (master/slave) master-slave replication principle and configuration details, mysqlslave
1 copy Overview
The built-in replication function of Mysql is the basis for building large and high-performance applications. This distribution mechanism
How much is the proper mysql tmp_table_size optimization and tmptablesize optimization?
You can set the tmp_table_size option to increase the size of a temporary table, for example, a temporary table generated BY the advanced group by operation. If
Mysql cache function note, mysqlcache note
Mysql cache function analysis:1. The key Generation Principle of the mysql cache function is to generate a unique key based on the select statement according to certain hash rules. The select result
MySQL configuration optimization (multiple parameters) and mysql Parameters
The main variables that have a great impact on performance optimization are listed below, mainly including the connection request variables and buffer variables.
1.
The third day of MySQL learning, Windows 64-bit operating system, MySQL verification, the third day of mysql
1. Check whether the MySQL service exists in the computer service list.
(1) Right-click the computer icon on the desktop and select "manage".
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