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

MySQL Database Basics (iii)--sql Language I. Introduction to SQL 1. Introduction to SQL languageSQL is a Structured Query language (structured Query Language), which is the standard computer language for accessing and working with databases.The

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

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

Original link: about Navicat and MySQL character set is not uniform occurrence of Chinese garbled problemRecently encountered a string of MySQL Chinese garbled problem, the background is this:Before this, the server installed a good MySQL

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.

Q: What is an exception?A: The program may go wrong during execution and the run-time error is called an exception.By default, when a stored procedure runs out of error, the procedure terminates immediately and the system error message is

linux+nginx+mysql+php system modified file upload size limitfor some sites of the LNMp Framework, the upload file size will be limited by many aspects, one is the limit of nginx itself, limit the size of the client upload file, will error "413

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

Error code: 1064You have an error in your SQL syntax; check the manual that corresponds to your MySQL Server version for the right syntax to use near The error is reported because the if else statement in MySQL procedure uses the begin end

MySQL operations-detailed explanation of JSON data type operations, mysqljson In the previous article, we introduced the detailed description of mysql Data Stored Procedure Parameter instances. Today, let's take a look at the JSON data type related

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