MySQL

First, MySQL master-slave backup principleFirst, the concept of dual-machine hot standby simply say, is to maintain the status of two databases automatically synchronized. Operations on any one database are automatically applied to another database,

1. Index:Dictionary to get the directory, easy to find data.Principle: Store column information in its associated files, which are stored in an easy-to-retrieve manner such as B-tree, hashClassification of indexes:Normal all: Name, can only help

in the actual work we often need to format the numbers, such as the 12.0073233 into 12.01 , or put A into 12.00 , or put A into 0000012 , the conversion between this format is summarized as follows:One, floating point conversion--Directly set the

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

Reference Link: https://www.cnblogs.com/jhy-ocean/p/5560857.htmlMySQL timestamp involves a functionDate_format (date, format) function, MySQL date format function date_format ()Unix_timestamp () functionStr_to_date (str, format)

The current online database, divided into the main from two libraries, from the library to do more time-consuming statistical analysis of data.Today top a bit from the library server, found that mysqld for a long time to occupy the 105% CPU, at

PHP three ways to connect to MySQL:1. Native Connection modeNative connection is a process-oriented approachPHP$host= ' localhost ';$database= ' Test ';$username= ' Root ';$password= ' Root ';$selectName= ' Harry ';//the user name to look for,

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

Review common points of knowledge in MySQLBoot off service mode for win version. Connect mysql command: mysql-u alex-p View all databases: show databases;use db_name; switch database show tables;  Show All tables select * from table name; Select

1.connectdef conn(ip,user,password,database): con = mdb.connect(ip,user,password,database) cur = con.cursor() return cur2.selectSELECT ip,env from the hosts ORDER by 1, 2For row in Cur.fetchall ():Print row(' 172.x.x.x ', ' prod ')('

MySQL Installation: at command-line input sudo apt- get install Mysql- server   A window will pop up during installation, enter the password for the database root user ( must enter password )      

Introduction to Essentials1. Introduction2. Integer type3. Floating-point types4. String Type5. Time and date6. Collection type1. IntroductionData types play a fundamental but important role in the database, so the choice of data types will affect

A system databaseINFORMATION_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,

Introduction to Essentials1. Introduction2. Data Files3. log Files1. IntroductionThere are at least two operating system files per MYSQL database: One data file and one log file.Data files contain data and objects, such as tables, indexes, stored

MySQL Log management error logConfiguration method:vim/etc/my.cnf[mysqld]log-error=/tmp/mysql.logTo see how to configure:' %log%error% ';Role:Log the general status of MySQL database and error information, is our database of regular error processing

1. Package PagebeanImport java.util.list;/** * Pagination of JavaBean * @author Administrator */public class Pagebean {//current page private in T Pagecode; Total pages//private int totalpage; Total record number private int totalcount;

Set password for ' root ' @ ' localhost ' =password (' mynewpass4! ');mysql5.7 The password security check plug-in (Validate_password) is installed by default, and the default password-checking policy requires that the password must contain:

Mysql and mysql. sock are installed in linux. Recently, When I installed Aphace, mysql, and php in linux, I encountered many problems. The problems encountered when installing apache and php should be simple. I searched Baidu and google to solve

Basic Mysql user operationsCreate a user: mysql> create user 'cai'@'localhost' identified by '123456';Query OK, 0 rows affected (0.00 sec)mysql> select user,host from mysql.user; +-----------

Mysql storage engine 1. Concept of storage engine The storage engine (the storage engine can also be a table type) is actually how to store data, how to index and update stored data, and how to query data. Data in mysql is stored in files (or