MySQL

#!/bin/bah#check_master-slave_status#check_time =10mmysqlip= ' ifconfig eth1|grep "inet addr" |awk-f[: "]+{' Print $4 '} 'Mysqlport= ' netstat-lntp|grep 3306|awk-f[: ']+ {' Print $ '} 'status=$ (mysql-uroot-p123456-e "show slave status\g;|grep-i

One, the installation of MySQL server1, the MySQL official website downloads the file package; "I am using the version: Mysql_5.7.17"2, decompression zip compression package;3. Install: Command line:d:\soft\mysql-5.7.17-winx64\bin> mysqld Install "

MySQL's SQL statement can use between to qualify a range of data, such as:SELECT * from user where userId between 5 and 7;The User,userid range for query UserID 5, 6,7, contains the boundary value, and is equivalent to the following query:SELECT *

MySQL master-slave configuration means a primary MySQL server, one from the MySQL server, a total of two servers to use. The main server added an account to allow access to the synchronization from the server, the master-slave configuration is

--24 hoursSELECTHOUR (create_date) ashours,SUM(Source_amount) Sm_source_amount,SUM(Ticket_count*Purchase_price) asSm_purchase_amount fromTicket_orderWHEREdate_format (Create_date,'%y-%m-%d')= '2017-05-12' andscenic_idinch(1,2,3);GROUP byHOUR

MySQL master-slave configuration. My humble opinion is tested in the following environment:Operating system where the primary database resides: Win7Master Database version: 5.0IP address of primary database: 192.168.1.111From the operating system

Sub-queryBefore you start to understand subqueries, start with the preparation, build 3 tables, One is the Customers table, which includes: Customer name, customer ID, customer tel, and so on. One is the Orders table, which

Introduction: In the local access to the database, the general use of localhost, 127.0.0.1来 for database access, but I have encountered these days only through 127.0.0.1来 access, but not based on localhost to access, very strange .....Environment

MySQL master-Slave synchronization monitoring script, using MySQL from the library IO and SQL process and delay time to monitor the master-slave synchronization is normal, detailed shell script is as follows:#!/bin/bash#author wangning#date 2017-7-17

First, error logWhen a database fails to work, the first time to view the log1, the server starts the shutdown process information2. Error messages during server operationLog storage path, which can be viewed by command:Log file naming format:

A 1032 error from the library, that 1032 is what error, we look at[[email protected] ~]# perror 1032MySQL error code 1032 (er_key_not_found): Can ' t find record in '%-.192s 'Simply put, it is not found in the corresponding records from the library,

Installing MAVEN1: Download maven package:Http://mirror.bit.edu.cn/apache/maven/maven-3/3.5.0/binaries/apache-maven-3.5.0-bin.tar.gz2, unzip the installation:Tar vxf apache-maven-3.5.0-bin.tar.gz-c/opt/MV Apache-maven-3.5.0-bin apache-maven-3.5.03,

Simulation test:QQ Database ManagementCreate a database and add relationships and test data1 # #创建QQ数据库, complete a simple test2 3 #创建数据库4 DROP DATABASE IF EXISTSmyqq;5 CREATE DATABASEmyqq;6 Usemyqq;7 8 #在数据库创建基本数据表9 Ten #创建User表 One DROP TABLE IF

Doc interface Operation Mysql:Taking Phpstudy as an exampleLogin database: Enter Phpstudy/mysql/bin, mysql-u user name-p passwordSelect database: Use database name;Set encoding format: set names GBK;View table structure or field information: DESC

Long time did not start the local MySQL, today open the small dolphin, directly to me pop up the connection failure, this is how to go directly into the command line, found there are problems, enter the password after a flash, there is no hint of

ObjectiveInnoDB and MyISAM are the two most common table types used by many people when using MySQL, both of which have pros and cons, depending on the application.The basic differences are: MyISAM types do not support advanced processing such as

Completely uninstall MySQL under Linux detailedFirst, use the following command to view the current installation of MySQL, to find out if previously installed MySQL 1 rpm -qa|grep-i mysql You can see the following as

The login host is not specified by using the-h parameter, and localhost is connected by default, only if the Mysql.user table has a corresponding localhost access authorization ([email protected]% does not restrict any hosts). Otherwise, the login

Char is similar to a varchar type and is used to store strings, but they are "saved" and "retrieved" in different ways. Char is a "fixed-length" string, and varchar is a character type of "variable length."The following table shows the results of

Mysql logbin Data Log Recovery database, mysqllogbin ========================================================== ==================== BINLOG export SQL File========================================================== ==================== C: \ Program