10 recommended courses for advanced mysql

Performance optimization index The index points to a location in the database where specific data is located. Creating an index on the column can arrange the information on the column. When the server needs to access this information for a query, it will know where to look because the index points to the relevant location. If a column is involved in querying, grouping, and sorting, the index will improve performance. Indexes with many duplicate values ​​will not produce good results. You can use tables to join multiple non-unique indexes to improve performance. The more indexes, the better the performance is not necessarily. Adding an index does not necessarily improve performance. Query cache When running a select query, MySQL4.x will record the query and return results. This is accomplished by saving the result set in a special cache each time a select query is made. Then, when the server is asked to do the same query again, MySQL will retrieve the results from the cache rather than running the query again. This feature is enabled by default. Note that once a table changes, cached queries using this table become invalid and will be removed from the cache. This prevents queries from returning inaccurate data from the old table. Often

1. In-depth understanding of MySQL Advanced Drifting (6)

Introduction: Performance optimization index index points to a location in the database where specific data is located. Colleagues create an index on the column to arrange the information on the column. When the server needs to access this information for a query, it will know where to look because the index points to the relevant location. If a column is involved in querying, grouping, and sorting, the index will improve performance. Indexes with many duplicate values ​​will not produce good results. You can use tables to join multiple non-unique indexes to improve performance. The more indexes, the better the performance is not necessarily. Adding an index does not necessarily improve performance.

2. In-depth understanding of MySQL Advanced Drifting (V)

## Introduction: Transaction What is a transaction? A transaction consists of one or more SQL statements as a single unit. Each SQL statement in this unit is interdependent, and the unit as a whole is indivisible. If a statement in the unit cannot complete successfully, the entire unit will be rolled back and all affected data will be returned to the state before the transaction started. Therefore, only when all statements in the transaction are successfully executed can the transaction be said to be successfully executed. Four characteristics of transactions: Atomicity, each transaction must be considered an indivisible unit. Consistent

3. In-depth understanding of MySQL Advanced Drifting (4)

Introduction: Join Cross Join The simplest type of join is a cross join, which involves multiplying the tables to create an all-encompassing product. Example: select * from student,person;//The result is a combination of the two tables. All columns of the two tables are combined to produce a result set containing all possible combinations. This type is called a cross join, and the number of rows in the resulting table after the join is the same multiplied by the number of rows in each table used for the join. The above cross-connection will have a great impact on the performance of the database server, so use

4 in the connection. In-depth understanding of MySQL Advanced Wanderings (3)

Introduction: Function mathematics function requirements: 1) The absolute value of -123; 2) 100,88, 33,156 takes the maximum value; Aggregation function MySQL has a set of functions that are specially designed for summation or centralized summary of data in the table. These functions are often used in select queries containing group by clauses. Of course, they can also be used for Query without group 1) Among this set of functions, the most commonly used is the COUNT() function, which calculates the number of rows in the result set that contain at least one non-null value select co

5. In-depth understanding of MySQL Advanced Drifting (2)

# Introduction: Operators Arithmetic operators MySQL supports most common arithmetic operators that allow us to perform calculations. "+ (addition), - (subtraction), * (multiplication), / (division, return quotient), % (division, return remainder)", as in the following example: select 1+2; //Addition operation, the result is 3 select 2-1;//Subtraction operation, the result is 1 select 3*2;//Multiplication operation, the result is 6 select 6/2;//Division operation, the result is 3 select 25%7;//Division operation

6. In-depth understanding of MySQL Advanced Drifting (1)

Introduction: Numeric types Numeric types are roughly divided into two categories: one is an integer, and the other is a floating point number or decimal. The commonly used integer type is the int type, and the allowed range is between (-2147483648, 2147483648). Common types of floating point numbers or decimals are: float, double and decimal types. float type (single-precision floating-point value); double type (double-precision floating-point value); decimal type (used in calculations that require very high precision; these types allow the precision and count of the value to be specified

7. Mysql Advanced (Twenty-five) Solve the database NO CONNECTION problem

Introduction: When the application connects to the database, it prompts that the database connection failed. Open the database and view the following. Mysql Advanced (24) Summary of methods to defend against SQL injection

## Introduction: This article mainly explains the methods to defend against SQL injection. It introduces what injection is, what are the reasons for injection, and how to defend against it. Friends who need it can refer to it

##9.

mysql Advanced (Twenty-three) Database Transactions. Four major characteristics

Introduction: The atomicity of a transaction means that the program included in the transaction acts as a database A logical unit of work, the data modification operations it performs are either all performed or not performed at all.

10.

mysql advanced. (22) MySQL error: Incorrect string value: '\xE7\x81\xAB\xE7\x8B\x90... Incorrect Chinese character input

Introduction: During the experiment, the output parameters need to be written to the database. During the writing process, an error occurred when executing the lab_dynamic_order.upd_upd() statement. I didn’t understand it at first. There is something wrong. I tried to ask Du Niang for help. Some people on the Internet said that it was because of the input of Chinese characters, so I copied the string containing Chinese characters to be written to MySQL, and an Incorrect string value: ' appeared when saving. \xE7\x81\xAB\xE7\x8B\x90...' for column 'tout' at row 1 error message. Then another search, the solution is as follows:

The above is the detailed content of 10 recommended courses for advanced mysql. For more information, please follow other related articles on the PHP Chinese website!