MySQL

This article mainly introducesMySQL databaseStatement: the use of insert into select and Its syntax. Next we will introduce it through an example. We hope that this example will help you better understand the syntax of this statement, avoid

This article mainly introducesMySQLDatabaseINI FileThrough these attributes, we can understand some MySQL database initialization knowledge. Let's take a look at it. (1) back_log:The number of connections that MySQL can have. When the main MySQL

Mind Map Jieshao The most storage engines used in mysql are innodb and myisam. As the default storage engine of Mysql, myisam is worth learning. The following is my understanding of myisam mentioned in the High-Performance MYSQL. Please give me

Implemented through (prepare statement + view + static cursor) -- Create a test table and data create table webuser (username varchar (10); insert into webuser values ('a1'), ('a2 '), ('a3 '), ('b1 '), ('b2'), ('b3'); commit; -- create a stored

What is the performance of Mysql insert when executing data? It is estimated that most of the data cannot be answered. Today I am looking for some test articles, but I will test it myself to talk about data. I tested Mysql some time ago and got some

It may be that the IP address is not set. Problem: the MySQL permission is set correctly, but remote access is still unavailable. Port 3306 is not opened through telnet. Analysis: by default, MySQL only binds 127.0.0.1, that is, port 3306 can be

REGEXPExample 1. the query field contains non-English dataCopy codeThe Code is as follows:SELECT *FROM'm _ user'WHERE 'emp_no'REGEXP '[^-~] '= 1 Column 2. In this way, all non-English content can be obtained.Copy codeThe Code is as follows:SELECT

Bad SQL not only directly affects the SQL response time, but also affects the database performance, resulting in a longer response time for other normal SQL statements. It is vital to learn how to write SQL statements and view execution plans. The

1. The table's primary key and foreign key must have an index; 2. Indexes should be available for tables with more than 300 of the data volume; 3. For tables that are often connected to other tables, indexes should be created on the connection

What is a trigger? A trigger is a database program that monitors a behavior of a data table. Once the behavior of a data table occurs, the corresponding SQL statement is executed immediately.Syntax structure of the trigger: Name of the create

Copy codeThe Code is as follows:-- Create test tables and dataCreate table webuser (username varchar (10 ));Insert into webuser values ('a1'), ('a2 '), ('a3'), ('b1'), ('b2'), ('b3 ');Commit;-- Create a stored procedureDrop procedure if exists

Most of the time, when we create a database, we select varchar or nvarchar when setting the data type for the field. Of course, you can also select another data type. This article only describes the varchar and nvarchar types. Test Table Structure:

Install: unzip the package and use it. The start_navicat file in the directory is an executable file. Cracking: (I have found several registration codes that cannot be used, and the registration code generators are on windows platforms) ---- When

MySQL databases mainly have five types of logs: log-slow-queries, binary log (log-bin), and error log (log-error ), query logs and update logs ). In the new MySQL version, the update log has been canceled. You can use binary logs to replace this

The article "common methods of the query optimizer" lists some common optimization methods of the optimizer. The query optimizer also has some limitations while providing these features. These limitations are often improved with the upgrade of the

Summarize the optimization methods of common query statements.1 COUNT 1. Functions of COUNT · COUNT (table. filed) indicates the number of records for which this field is not null. · COUNT (*) or COUNT (not nullable field) indicates the number of

We often forget the mysql password and may need to modify it. Record the test results of how Baidu modified the mysql password:1. Add a line after the configuration file mysql. ini: Skip-grant-tablesIndicates skipping the authorization table.

Objectives: Key-List model, trillions of nodes, distributed and scalable, ensuring certain performance and high availability   Basic Idea: 1. The list corresponding to the same key should be as centralized as possible 2. Restrict the table size

1. Data in relational databases is stored as tables, so the storage engine can also be called the table type (that is, the type of the storage and operation table ). Query supported storage engines in MySQL: show engines; showengines/g or show

Translated by: Tie Time: December 25, 2013Original article address: Activating the Binary Log Reference: building a robust data center with high-availability MySQL To enable the binary log feature, you can use" -- Log-bin [= name]"Option to start