MySQL

I have long heard that the two commands, lock tables and unlock tables, literally know that the function of the former is to lock the table and the latter is to unlock it. But how to use, how to use, not very clear. Today, in a detailed study, we

Empty cache Primary Execute flush command, must have reload permissionFlush hosts empties the host cache table. If the host changes IP, or receives an error host...is blocked, empty the host table. When connecting to a MySQL server, a specified host

MySQL's website: http://www.mysql.com/downloads/There will be several versions of the selection in this download screen.1. MySQL Community Server Community version, open source is free, but does not provide official technical support.2. MySQL

"to the program Ape on the road."For a developer, the ability to develop a free module in a system is the embodiment of its core value.For an architect, mastering the advantages of various languages and applying them to the system simplifies the

--INNER JOIN----SelectGoods_id,goods_name,cate_name fromTdb_goodsInner JoinTdb_goods_cates ontdb_goods.cate_id=tdb_goods_cates.cate_id\g; The inner join returns both tables .SelectGoods_id,goods_name,brand_name fromTdb_goodsInner JoinTdb_brand ontdb_

First,Common topologies for replicationThe architecture of replication has the following basic principles:(1) Each slave can have only one master;(2) Each slave can only have a unique server ID;(3) Each master can have a lot of slave;(4) If you set

"1" Create Employee profile formRequirements field: Employee employee number, employee name, gender, salary, email, entry time, department."2" reasonable choice of data type and field modifiers, requires not null,auto_increment, primary key and so

INSERT into table (ID, name, age) VALUES (1, "A", +) on duplicate key update name=values (name), Age=values (age)/* Insert Data: If there are duplicates, select Update; */Insert ignore into ' testtable ' (' Mpass ', ' Pass ') select Mpass,pass from

Index consolidation Optimization official website translationMySQL5.7 Document Index Merging is intended to reduce several ranges (the range type in the type: range can used when a key column is compared to a constant using any of the =, & Lt;>,, >=,

OverviewThis chapter mainly writes about how to generate a new slow query file online when the slow query file is very large.Test environment: MySQL 5.6.21StepsConfigure Slow QueryThe default my.cnf file is in

Demand:The boss gave an Excel data, is a template I provide, including ID, now equivalent to import this new column of data to a table in the database.Method One: Use Navicat, copy a column in Excel, and then paste it into a column in the

Mysql+pam-based VSFTPD virtual User ConfigurationFirst, the experimental explanationOperating system: Redhat5.8_x64bitExperimental platform: VMware WorkstationRequired Packages: P am_mysql-0.7rc1.tar.gzSecond, the installation of the necessary

First, the Preparation toolVisual Stuido (this example uses Visual Studio 2010)MySql.Data.dllMysql_installer_community_v5.6.21.1_setup.1415604646.msi (online search to download or request from me, contact information in

#-----------------------------CentOS 6.x version upgrade MySQL------------------#! /bin/sh#1. Turn off SELinuxCp-rp/etc/selinux/config/etc/selinux/config.bakSetenforce 0Sed-i ' 7s/enforcing/disabled/'/etc/selinux/config#2. Show SELinux status

Before MySQL5.0, a table in a statement can use only one index and cannot use multiple indexes at the same time. However, starting with 5.1, the index merge optimization technique is introduced, and multiple indexes can be used for the same table.

How do I create a table with SQL statements under the Navicat for MySQL interface? Let me tell you in a small series below. First Open the Navicat, select a database, click "Query", on the right click "Create Query", enter the SQL statement, click "

This article has referred to Http://www.tuicool.com/articles/3iUNFnA and has made some additions to the details. Make the installation process smoother.The first thing to say is that Ubuntu requires the sudo command, so start with sudo on the

Mysql semi-sync source code implementation, mysqlsemi-sync Mysql replication briefly introduces the causes of mysql semi-sync, and explains how semi-sync ensures that no data is lost. This article focuses on the implementation of semi-sync, and

MySQL remote connection and mysql connection Overview This article describes how to create a remote connection table through the federated storage engine. Test environment: mysql 5.6.21  Procedure Enable federated storage engine Check whether the

MySQL Performance-Schema (1) configuration table, performanceschema Performance-schema was first introduced in MYSQL 5.5, but now more metrics are added to performance-Schema in MYSQL 5.6 and 5.7, and more statistics are available, more and more