MySQL

1. Explain analysis methodexplain {SQL}; Parsing query statements(1) The greater the number of ID column, the first execution, if the number is the same size, then from the top down to execute(2) Select_type query type: Simple, primary, dependent

1. Download the MySQL repo sourcewget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm2, installation SourceYum Localinstall xx.rpm3, install MySQLYum Install Mysql-community-server4. Start MySQLService mysqld Start5. View

Master End 192.168.200.771. Add in/ETC/MY.CNF[Mysqld]Log-bin=mysql-binServer-id=12. Check that the settings are in effectFirst, whether there are mysql-bin.000001 files and mysql-bin.index files in the data directorySecond, mysql> show variables

Reference link: MySQL's varchar length issueToday, I made a demo with MySQL and created a table:--Loan FormCREATE TABLEJK (IDint(5) not NULLAuto_increment,--self-increment IDAmountint not NULL,--Loan PrincipalRemarkvarchar(255),--Notes/Summary

Briefly under Ubuntu Linux install MySQL databaseOne. Installation# Apt-get Install Mysql-server# Apt-get Install Mysql-clientTwo. Start# sudo start MySQLCheck to see if monitoring is established# Netstat-tap | grep MySQLTCP 0 0 Localhost:mysql *:*

MySQL show processlist description, mysqlprocesslist Show processlist and show full processlist The output result of the processlist command shows which threads are running. You can view not only the number of current connections, but also the

MySQL pre-compilation function details, MySQL compilation function details This article shares with you the MySQL pre-compilation function for your reference. The specific content is as follows: 1. Benefits of pre-Compilation You have used the

Several important MySQL variables and MySQL Variables There are many MySQL variables, some of which are worth noting. The following describes some MySQL variables worth learning for your reference. 1 Threads_connected Note that the value of this

How to delete table data in MySQL: how to delete a table in mysql There are two ways to DELETE data in MySQL: one is the DELETE statement and the other is the truncate table statement. You can use the WHERE clause to select the record to be deleted.

Mysql having Usage Analysis, mysqlhaving usage Having usage Having clauses allow us to filter various data After grouping. where clauses filter records before aggregation, that is, before group by and having clauses. The having clause filters group

The usage of two temporary tables in MySQL External temporary table TEMPORARY tables created using create temporary table are called external TEMPORARY tables. This temporary table is only visible to the current user. When the current session ends,

MySQL 5.0.96 for Windows x86 32-Bit green lite installation tutorial, mysql5.0.96 MySQL 5.0 has become a classic version because it has fewer "advanced functions". This is MySQL 5.0.96 for Windows x86 32-bit. After streamlining, there is only a few

Analysis of mysql indexes and Analysis of mysql A database index is a data structure designed to speed up table operations. You can use one or more columns to create an index by providing fast random search and Efficient Sorting of access

The efficiency of mysql subquery union and in, and the efficiency of mysqlin A problem was found in recent product tests. When the number of concurrent jobs is less than 10, the response time can be kept within 100 milliseconds. However, when the

MySQL optimization uses join instead of subquery and mysqljoin Use JOIN instead of subquery (Sub-Queries) MySQL supports SQL subqueries from 4.1. This technique can use the SELECT statement to create a single column query result, and then use this

Analysis of mysql Character Set errors caused by database recovery An error will be prompted when the mysql character set encoding is incorrect. This is the same as inserting data. If the stored data is different from the mysql encoding, it will

MySQL 5.7.17 installation and configuration text tutorial, MySQL 5.7.17 text Said the blogger: I recently wrote a blog post titled "The simplest MySQL tutorial in history". I suddenly thought that some of my shoes have never touched the MySQL

Solution for Mysql 1067 in Windows, mysql1067 Just a few days ago, I started to install Mysql. I went to the company today and found that I couldn't start the service and reported a 1067 error. I checked some methods on the Internet and provided

MySQL Data Type DECIMAL usage example details, mysqldecimal Usage example of DECIMAL in MySQL Data Type In MySQL data types, such as INT, FLOAT, DOUBLE, CHAR, and DECIMAL, they all have their respective functions, next we will mainly introduce the

Mysql uses instr for fuzzy query, instr fuzzy query Using the internal function instr in mysql can replace the traditional like query method, and the query speed is faster. Instr function. The first parameter is a field, and the second parameter is