MySQL

From the following aspects:1. Storage structureEach myisam is stored as three files on disk. The first file name begins with the name of the table, and the extension indicates the file type.The. frm file stores the table definition.The data file has

MySQL database Advanced (eight)--event One, Introduction to Events 1, Introduction to EventsAn event is a set of SQL sets that are used to perform timed tasks that are triggered when time is up.An event can be invoked once or periodically, and

First: 30 Ways to optimize SQL statement queries by MySQL1. To optimize the query, avoid full-table scanning as far as possible, and first consider establishing an index on the columns involved in the Where and order by.2. Try to avoid using the! =

The supervisor told me today that there is not enough disk space on the MySQL server, just log in to the server to view:Command: DF-LHaccounted for 99%.was not cached.Enter >mysqlFlush logs; Nothing has changed.Let's see which directory takes up

This is an example of how a cursor is used.But there are a few points to note, which is why to join declare CONTINUE HANDLER for SQLSTATE ' 02000 ' SET tmpname = null;If not added, will be directly error. No Data-zero rows fetched, selected, or

MySQL is installed on the WIN10 and CentOS VMs respectively, but the server with MySQL client connection to the computer CENTOS7 the following error:Workaround:If you can connect to the MySQL server on your computer from a virtual machine, it is

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

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 '

First, IntroductionTurn on the slow query log, you can let the MySQL record query over a specified time of the statement, through the location analysis of performance bottlenecks, to better optimize the performance of the database system.Second,

Toss a half a day finally to install and configure MySQL, the following are the installation steps and problems encountered the solution1. Check if MySQL or its related items are installed on the machine# Yum List Installed | grep MySQLIf installed,

We want to export data from MySQL to Greenplum, follow these steps to1: Export tables from MySQL to external filesTaking Schema_name.table_name as an exampleSelectproduct_id, Number, name, English_name, Purchase_name, System_name, Bar_code, Category_

#!/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

MySQL uninstall is really a headache, many times can not be completely uninstalled, this will cause us to reinstall the new MySQL.The following describes, under the WINDOWS10 system, how to completely remove the uninstall MySQL ...1 "Stop MySQL

MySQL database Advanced (vi)--index One, introduction to the index 1, Introduction to the indexIndex is the data structure that helps MySQL to get data efficiently.In MySQL, indexes belong to the concept of storage engine level, and different

Troubleshoot FAQs1. Inconsistent data:SHOW SLAVE STATUS \G;Last_Errno: 1062Last_Error: Error ‘Duplicate entry ‘xxxn-66-77‘ for key1‘ on query. Default database: ‘guild‘. Query: ‘insert into pynpcrecord setMapCode = ‘xxxn‘, UpdateTime = ‘2015-08-07 00

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

Today, the server in the test, found in the database of Chinese all become question marks!First think of this is the coding problem: So again set the database encoding to UTF8However, the problem persists:It was later discovered that the root of the

There are two common types ofUtf8_general_ci are in normal alphabetical order and are not case sensitive (e.g. a B c D)Utf8_bin in binary order (for example: A in front of a, B D a C)CI is case insensitive, that is, "casing is not sensitive", a and

First, the environmentMAC OS X 10.10Second, download MySQLAddress: HTTP://DEV.MYSQL.COM/GET/DOWNLOADS/MYSQL-5.7/MYSQL-5.7.10-OSX10.10-X86_64.DMGThree, double-click the installation　　　　During installation, it is important to note that the default

Double-click the Mysql-5.5.59-win32.msi to start the installation and the following interface appears 2Click Next, the following interface appears, the default is typical, the re-election is custom, click Next 3After selecting MySQL server,