MySQL

MySQL wildcard charactersThe pattern match for SQL agrees that you use "_" to match any single character, while "%" matches the random number of characters (containing 0 characters). In MySQL, the default mode of SQL is to ignore uppercase and

The error when compiling MySQL is as follows:/usr/local/src/lamp/mysql-5.5.37/vio/viossl.c:in function 'ssl_do':/usr/local/src/lamp/mysql-5.5.37/vio/viossl.c:175: error: 'ssl_op_no_compression' not declared ( used for the first time within this

Change the structure of the data table:ALTER TABLE Tb_name Action,[action,action] (before using ALTER TABLE, you need to see the current definition of the data table and need to execute the show CREATE TABLE statement)ALTER TABLE Tb_name modify

PS: This article takes the command as the index, each list oneself in the daily work involves some MySQL common operation, supplements ing1. Command Showmysql> show status;  #查看系统状态信息, positioning with Show status  like ' * * *

Update Po_headerSet Total_fee = (Select Ip.payment-ip.post_feeFrom Po_header IPwhere ip.po_header_id = po_header_id)where trade_id in (Select trade_id from trade where shop_id = 2094;The above update script needs to be done in MySQL by

Chapter 5th inserting updates and deleting dataConnect to SCHOOLDB using the SQL Manager management tool. Because the primary key is set for three tables, the primary key cannot be weighed in the following exercise.Inserting data1. Exercise: Insert

MySQL User directory, in addition to the data file directory, the other files and directories owner is changed to rootDelete empty account drop user ' @ ' localhost ';Set a password for rootWrite user= ', password= ' password ' in [client], then

Recently, a deadlock problem was frequently encountered on the database. The problem with performance is1. There is a query for:1) A complex select Investigates a large set of data2) Use transactions to update the state of this set of dataIn order

Create a tableCREATE TABLE ' T1 ' (' id ' int (one) not NULL auto_increment,' msg ' varchar (+) not NULL DEFAULT ' ',' crcmsg ' int (+) is not NULL DEFAULT ' 0 ',PRIMARY KEY (' id ')) Engine=myisam auto_increment=3 DEFAULT Charset=utf8Inserting

First, the primary database configuration assumes that the primary database IP address is: 192.168.1.1 Modify my.cnf Add configuration under [Mysqld] server-id=1Log-bin=syslog ##################################### Open LogBinlog-do-db=cmstop ########

Recently OJ and related open station abnormal slow, simply collapsed, has not found the reason!Go to the database server, go to MySQL, check it with show processlist command, find a lot of unauthenticated userGoogle a bit,Found that this is a MySQL

Click Start to open cmd, enter CD pointIn the new line, enter D:\Program files\mysql\mysql Server 5.7\bin (the folder where Mysql.exe is located), click EnterAt this point, the content is entered, the template is: mysql-hlocalhost (server IP)-p3306 (

Installation Environment:Ubuntu Desktop Edition 13.04Installation version:Mysql-5.6.12.tar.gz1.To install the prerequisite tools: sudo apt-get install CMake libncurses5-Dev Bison g+ + 2 Add groups and users and install directory

MySQL restricts the size of packets accepted by the server according to the configuration file.Sometimes large inserts and updates are limited by the Max_allowed_packet parameter, causing the write or update to fail.View current configurationShow

MySQL password forgot, operation steps:1. Service Mysqld Stop2, Vim/etc/my.cnf #编辑MySQL配置文件, find [mysqld], add a line below Skip-grant-tables3. Mysql-u root-p directly into MySQL console4. Update Mysql.user set Password=password (' MySQL new

Mysql optimization experience One day, O & M suddenly said that the channel page interface of the wireless terminal had a large amount of traffic, and the memcache cache could not handle it. As a result, the mysql concurrent query volume was too

How to restore mysql growth from 1 How to restore the problem of automatic mysql growth from 1In a table, I set autoid to auto-increment column.For example, the following data is available:1 Zhang Weinan 202 Wang wumale 223 Li Si male 254. Chen

Some instances understand the mysql database Stored ProceduresMysql stored procedure: encapsulate SQL: Create procedure p1 () beginselect * from t_news; end $ // simple mysql Stored procedure instanceDisplay stored procedure information: \ G

Install MySQL on linux source code Recently, MySQL Fabric needs to be used. This product is a utility generated after MySQL5.6.10. MySQL5.1 is installed on the machine at hand. Therefore, you need to upgrade the old MySQL version to MySQL 5.6 first.

Mysql hash index optimization and mysqlhash Index Create a table Create table 't1 '('Id' int (11) not null AUTO_INCREMENT,'Msg 'varchar (20) not null default '','Crcmsg 'int (15) not null default '0 ',Primary key ('id ')) ENGINE = MyISAM