MySQL

How to create a databaseThe first step is to create the database by right-click root node.The second step, fill in the database name, select the default character set and so on after the point OK.How to back up and restore a databaseSteps to back up

Recently released to the market version of the frequent occurrence of database table corruption, the specific phenomenon is that the Select Table hint table does not exist, but to view the data file, the corresponding table of IBD and frm files are

first, mathematical functionsABS (x) returns the absolute value of XBIN (x) returns the binary of X (Oct returns octal, HEX returns hex)CEILING (x) returns the smallest integer value greater than XEXP (x) return value E (base of natural logarithm) x

Introduction to a Substring_index functionrole: intercept strings by keywordSubstring_index (Str,delim,count)Description: Substring_index (the number of occurrences of the intercepted field, keywords, keywords)Example: Select Substring_index ("she

2.7, Mysql master-slave backup1. mysql Main structure:Master:mysql master node, master receives an IO process request from Slave, reads the log information after the specified location of the log is read by the IO process that is responsible for the

1.Table Relationships Note: When you create a table, the length and type of the field are set according to rationality.2. Below: Start your Show 1. Check all personnel information 2. Only the person's name and age are queried 3.

1. Backup Scripts#!/usr/bin/env python#_*_coding:utf-8_*_ "" "@File:  backup_db.py@author: oldtan@email: [ Email protected] @Last  modified: 20180408 "" "import osimport datetimefrom  threading import threadhost =  ' 10.36.1.101 ' user =  ' root '

Introduction to a lamp architectureLamp is Linux apache mysql php abbreviation, is the entire set of server environment, for the PHP development of the site, we access to the page or data is likely to be provided by this set of environment. For

How to download the mysql.tar.gz version of the installation package from the MySQL websiteOriginal October 20, 2016 21:06:41 10854       today to learn to deploy the project on Linux, using MySQL, so want to download the installation

　　The MySQL order can be sorted by the ASC parameter in ascending order, and the DESC parameter is implemented descending.For example:Sort Ascending: SELECT * FROM table name ORDER BY field ASC (MySQL default is ascending order)Sort Descending:

In general, MySQL will provide a variety of storage engines by default, which you can view by:See what storage engine your MySQL has now provided:Mysql> show engines;Look at your MySQL current default storage engine:Mysql> Show variables like

#!/bin/bash# every morning at 4, MySQL backs up data #chmod theBackup.SH#crontab-e#0 4* * * */home/erya/run/moniter/mysql_backup.SHUser="radius"Password=""Host="localhost"db_name="radius"#backup Directory

PXC verification does not pass only two cases Snapshot too long SQL statement execution time is too long, or the undo table space is too small, or the transaction volume is too large, or too frequent commits, resulting in the

Docker MySQL image installation and useDocker MySQL This time uses the download Docker.index.io already has the mirror Orchardup/mysqlReference: https://index.docker.io/u/orchardup/mysql/The steps are as follows:Download image $

View MySQL-supported storage engines: show engines; View the current default storage engine: Show variables like '%storage_engine% '; View the storage engine used by all tables in the Library Show table status from DB _name; View storage engine for

Mu class network of small friends, this time I will bring you how to configure the PHP development environment under the Mac, gossip, start our work!First, start ApacheThere are two ways1. Turn on network sharingOpen "System Preferences", "sharing",

Https://www.cnblogs.com/wangzun/p/6889247.htmlExport DatabaseTo use the command directly:Mysqldump-u root-p ABC >abc.sqlThen enter the password on the return to it;Mysqldump-u Database link user name-p target database > stored file nameThe file is

[Client]Default-character-set = Utf8mb4[MySQL]#开启 Tab Completion#auto-rehashDefault-character-set = Utf8mb4[Mysqld]port=3306basedir=/data/server/mysql57/datadir=/data/server/mysql57/data/Socket=/data/server/mysql57/data/mysql.sockSymbolic-links=0Log-

Show all databases: show databases;Creating database: Create database name; Delete database: Drop databases name;  view table structure: describe (DESC) table name; View table Detail structure: Show create TABLE table name Modify table: 1. Modify

MySql configuration file template and mysql configuration fileThis is the mysql configuration file my. cnf is commonly used in my current environment, including basic configurations and some optimizations. It has been recorded in my notes and I have