MySQL

mysql-Configuring environment variables and Change PasswordFirst,　　 Flash Back Issues1.1. No environment variables are configuredFor example:　　　　　　1.2. Enter directly without entering a passwordEnter the password step directly in.1.3. MySQL service

Backup permissionsGRANT USAGE on *. * To'Backup'@'172.16.0.157'Identified by PASSWORD'*38b4f16eadb1601e713d9f03f1dfa1f71c624a91'; #GRANT USAGE on*. * To'Backup'@'172.16.0.157'Identified by'123456'; GRANT SELECT, LOCK TABLES, SHOW VIEW, TRIGGER on '

1. Create a foreign key 　　 Create Table Table name>(Field>Field type not NULL,Field>Field type not NULL,Field>Field type not NULL,Foreign Key(Field>)References Primary table name>(Field>));2.Mysql connection (left join, right join, INNER join, full

For example, to query the new registered users yesterday, the following two types of writing:EXPLAINSelect * fromChess_user uwhereDate_format (U.register_time,'%y-%m-%d')='2018-01-25'; EXPLAINSelect * fromChess_user uwhereU.register_timebetween '20

1, installation Mysql-server-"sudo apt-get install Mysql-serverYou can enter the root password2. Modify Server ConfigurationDefault mysql-server only native access, new version of MySQL configuration file location changes.-"CD/ETC/MYSQL/MYSQL.CONF.D-

1. Download (local download www.mysql.com----->downloads------>archives----->mysql Community Server---->linux- Generic) Example: Mysql-8.0.3-rc-linux-glibc2.12-x86_64.tar(Download wget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.36-linux-glibc2

1, for the primary key and unique index, you can use the IGNORE keyword, encountered duplicate records will directly ignore the Insert record, return 0.Insert ignore into table_name (' ID ', ' name ') VALUES (1, ' Eddy ')2.Replace keyword: replace

The "Mysqlcheck" command is a command from MySQL that we can use to check if the tables in the database are normal.One, check a table# mysqlcheck 数据库 表名 -uroot -p"password"Second, check all the tables under a database# mysqlcheck 数据库 -uroot

#################### #数据库装包改密码 ########################!/bin/bashFirewall-cmd--set-default-zone=trustedSetenforce 0#tar-XF Mysql-5.7.17-1.el7.x86_64.rpm-bundle.tarRM-RF mysql-community-server-minimal-5.7.17-1.el7.x86_64.rpmYum-y Install

Introduction to Essentials1. Syntax for SELECT statements2. Simple Query3. Connection Query4. Joint Queries5. Sub-query6. Regular expression Queries7. Querying data with regular expressions1. Syntax for SELECT statementsHttp://www.cnblogs.com/HZY258/

One. MySQL Service installation1. Download:Address: http://dev.mysql.com/downloads/mysql/2. Installation:The entire directory after extracting the downloaded mysql-5.7.16-winx64 compressed package is placed in your favorite location, I put it in the

Primary database server Configuration Master 51Master from the configuration to maintain two databases in the database and table consistent1 Doing user authorization2 Enable Binlog logging3 Viewing the Binlog log file in use1.mysql> grant

/* time:2017.01.02--2017.01.04* AUTHOR:WJ* Function: Connect the database, read the picture from the database and display (succeeded)*/"Reference link"MySQL deposit image +QT read in the database read the picture-lpdpzc column-Blog channel-csdn.net

MySQL sub-table scene analysis and simple sub-table operationWhy do you want to divide tablesFirst of all to know what the situation, only need to divide the table of individuals feel that the number of single-table records to the million to tens to

Yesterday encountered a more bizarre problem, when using MySQL paging query data,Some of the data is clearly in the database, but it is not found, some data will insteadRecur.This involves a problem with MySQL itself.The specific phenomenon is

Query: Field Select field 1, Field 2, Field 3 from table name where condition"+" sign: Only for numeric calculations select 1+2 or select 1+ ' 2 '"CONCAT": Used for connection string CONCAT (character 1, character 2), such as a select CONCAT (12)

WINDOW10 installation mysql-5.7. --Winx64.zip Original https://www.cnblogs.com/ericli-ericli/p/6916285.htmlD:\share\src\window7-mysql\mysql-5.7. --Winx64.zip1. Unzip2. Create My.ini, under the Basedir directory [client]default-character-Set=UTF8

I. Introduction to the LibraryINFORMATION_SCHEMA: Virtual library, do not occupy disk space, storage is the database startup parameters, such as user table information, column information, permission information, character information and so on

Recently requested by the company, in doing database import export. The amount of data per day is about 350W. After a lot of testing, I feel the following method is betterData export :SELECT into ... OUTFILEBasic syntax:SELECT[IntoOUTFILE '

MySQL: database entry 3: mysql database entry   1. Logic execution sequence of SQL statements (7) SELECT(8) DISTINCT (1) FROM (3) JOIN (2) ON (4) WHERE (5) group by (6) HAVING (9) order by (10) LIMIT 2.Foreign key constraintAdd a foreign key:Alter