MySQL

1. Use aLOCATE (SUBSTR,STR)POSITION (substr in str)The function returns the position of the substring substr the first occurrence in the string str. If the substring substr does not exist in Str, the return value is 0.mysql> SELECT LOCATE (' Bar ', '

Transactional in MySQL:MySQL's InnoDB engine is transactional, and transactions consist of multiple SQL statements, which are a contiguous set of database operations. The entire transaction succeeds only if every operation within the group succeeds.

MySQL four communication protocols (all the sockets on Linux that are locally connected are TCP)When MySQL is connected, when using-h127.0.0.1, the connection protocol under Linux and UNIX is the socket protocol, and Windows is the memory

Many friends in MySQL think that the field auto_increment type self-increment ID value can not be modified, in fact, this understanding is wrong, the following describes the MySQL self-increment ID starting value modification and setting method.The

1. Turn off MySQL:#service mysqld Stop2. Transfer data:#cd/var/lib#ls#cp-A mysql/mnt/sdb/mysql/3, modify the configuration file, a bit three:#vi/etc/my.cnfAdd under [client]Socket=/mnt/sdb/mysql/mysql.sockComment out the previous code#datadir

There may be duplicate records in some MySQL data tables, and in some cases we allow duplicate data, but sometimes we also need to delete the duplicated data.In this blog post we will show you how to prevent data tables from repeating data and how

by Francis_hao Dec 17,2016Sort data Record QuerySorting refers to the orderly emission of filtered data that meets the criteria, in ascending (ASC (default)) and descending (DESC) mode.mysql> Select Field1 field2 ... from table_name [where condition

MySQL based on the field of the group query, the same field of data, only one display, if you want to make this field of all the data, display in a row, you can use the Group_contat function in the query, the default data merge with commas, separate6

Packet Naming format interpretationmysql-5.7.15-linux-glibc2.5-x86_64.tar.gz Black Bold indicates that the package name blue indicates that the Linux system binary package red represents the frame   1, upload mysql-5.7.15-linux-glibc2.5-x86_64.

Method One:1./etc/my.cnfIn the [MYSQLD] paragraph, addSkip-grant-table2.Restart MySQL3.Direct MySQL Login4.Modify the MySQL password (update) by modifying the permissions tableUpdate Mysql.user set Password=password (' xxxx ') where user= ' root '

Solve MySQL characters garbled ideas:MySQL server character setMySQL Client character setSystem Character SetProduction environment modified Character set:1. Export the table structure to the Scam.sql file2. Change the character set in the Scam.sql

Summary of the problem that the program cannot connect to mysql When mysql cannot be connected, the following four errors are reported:1: Can't connect to MySQL server2: Lost connection to MySQL server3: Sorry, due to line fault, temporarily unable

Differences between MyISAM and InnoDB In the MySQL storage engine: myisaminnodb InnoDB and MyISAM are the two most common table types used by many people when using MySQL. The two table types have their own advantages and disadvantages, depending on

Mysql and mysql This article uses the SQL Sample Code to introduce how the mysql database converts rows and columns. Let's just look at the sample code. Original table: Table name: user -------------------------------------- name | course | grade

MySQL cannot restart and reports the following error: Warning: World-writable config file '/etc/my. cnf' is an ignored solution: my. cnfisignored Problem Analysis The command for shutting down the database finds that mysql cannot be shut down,

MySQL startup error solution and mysql error Solution Generally, it is easy to troubleshoot mysql startup errors. Get a server and start mysql after installation. The startup error is as follows: Some people may say that if you set the buffer pool

How to change the default engine of Mysql to Innodb: mysqlinnodb Preface InnoDB and MyISAM are the two most common table types used by many people when using MySQL. The two table types have their own advantages and disadvantages, depending on the

MySQL check command in Linux (detailed description) and linuxmysqlcheck The mysqlcheck client tool can check and repair MyISAM tables, and optimize and analyze tables. In fact, it integrates the functions of check, repair, analyze, and optimize in

How to install mysql5.7.16 (decompressed version) and win10mysql5.7.16 on win10 Note: This article describes how to install the decompressed version. Installation tutorial Download mysql Address: http://dev.mysql.com/downloads/mysql/

How can I solve the 10055 error message when MYSQL cannot be connected? mysql10055 Solution: (the following content is my original Practice) To sum up, it should be the number of connections, so what are the number of connections on the server: 1.