MySQL

1: Download the binary installation package (make sure no MySQL database server is installed): mariadb-10.2.12-linux-x86_64.tar.gz, mariadb-10.2.12.tar.gz.2: Create a System account specify the shell type (default automatically creates a group with

MySQL Host Master1. Edit the MySQL configuration file my.cnfserver_id = 1 #server_id服务器唯一标识Log_bin = Mysql-bin #借助mysql配置文件打开binlogRestart MySQL2. Create a user for master-slave replicationmysql> create user ' repl ' @ ' 172.17.0.% ' identified by '

In the database command line only exports the data, does not have around the data structure the time appears secure_file_priv option so it cannot the execute this statement error.Here's how to fix it:1. Create a new directory to/path/to/mysql-files

Reference Document Http://www.linuxidc.com/Linux/2016-09/135288.htmInstallation Environment: CentOS7 64-bitInstallation version: mysql5.7 versionInstalling MySQL with Yum Online installation can also be installed offline, here is only a relatively

1. Look under the current server, what are those libraries (database)?Answer: show databases;2. How can I create a database?A: The database name is the last face of the create, and the semicolon ends3. Select a databaseWhen you make a table, row,

In MySQL, you cannot use the result of the set select directly, you must use the INNER join:Update TB1 INNER JOIN (SELECT ' field ' from TB2) tb3 on tb1.id =tb2.id set tb1. ' Field 1 ' = tb3. ' Field 1 'In SQL Server, we are updating the table with

1. To optimize the query, avoid full-table scanning as far as possible, and first consider establishing an index on the columns involved in the Where and order by.2. Try to avoid using the! = or <> operator in the WHERE clause, or discard the engine

First, the system environmentThe system version after the Yum update upgrade isSecond, MySQL installationGenerally, the information given on the Internet is#yum Install Mysql#yum install Mysql-server#yum install Mysql-develBoth MySQL and Mysql-devel

1, inner connection inner JOINAn inner connection, also known as an equivalent connection, inner join produces a set of data that conforms to both A and B tables.INNER JOIN syntaxSELECT * FROM A inner join B on a.name = B.name;2, natural connection

The scenario is as follows:"Today's front-end suddenly said, I need to make a judgment, can not repeat the collection, I like the neck of the icy shudder, so think what I should do?" Why did she think that I didn't think it was my job?Think of three

Recently working with the Hive tool, a hive test environment was built. Usually we store the hive metadata information in the outside of MySQL, so we need to install and configure the MySQL database. The next step is to explain the installation and

1. CONCAT (string1,string2,...)SELECT CONCAT (' L7 's jersey number is ', L7number) from tableIf one of the parameters is null, the result of stitching is null2.concat_ws (SEPARATOR,STR1,STR2,...)Separator represents the delimiter, if the delimiter

Table structure replication (with data)CREATE TABLE New SELECT * FROM oldTable structure replication (without data)CREATE TABLE New SELECT * from old where 1=2This gives a where condition 1=2 is to give the data to an empty tableTable structure

Xtrabackup backup MySQLMysqldump is based on a logical backup, which is equivalent to re-executing the SQL statement. Xtrabackup is equivalent to a physical backup of a file.Installation dependencieswget ftp://rpmfind.net/linux/dag/redhat/el6/en/x86_

Mysql common functions Common functions: Length () indicates the length of the returned bytes. Char_length () indicates the number of returned characters. Rand () indicates the random decimal place between 0 and 1. Round () indicates rounding.

Mysql exercise questions, Table Structure and data: http://www.cnblogs.com/wupeiqi/articles/5748496.html Question:2. query the student ID of all students whose score is higher than that of the "physical" course;1)Select A. student_id, biological

Mysql series learning, mysql Series # HelpHelp create user;# View current userSelect user ();# Create a userCreate user 'egon' @ 'localhost' identified by '2013 ';Create user 'Alex '@' % 'identified by '201312 ';Create user 'ton '@ '192. 192. %'

In linux, configure mysql5.6 to support IPV6 connections. Introduction: This article describes how to configure mysql to support IPV6 connections in linux. Environment requirements: 1. debian7.5 Operating System Virtual Machine 2. MySQL database,

Principle-indexing and principle Indexing We strongly recommend that you refer to the link:Http://www.linezing.com/blog? P = 798 # nav-1   To put it bluntly, the indexing problem is a search problem...   Database indexIt is a sorted data structure

SQL queries by a value of the date. -- Take 12:56:55 as an Example-- Convert (nvarchar (10), CreateDate, 120) => 2013-12-10-- DATEPART (month, CreateDate) => 12-- DATEPART (year, CreateDate) = & gt; 2013 -- This is also possible-- YearSelect