MySQL

1. General exception only need to skip one step to recover>slave stop;>set GLOBAL sql_slave_skip_counter = 1;>slave start;2. The last Bin-log log of the main library is restored when the power failure causes the master/slave to be unable to

How to combine fields from multiple tables in MySQL and then insert them into a new table, implemented by an SQL statement. The case is: there are three tables A, B, C, now you need to check the values of several fields from table B and table C into

-When changing the value of the field, or write directly, the Chinese characters become garbled, "can pay attention to the database name, remember to modify"-when the character sequence is incompatible with Chinese characters, it may directly lead

Calculated fieldsThe tables stored in the database are stored in columns, but sometimes the information the client wants to get is a combination of several columns, or a sum value. This combination or sum action can be done in the client application,

MySQL is a must-have database for storing Superuser and managing some permissions.Update user set Password=password ("123321") where user= ' root '; The password for Update root is 123321Flush privileges; Refresh the databaseMysql-u root-p; Login

§1. InnoDB row locks are implemented by locking the index entries on the index, unlike Oracle, which is implemented by locking the corresponding data rows in the data block.InnoDB This type of row lock implementation is characterized by the fact

Install a MySQL to D drive. Then copy the D-disk MySQL folder to another disk. I choose the e-drive here.After you modify the My.ini port number in the root directory[Mysqld]Port= 3307PS: Be sure to separate from the other area.Installation Services

Log in to a server when the MySQL total error:Mysql2/client.rb:58:in ' Connect ': Access denied for user ' root ' @ ' localhost ' (using Password:yes) (Mysql2::error)Workaround:The same is true of the solution under Windows[SQL]View Plaincopy

1. Hash partition PS:: Personally think that the hash partition is very good and powerful, simple and accurate distribution extremely evenly created instances:CREATE TABLEhash_emp (Tidint, TnameChar(255)) PARTITION byHASH (TID) partitions8; The TID

The mapper file is written as: (fuzzy query, query time period) and sc.com_name like CONCAT (CONCAT ('% ', #{com_name}), '% ') = date_format (#{check_begin_date}, '%Y-%m-% d ')]]>

SQL Server data import MySQLTools: Navicat for MySQL Baidu search an installation can, if you have installed MySQL1, create the target databaseClick on the Create a good target database website point table One item, on the right side of the Import

1generally, by default, Sql_mode is empty, which is not a strict SQL check.2if the Sql_mode is empty, test:Create TableTT3 (nameChar(2));//define a tt3 table with a name field length of 2Insert intoTt3Values('wo');//normal insertion, flawlessInsert

Transferred from: http://blog.csdn.net/apache6/article/details/2778878There are two ways to delete data in MySQL, one is a DELETE statement and the other is a TRUNCATE TABLE statement .The DELETE statement can select the record to be deleted by

MySQL default maximum connection number is 100, add the default MySQL connection number method has twoMethod One: Enter the MySQL installation directory to open the MySQL profile my.ini (Windows) or MY.CNF (Linux environment) lookup max_connections=1

After the query data, finally the MySQL master-slave copy is done. This version is mysql5.0. Okay, start talking about the steps.First, the previous article has already said that it is necessary to copy an installation file to another disk. Next,

Issue one: MySQL user login without authentication password (user has set password)After the installation of MySQL, I found that I set up a password, the same can be used without a password to loginCmd>mysqlCmd>select Current_User

Overall Backup:Back up the entire table or entire database or even all databases.Incremental backup:Back up the data in a range.1, the overall backup:To back up a table:For tables with storage engine MyISAM, you can copy the three files of frm, myd,

is MySQL purge log simple?simple: The Purge log function is simple, purge master logs to specify a binlog, then delete the Binlog file on the previous file system and update the Binlog.index file.Complex: need to guarantee purge atomic operation,

SelectID= "XXX" >select * from XXXDynamicprepend= "Limit" > isnotequal Property= "num"CompareValue= "0" >0, #num #isnotequal> Dynamic> Select>OrSelectID= "XXX">select * from XXXDynamicprepend= "Limit"> Isnotnull Property=

Mysql operation SQL statement, mysqlsql statement Ii. Database Operation SQL statements1. display the current database on the serverShow databases; 2. Create a database named rewinCreate database rewin; 3. delete a database named rewinDrop database