MySQL

First, MySQL master-slave Replication Introduction(1) MySQL master-slave replication through the logical Binlog log to the server to synchronize local, and then by the local thread to read the log inside the SQL statement, re-applied to the MySQL

/ http *** /include/web_content.php?id=589+and+ (select+1) =1This statement is when the MySQL version of the 4.0 is used to determine whether to support subqueries, the page is returned correctly, stating that support subqueries, otherwise not

1, table: is the basic unit of data stored in the database, a table contains several fields and values 2,To Create a table:CREATE Table table name (field name 1 database type 1 [constraint 1], field name 2 database type 2 [constraint 2], field name 3

A small requirement is encountered to modify some of the values in the field. The Replace in MySQL can be implemented.mysql> select * from syk_test;+-----------+-----------+| user       | host      |+-----------+-----------+| repluser   | %         |

Today is 61 children's Day, is a very memorable days, 9 in the morning to the company to work, the matter came, due to the development of negligence, to import a library into the library, and then when the development of the discovery of the wrong

If you log in to the database by using the root account, error is raised:Mysql:1006-can ' t CREATE database ' * * * ' (ERRNO:13)OrMysql:1006-can ' t CREATE database ' * * * ' (errno:28), which is generally a problem with MySQL users without

Reprint please declare source: http://blog.csdn.net/u013067166/article/details/49951577Recently reinstalled the system, to MySQL official website downloaded the latest MySQL5.7.9, I chose the decompression version, after the installation started

Recently saw Jianggengyau teacher's "MySQL Technology Insider: SQL Programming", combined with some of the problems encountered in their own work, from the engineering performance and the actual application of MySQL itself, summed up some problems

MySQL Internal connection (inner join on)MySQL's internal connection uses the inner join on, and its effect is the same as using where, if the junction is two tables, then the conditions need to be left or right or the field needs to match

If there are multiple duplicate fields in table Test1Some of the data is completely duplicated, and we're going to get him out and then delete it.SELECT * from Test1 a WHERE (A.phone,a.name) in (select Phone,name to Test1 GROUP by Phone,name have

Because Ubuntu default MySQL path is under/var/lib/mysql, many times if we do not mount other partitions at/Var, as the site gradually browse and add content, the data capacity will become larger, natural disk space will be more tight. So we need to

Rdbms:1, the establishment of the database delete2. Creation, deletion and modification of forms3. Creation and deletion of indexes4. Users and Permissions5, the Data deletion and modification6. EnquiryDML: Data Manipulation languageINSERT REPLACE

Two paged queries with 2 IDs skippedSELECT * from Jdp_tb_trade where jdp_modified>= ' 2017-04-24 20:22:01 ' and jdp_modified= ' 2017-04-24 20:22:01 ' and jdp_modifiedMysql paging ORDER by one of the same fields, the discovery sequence is disordered

First, configure the MySQL database1, unzip the green version of MySQL, and renamed to mysql5.7, such asCompare the previous version of 5.6 with less data directory (storage) and My-default.ini files (configuration information)Second, installation

PRIMARY KEY Index?? The PRIMARY key index is only a unique index with the name PRIMARY. This means that a table can contain only one primary KEY because it is not possible to have two indexes with the same name in a table. ALTER TABLE '

Installed on CentOS today, there's a little problem with MySQL. Record the solution:1: Troubleshooting yum Install Mysql-server no packages availablesudo yum install Mysql-serverShow:Loaded plugins: Fastestmirror, LangPacksLoading mirror speeds from

MySQL 5.6 Installation defaults to no system services installed and needs to be created manually. Open cmd and enter:D:CD D:\Program files\mysql\mysql Server 5.6\bin "directory name can be copied and pasted from Windows

Here are two ways to introduce1, in the back is the recordset, such as:SELECT * FROM table where uname in (select uname from user);2, in followed by a string, such as:SELECT * FROM table where uname in (' AAA ', BBB ', ' CCC ', ' ddd ', ' eee ',

Mysql user creation and authorization, mysql user creation authorization 1. Create a user:Command: create user 'username' @ 'host' identified by 'Password ';Description: username-the username you will create, host-specifies the host on which the

MySQL information_schema and informationschemaThe information_schema database is a MySQL database that provides access to database metadata. It seems that information_schema is like an encyclopedia of a MySQL instance, which records most of the