MySQL

MyISAMReadBetter performance than Innodb MyISAM indexes and data are separated, and the indexes are compressed. Innodb is closely bound to indexes and data. Without compression, Innodb is much larger than MyISAM. MyISAM does not support

This morning, a friend told me that his mysql had forgotten the root password and asked me to help you. I found the information online because I have never been in touch with mysql. I have already put it into practice! The mysql version is 5.1 The

Use REGEXP keyword 1. Basic Character matching SELECT prod_nameFrom ProductsWhere prod_name REGEXP'.000'Difference between LIKE and REGEXP LIKE matches this column, while REGEXP matches the column value. Regular Expressions in MySQL are

In the project, you need to search for a large text field. The result shows an interesting problem. The fuzzy match mode such as % LIKE % was used, the two strings must be exactly the same before they can be matched. Then, the two strings are output

Http://www.fastcloud.cn/zhishi/zhishi387.html I wanted to write an article a long time ago to introduce some of the things that Internet DBAs need to do. However, I am not busy with platform construction. Recently, all modules have begun to take

Database Backup is extremely important. If there is no backup, the system will go crazy in the following situations:UPDATE or DELETE whitout where... Table was DROPPed accidentally... INNODB was upload upt... Entire datacenter loses power... From

Use the REGEXP keyword 1. Basic Character matching ? 1 2 3 SELECT prod_name From Products Where prod_name REGEXP '. 000' Difference between LIKE and REGEXP LIKE matches this column, while REGEXP matches the column

Configure mysql master-slave replication in Windows 8.1. test environment overview win8os, 64-bit OS, memory, download mysql5.6.16-winx64.zip package on the local disk decompress two mysql, ports 3310 and 3311, namely: localhost: 3310 -- master

-- MySQL group sorting is the simplest SQL statement for the first N records.N> ( The result is as follows: mysql> SELECT * FROM (SELECT cid,author,COUNT(*) AS number FROM test GROUP BY cid,author) a -> WHERE -> 3>( -> SELECT COUNT(*)

Modify Table Structure:? 1 Alter [ignore] table This includes changing table attributes, Changing Column attributes, and changing integrity constraints.   1. Table attribute change 1.1 rename a table name?

MYSQL was used in a recent project, because I had done it before, so I didn't think much about it. I just finished the next step. On the official website, I decided to launch an installer (5.26), modified the default location and configuration,

I. Data Tables To ensure data integrity and consistency, you must specify the field name, field type, and field attribute when creating a table. Constraints, indexes, and ), primary key and foregin key. Constraints: Not null non-empty

Description of the EXPLAIN column:Table: displays the data of this row about which tableType: this is an important column that shows the type used by the connection. The connection types from the best to the worst are const, eq_reg, ref, range,

Just migrated a project to the newly installed linux system, because mysql is used to install it: Yum install mysql Yum install mysql-server Then start the mysql service: Service mysqd start At this time, you can log on, but the root user

Originally, LAMP programmers had to use the help of the operating system to complete some periodic database operation tasks, such as Windows scheduled tasks or Linux contab. MySQL5.1 has finally added the Event Scheduler function, which allows you

Copy codeThe Code is as follows:Mysql>Mysql> delimiter $Mysql>Mysql> create procedure myProc ()-> MODIFIES SQL DATA-> BEGIN-> DECLARE l_status VARCHAR (20 );->-> CALL myProc1 (l_status );-> IF l_status = 'duplicate Entry 'THEN-> Select concat

Introduction: MySQL 5.0.94, which is a later version (5.5, 6, and so on) does not support recursive queries. Compared with SQL Server and oracle, it is difficult for mysql to traverse child nodes in a tree table. This program focuses on the

A stored procedure is a collection of user-defined SQL statements involving tasks of a specific table or other objects. You can call the stored procedure. A function is usually a database-defined method, it receives parameters and returns some type

Copy codeThe Code is as follows:Create table shujubiao (Id int primary key auto_increment, specified as I integerName varchar (32) not null, which is an unfixed length. The maximum value is 32 characters and cannot be blank.Password varchar (64) not

MYSQL is UTF8 encoded. However, no matter how many UTF8 definitions are added to the webpage, the displayed results still have some small grids. In addition, LIKE Chinese is used in SQL statements, which cannot be queried. Instead, it is defined as