MySQL

Log only the method that solves the problem.MySQL version: 5.7.18Problem: When executing MySQL function load_file, the function loads the contents of the specified file and stores it in the corresponding field. Such as:Select Load_file ("D:\aa.txt");

Today, a problem suddenly came to mind, originally in order to improve SQL Server performance, the Company rules query statements are generally added with (NOLOCK)Now turn Java, use MySQL why not mention this thing?First in MySQL wrote a query

Reprint: Https://www.cnblogs.com/wardensky/p/4569133.html SQL Optimization GuidelinesDisableSELECT * UseSelectCOUNT (*) counts the number of rows as little as possible to avoid a full table scan, if possible, index the filtered column to avoidThe

MySQL master-slave replication is believed to have been used a lot, but because of the work of the reason has not been used. While this period of time is relatively idle, it will be realized again. Although there are a lot of similar articles on the

The problem is, after using mysqldump to back up the online database, and then recovering from the MySQL command line to the offline database, the Discovery view becomes a table.Why is that? This has to be a chat about the MySQL backup recovery

A. mysql log view:QL early, need to master the use of SQL statements, the simplest way is more practice more use, but good need to have a certain purpose, what meaning? Is that everyone's habits are not the same, it may be easy to make mistakes are

When this error occurs:Thu Jan 22:49:59 CST 2018 warn:establishing SSL connection without server ' s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must is established by default

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

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

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

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);