MySQL

  The previous sections have tracked Connection Manager and Thread Manager. In the Connection process, there is also an identity authentication process, which is familiar to everyone.   In the process of verifying the user name and password,

When an independent tablespace is used, if the metadata file ibdata of the innodb Storage engine is damaged accidentally, we can save valuable data. when innodb uses an independent tablespace, The ibdata file records the id of each innodb table, as

Query index page fragments: show table status like 'table name'; // when the value of the Data_free column is greater than 0, fragments are generated (as long as data is deleted, the premise is to create an index) OPTIMIZE the TABLE: optimize table

Mysql prompt is a very useful command. You may be very worried about the database you are operating on when you operate mysql through the command line. At least I have struggled with it, maybe you will say that I don't know if I just run a command.

MySQL experience 8-2-use SQL statements to back up and restore table data 1. Use SQL statements to back up and restore table data (for more information, see this article). You can use SELECT... The OUTFILE statement exports table DATA to a text file

MySQL experience 9-USER and data security 1. You can use the create user syntax to add one or more users and set the corresponding password. Syntax format: create user user [identified BY [PASSWORD] 'Password'] [, user [identified by [password]

Mysql Data Type 1. mysql Data TypeMysql has the following data types:(1) The numeric value www.2cto.com is a value such as 32 or 153.4. Mysql supports scientific notation, which is expressed by an integer or floating point followed by "e" or "e", a

Mysql automatic backup solution 1. Configure the database server 1. Write the mysql automatic backup script mysql backup mainly includes hot backup and cold backup. Hot Backup is used here, that is, using mysqldump to export SQL statements to back

MySQL stress testing tool mysqlslap -- create-schema = example -- query = "SELECT * FROM group_message force index (group_message_author_subject) WHERE author = '3' subject LIKE 'weiurazs % '"-- iterations = 10000 the test table needs to be

Mysql queries non-duplicated row content and the number of non-Repeated Records count. distinct has such a table that records id, p_id, p_name, p_content, p_time 1 343 aaa aaaaaa 2012-09-01 2 344 bbb bbbbbb 2012-09-02 3 321 ccc cccccccc 2012-09-03

Difference between SYSDATE () And NOW () in MySQL five functions in MySQL need to calculate the value of the current time: NOW. return time. Format: 2012-09-23 06: 48: 28 CURDATE. Date of the returned time. Format: 2012-09-23CURTIME. Format: 06: 48:

Mysql slow query log process mysql slow query log is very useful for tracking problematic queries, you can analyze the resource-consuming SQL statements in code implementation, there is a high reference for our program optimization. This article

Mysql statement: set names UTF8 has always known only mysql_query ("set names UTF8"); it sets the database encoding, but it has never been clear what "set names UTF8" is. It is not until today that the set names... is a mysql statement. I really

Ubuntu mysql client emma Chinese garbled problem solution emma is installed with apt-get by default, emma does not support Chinese, the configuration file or directly modify the emma program source file (python ). Apt-get install emmasudo apt-get

Set TimeStamp for multiple timestamp in mysql. The Default value is DEFAULT CURRENT_TIMESTAMP. The value of timestamp is automatically updated as the table changes. The value is on update CURRENT_TIMESTAMP. However, because a table ON www.2cto.com

The mysql function replaces the related subquery (Correlated subquery) SQL code CREATE TABLE '2017 _ teacher '('Teacher _ id' int (11) NOT NULL, 'School _ id' int (11) not null, primary key ('Teacher _ id'), KEY '2017 _ teacher_idx_school '('school _

Mysql high-speed import and export of large TXT textLet's talk about how to use loaddata for mysql to import TXT www.2cto.com. MySQL's load data infile statement is used to read rows from a text file and LOAD rows into a table at a high speed. The

After the MyISAM data table deletes the maximum number of records, the number cannot be reused. You can use the "AUTO_INCREMENT = n" option to specify an auto-increment initial value when creating a table. After the table is created, use the alter

When the MySQL command line fails to enable slow. log, you need to check slow. log. However, it has been found that slow. log has not been written for a long time. Www.2cto.com looked at the server settings: root @ (none) 01:13:41> show global

Replace into and Insert... on duplicate key update... what's really different today I heard from my colleagues about the data migration from oracle to mysql. He used Insert ..... on duplicate key update ..., I was wondering why I didn't need Replace