MySQL

master-Slave synchronizationWhat is master-slave synchronization: Let other database servers automatically synchronize data on the database server that is serving the service.1 Adding authorized usersmysql> grant replication Slave on * * to [e-mail

Create a databaseIn MySQL, a database is a collection of objects used to store and manipulate data such as tables, database views, triggers, stored procedures, and so on.To create a database in MySQL, use the CREATE DATABASE following

Handling MySQL SLAVE synchronization error discussions using parameter Sql_slave_skip_counterThis article link address: http://blog.chinaunix.net/uid-31396856-id-5753206.htmlThis article discusses using Sql_slave_skip_counter to cause SQL threads to

In many cases when working with databases, it is possible for the leader or DBA to log in to the database, and when the update and delete are executed, forgetting where to add may result in a tragic emptying of the table, so the benefits of-u are

Today, I had a friend who asked me to help him back up the MySQL database on the windowserver server, so it took a day to complete a daily scheduled backup of the database, a small part here for everyone to record:First, for the MySQL command line

The example in this paper describes the method of MySQL query time period. Share to everyone for your reference. Here's how:MySQL query time period of the method may not everyone, the following for you to introduce two methods of MySQL query time

How does MySQL performance optimization find problematic SQL? monitoring efficient SQL with MySQL slow log the following is the SQL statement associated with the slow query: show variables like ' show_query_log '//Use this to see if it turns on the

Delimiter $create PROCEDURE phonedeal () BEGIN DECLARE ID varchar (+); --ID DECLARE phone1 varchar (+);--Phone DECLARE password1 varchar (32);--Password DECLARE name1 varchar (+); --ID --traverse end of data flag DECLARE

Because of the actual project involved, it is found that when the data volume of MySQL table reaches millions, the efficiency of normal SQL query decreases linearly, and the query speed is simply intolerable if the query condition in where is more.

Usergrade table1. Find the line where username is nullSELECT * from Usergrade WHERE ISNULL (USERNAME)SELECT * from Usergrade WHERE USERNAME is NULL2. Find the line inside username NOT NULLSELECT * from Usergrade WHERE USERNAME are not NULL3. List

Introduction to IndexesAn index is a structure that sorts the values of one or more columns in a database table, such as the name (name) column of the employee table. If you want to find him or her by the name of a particular employee, the index

MySQL connection error under Mac, error message: Access denied for user ' root ' @ ' localhost ' (using Password:yes)() inside the command entered for the shell, be sure to lose all including;& and other symbolsFirst step: Apple---system Preferences-

csv file import MySQLLOAD DATA INFILEstatement allows you to read data from a text file and quickly import the file's data into a table in the database.Before you import a file operation, you need to prepare the following:A database table that

first, the OriginMySQL master-slave replication, read and write separation is the Internet with a lot of MySQL architecture, master-slave replication is the most important thing is that in a large number of concurrent data volume scenarios,

One, MySQL login errorMysqladmin:connect to server at ' localhost ' failedError: ' Access denied for user ' root ' @ ' localhost ' (using Password:yes) 'Workaround: Hack the MySQL password1> stop MySQL service: service mysqld Stop2> Execute command:

First go to MySQL official website https://www.mysql.com/, click DownloadsThen select Mysqlinstaller in the Community versionThen select the following offline install package to download (above is the download)After downloading, double-click the

First, let's talk about why the tables are divided.The purpose of the sub-table is to reduce the burden on the database and shorten the query time .There is a mechanism in MySQL that is table locking and row locking, why this mechanism is to ensure

1. Optimize flowchartMySQL optimization (mainly increase the database select query, make the query faster)2. optimizing the MySQL aspectMainly from the following four aspects to optimize MySQL① Storage Tiers: How to select a database engine, select

Mysqli execution of mysql transactions Public static function exec_ SQL _tran ($ arr_ SQL ){ $ Result = true; $ Con = new MySQLi (DBHOST, DB_USER, DB_PASSWD, DB_NAME ); $ Con-> autocommit (FALSE ); Foreach ($ arr_ SQL as $ key => $ SQL ){ If (! $

Tips for using coalesce () in mysql Coalesce () Explanation The first non-empty expression in the return parameter (from left to right, and so on); Tips for using coalesce () in mysql Example A, B, and c variables. Select coalesce (null, 2, 3);