MySQL

MySQL Sort by Chinese name  sql code  www.2cto.com  /*  navicat MySQL Data Transfer    source Server        : local  source Server version:50022  source Host         &NBS P : localhost:3306  source Database      : Test    target Server Type    : MYS

--Single field indexCREATE INDEXLast_name_index - onemployee_tbl (last_name); Query OK,0Rows Affected (0.06sec)--Unique indexCREATE UNIQUE INDEXLast_name_unique_index - onemployee_tbl (last_name); ERROR1062(23000): Duplicate Entry'GLASS' for Key '

Tips for testing MySQL with SQLyog:ERROR N0.1130 Host ' 192.168.100.111 ' is not allowed to connect to this MYSQL server650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6D/CC/wKiom1VsAdig8J8RAAB-g30Pa6I714.jpg "title=" Qq20150601145447.png

MySQL method for starting and closing foreign KEY constraints (Foreign_key_checks)When you delete a table or a piece of data in MySQL, it appearsThis is because the foreign Key association is set in MySQL, resulting in the inability to update or

1. Load DriverString drivername= "Com.mysql.jdbc.Driver"; Database-driven Classpathtry{Class.forName (drivername); Create a driverSystem.out.println ("Create driver success!") ");}catch (ClassNotFoundException e) {E.printstacktrace ();}2. Define

1. Installation1. See if you have mSQL installedyum list installed mysql*-qa | grep mysql*2. See if there are any installation packagesYum list mysql*3. Install the MySQL clientYum install MySQL4. Installing the MySQL ServiceYum Install

0. DescriptionMySQL service version best consistent, inconsistent may cause problemsmaster database ip:192.168.0.10Slave database ip:192.168.0.111. Modify Master server Mastervi /etc/my.cnf[mysqld]log-bin=mysql-bin #[must be] enable binary log

The InnoDB engine differs from the MyISAM engine. MyISAM InnoDB row-level lock non-object security things security full-text indexing full-text

MySQL indexes and keys(Different indexes have different functions, different constraints, different rules of use)Pros: For a table, an index is like a book's directory that can speed up queriesCons: Occupy physical storage space (index information

When using the group by group query, the default grouping is also sorted (using Filesort) and may slow down. Workaround: Add order by NULL to not sort itSelect * from Group by Empno orderbynull; In some cases, you can use a

One, string to dateHere's how to convert a string into a date in MySQL:Background: RQ field information is: 201009011, do not need to convert:SELECT * from Tairlist_day WHERE rq> ' 2010-07-31 ' and rq2. Use: Date_formatSELECT * from Tairlist_day

Method one: After ignoring the error, continue syncingThis method is applicable to the case that the data of master-slave database is not very different, or the data can not be completely unified, the data requirements are not strict.Stop

MySQL master-slave switchMaster stop, from the bossThe steps are as follows:1 Confirm that all synchronization operations have been completed from the server:Stop slave Io_threadShow ProcesslistUntil you see the status: XXX has read all relay log

Bug #19528825 "unable to purge a record ", Overview: In the production environment, when insert buffer is enabled (innodb_change_buffering = all), some instances occasionally encounter the "unable to purge a record" error. This is actually an old

Mysql allows remote login configuration Two steps: 1. Change the "host" in the "user" table in the "mysql" Database (you can log on remotely after this step) X: \> mysql-u root-pvmwareMysql> use mysql;Mysql> update user set host = '%

MySQL Query OptimizationThere are many things to optimize database queries. The basic principles are as follows: reduce the disk I/O count that occurs during database queries. Use indexes to avoid full table traversal and scan to reduce the amount

Orderby Optimization-mysql The rder by keyword is optimized. We will analyze it today. First, let's take a look at the mysql official documentation on how to optimize the order by keyword. 8.2.1.15 order by Optimization The following statements use

A cluster problem case solved by the MySQL slave_net_timeout parameter, slavenettimeout Background]After upgrading from 5.5 to 5.6 for a set of database clusters, alter. log reports a warning exception.Copy codeThe Code is as follows:15:44:51 19633 [

MySQL 5.7 enhanced version Semisync Replication performance optimization, mysqlreplication Preface The previous article introduced the basic principles and configurations of MySQL semi sync in MySQL 5.5/5.6. With the release of MySQL 5.7, the new

MySQL Semisynchronous Replication introduction, Preface Before MySQL 5.5, the default Replication mode is Asynchronous. MySQL 5.5 provides the Semisynchronous Replication mode as plugins. Before introducing semi sync, we should first understand: