MySQL

Share MySQL 5.7 docker master-slave replication Architecture Tutorial for your reference, the specific contents are as follows Environment version:mysql:5.7.13docker:1.11.2centos:7.1 1. Install two MySQL on two physical machines first. Commands

Thanks to our support, we can do it now and thank you for your support. In this article, we will focus on the practical skills of MySQL, talk about the interview related issues. 1. How do I use the SELECT statement to find the version of the server

Use a VPS to do everything you need to worry about, backup is also. Backup services like Linode are charged, and one months is 5 dollars. It's better to have plenty of money than to spend 5 dollars. Install the Dropbox for the service and set the

Recently in the study of PHP, want to record their learning experience, and write some experience, only for reference exchange. This article is suitable for those who just contact PHP, want to learn and want to build their own nginx+php+mysql

MySQL full-text search, sql writing: MATCH (Col1,col2,...) Against (expr [in BOOLEAN MODE | With QUERY expansion]) Like what: SELECT * from articles WHERE MATCH (title,body) against (' database '); The MATCH () function performs a natural language

Slow sql: Queries that run longer than a given time range are called slow queries.How do I record slow sql in MySQL?A: You can set the following information in MY.CNF: [Mysqld] ; Enable the slow query log, default

This article describes the way PHP uses MySQL and mysqli to connect to the MySQL database. Share to everyone for your reference, specific as follows: The code is simple, straight up. ---------------------------mysql_connect---------------------

For large systems, Oracle,sqlserver is undoubtedly the best choice to look at the growing number of small web sites, they do not have their own servers, just to buy other people's space and database, but this small database on the performance of

The recent occurrence of slave delays on the line is frequent. After the discovery for users in the deletion of data, because the primary key of the table is missing, and delete conditions without index, or delete the conditions of poor filtration,

Guide MySQL is used in more and more business, in the key business of data security requirements are also higher, how to ensure MySQL data security? Data security if only the MySQL application level is clearly not enough, it needs to be protected

Objective Sorting is a basic function of the database, and MySQL is no exception. The user is able to sort the specified result set by the order BY statement, not just the order by statement, the Group by statement, and the distinct statement

This article starts at InfoQ Chinese Station。 Author: Munling (Dragon), fenng.Note: To reprint friends, please pay attention to the first author of this article! This article is a summary of what he did after a dragon friend came to discuss it.

There is a need today to implement automatic database backup under Windows, piecing together a solution. Characteristics of the implementation Multiple databases can be specified Organize backups on a yearly/month/day basis Optional use of WinRAR

Left JOIN syntax usage and instanceMySQL left JOIN syntaxThe SQL (MySQL) left JOIN gets all the records in the left-hand table (table1), even if the right table (table2) does not have a corresponding matching record. The basic syntax for the left

The example in this article describes the way PHP formats MySQL to return the float type. Share to everyone for your reference, specific as follows: PHP to obtain the MySQL float field, echo output, the decimal part is divided into more than 0.

DROP TABLE IF EXISTS [Temp_table_name]; Create temporary table [Temp_table_name] Select Col1,col2,... from [table_name]; ALTER TABLE [Temp_table_name] Add unique idx_col1 (col1); Through the above operation, the warning problem occurs many times.

0. Basic concepts of Triggersa trigger is a special stored procedure that triggers execution when inserting, deleting, or modifying data in a particular table, and it has a finer and more complex data control capability than the standard

The following article is mainly about the actual use of the MySQL UPDATE statement, we first is a single table UPDATE statement to the implementation of the MySQL UPDATE statement of the actual scheme, the following is the detailed description of

MySQL installation directoryDatabase directory:/var/lib/mysql/Configuration file:/usr/share/mysql (mysql.server command and configuration file)Related commands:/usr/bin (mysqladmin mysqldump, etc. order)Startup script:/etc/init.d/mysql (Directory of

If you are importing the Chinese data, my MySQL set UTF8 character set, so you want to import the Xxx.txt file to save the Utf-8 character set, command load Data infile "D:/websites/sxxxx/test1.txt" Ignore into table ' names ' fields terminated by ',