MySQL

Database environment Dev: Development environment, development of read-write, can modify table structure. Developers can modify the table structure and can modify the data at will, but need to ensure that other development colleagues are

I. OverviewThe previous article about MySQL installation and basic use of MySQL, this article is a follow-up supplement, mainly for MySQL or mariadb backup and restore, it is well known that the data is the most important, so usually to the

Background:? Today, say brother in the group asked the master-slave between the 1032 error, after using the Pt-slave-restart jump after another 1062 errors, how to quickly deal with.Problem Resolution:? 1032 Error: The Binlog passed by the main

Case overviewA company's social networking site in the PHP language development, in order to manage the code developed by PHP programmers, the senior leaders asked to build SVN server version control. The first version of the social networking site

Understanding of MySQL optimistic lock, pessimistic lock, shared lock, exclusive lock, row lock, table lock conceptWhen we operate the database, there may be inconsistencies in data due to concurrency problems (data Conflicts)Optimistic

Remote access to the MySQL database on the server, the discovery root remote connection is not on, prompt error: "1045-access denied for user [email protected]"The workaround is as follows, execute the command:mysql> use MySQL;Mysql> selecthost,user

Tag: option lookup operation SQL form error query lis nameThe problem with MySQL Error: (2006, ' MySQL server has gone away ') means that the link between the client and MySQL server is broken.The reason for this is generally that the SQL operation

1. Monitor MySQL with the Percona monitor pluginYum Install

ObjectiveIn the event of failover, frequently encountered problems are synchronous error, the following is the most recent collection of error information. Record deletion failedDelete a record on master, not found on slaveLast_SQL_Error:

Concrete example 22, MySQL alter commandWe need to use the MySQL alter command when we need to modify the data table names or modify the field of the data tables.1. If you need to modify the name of the data table, you can use the RENAME clause in

Transferred from: http://www.169it.com/article/5994930453423417575.htmlIn order to test the efficiency of SQL statements, it is sometimes necessary to query without caching. Use Select Sql_no_cache ... The true function of syntax- sql_no_cache is to

The output of the Processlist command shows which threads are running, not only the current number of connections, but also the current connection status to help identify problematic query statements.If it is the root account, you can see the

The MySQL website also launches a graphical connection tool for Linux-MySQL Workbench. MySQL Workbench is more than just a simple MySQL client. In short,Workbench is a cross-platform(e.g. Linux,macox,windows) graphical tools for database design,

I have a table students table, there are 3 fields, id,name,age I want to query through name and age, in which two fields are created federated index? Or do you create a single-column index on nage and age, respectively? Multiple field queries when

I haven't had time to write. I knew one months would not be over, temporarily added work is always dragged down.。。MySQL cluster docker installed MySQL cluster error. It's my image that has less perl. Be honest with me. The image is not small again.

A table contains a field of the datetime type, and you want to insert a time to it in the format of "yyyy-mm-dd hh: mm: SS "; First, execute ps. setdate (2, date) in SQL )... After successful insertion, the time and seconds of the background

MySQL administrator Guide MySQL database IntroductionMySQL is a real multi-user, multi-thread SQL database server. SQL (Structured Query Language) is the world's most popular and standardized database language. MySQL is implemented in a

The load data infile statement reads a table from a text file at a high speed. If you specify the local keyword, read the file from the client host. If local is not specified, the file must be on the server. (Local is available in MySQL 3.22.6 or a

Let's talk about it first. It took nearly one day to complete it. In fact, it was about a year ago, but it was not recorded at that time, so now I have to do it again, it can be seen how important a blog is! It took so much time to compile the

Translation: Identifier Name, identifier naming rules This article is a translation of the mariadb official manual: Identifier Names. Original article: