MySQL

Environmental statement:Master-Slave server in 192.168.0.0/24 network segmentmaster-->ip:192.168.0.88master-->ip:192.168.0.89Script master-ip:192.168.0.88 in master---primary database#!/bin/sh# function: this is used for mysql-master role# made by

One:1. StartAfter the MySQL installation is complete, start the file MySQL in the/ETC/INIT.D directory and run the following command when it needs to start./etc/init.d/mysql start2. Stop/usr/bin/mysqladmin-u root-p shutdownTwo: Several important

I was in the virtual machine test, preparing two virtual machines in advance to set the IP to:master:192.168.90.222slave:192.168.90.221Master server ConfigurationFirst modify the master's data configuration file under [mysqld] to add the following

Usage of found_rows ():Example:CREATE produre TEST (in NAME VARCHAR (#), out number) asBEGINIF NAME is NULL OR name== "ThenSELECT * from EMPLOYEES;ELSESELECT * from EMPLOYEES WHERE first_name like NAME;END IF;SELECT found_rows () into number;END;On

A view is a virtual table that does not actually store data and stores a "functional relationship."Grammar:CREATE VIEW name as SELECT statement;Why does a view store a function relationship?When referencing a view, it looks for related fields based

On the internet to find a bit, there are almost no restrictions, but also said that the table is sure to affect the performance, combined should be said:1) The number of tables in a library is limited, according to the UNSIGNED type, up to more than

Today, when I was learning MySQL, I found a problem;I authorized a tiger user with the root user;But the landing time reported 1044 error;I started the authorization when this:GRANT all privileges in root. * to [e-mail protected] identified by ' 1234

as a type of relational database , MySQL arise due to its low memory footprint and open source features . The following is a brief introduction to MySQL configuration and simple operations . mysql configuration 1.download of installation filesFree

reading: MySQL database is a functional not very powerful relational database management system, although the function is not perfect, but MySQL database with speed, adaptability, high reliability advantages to win the favor of the majority of users,

MySQL Authority control system includes 2 aspects:1. Check if the user can connect2. Check if the user has permission to perform the actionMYSQL Privilege Level:1. Global Layer2. Database tier3. Surface level4. Column level5. Sub-Program

1 What is the basic idea of a sub-database table?It is literally a simple way to store data that is stored in a single library on multiple libraries, storing data that was originally stored in a single table on multiple tables.2 Why should the basic

Directly on the codeDaoimpl:/*** Development Transfer page display, query search data, and pagination display* @param ZRDP search criteria Encapsulate Object* @return*/@SuppressWarnings ("Unchecked")Public list Showallzrdpxxpageindex (zrdpxx

Amoeba is a proxy that uses MySQL as the underlying data store and provides the MySQL protocol interface to the application. It responds centrally to the application's requests, sending SQL requests to a specific database based on the rules that the

The Host column specifies the IP that is used to allow the user to log on, such as User=root host=192.168.1.1. This means that the root user can only access it through the 192.168.1.1 client.and% is a wildcard, if host=192.168.1.%, then it means

MySQL Replace usage1.replace intoReplace into table (Id,name) VALUES (' 1 ', ' AA '), (' 2 ', ' BB ')The purpose of this statement is to insert two records into table tables. If the primary key ID is 1 or 2 does not existis equivalent toInsert into

The implementation principle of JoinIn MySQL, there is only one join algorithm, the nested Loop join, and there is no hash join provided by many other databases, and there is no sort Merge join. As the name implies, the Nested loop Join is actually

DELIMITER $$ #改动分隔符为 $ $DROP PROCEDURE IF EXISTS sp_mvccommondatasource$$ #分隔符CREATE PROCEDURE sp_mvccommondatasource (#输入 Number of _fields varchar, #要查询的字段, separated by commas (,) _tables TEXT, #要查询的表_where varchar, #查询条件_orderby varchar, #排序规则_p

MySQL optimization' %innodb_flush_log_at_trx_commit% ' ; +--------------------------------+-------+| Variable_name 1 |+--------------------------------+-------+1inset (0.00 sec)There are three types of default 1 for this value

Common functions: Concat connection function Lower to lowercase upper to uppercase Length substr substring now current time Year current Year... Process functions: If the ifnull (column, result1, result2) field is null, result2 is returned. If

I just installed the LNMP server environment on the company's server yesterday. Here, I will record the process in brief. Here, I used the Dotdeb source during installation for reference only.   1. Import the Dotdeb source. It is said that the