MySQL

Test database: MySQL DatabaseINSTR (STR,SUBSTR) searches for the specified character (SUBSTR) in a string (STR) and returns the position (INDEX) of the specified character;STR is searched for stringSUBSTR the string you want to searchConclusion: In

MySQL Management tables and indexes创建数据库： CREATE DATABASE|SCHEMA [IF NOT EXISTS] db_name [CHARACTER SET=] [COLLATE=] 删除数据库： DROP {DATABASE | SCHEMA} [IF EXISTS] db_name To create a table:1, directly define an empty table;2, from other

First, MySQL initial passwordThe newly installed MySQL default is no password, set the initial password can use the following life' New-password ' ' password '-s/data/3306/mysql.sock #socket多实例 After setting the initial password, you can

1, query the current time of month and day secondsMysql> Select Now (); +---------------------+| Now () 2018-03-19 23:12:52 |+---------------------+2. Check the time of three hours before the current timeSubdate (now (), Interval 3

Original address: http://blog.csdn.net/github_37767025/article/details/676360611. query a table: SELECT* fromTable name;2. Query the specified field: Select field1Field2Field3.... fromTable name;3.Where Condition query: Select

1 Window System, MySQL data import exception2 analysis reason, mostly the character set is incorrect when importing and exporting3 specifying a specific character set when importing4 Case ListUse mysqldump to back up a database, and when using MySQL

1, edit the/ETC/MY.CNF configuration file with the command, namely: VIM/ETC/MY.CNF or VI/ETC/MY.CNF2. Add skip-grant-tables under [mysqld], then save and exit3. Restart MySQL Services: Service mysqld restart4. After reboot, execute MySQL command to

XtarbackupBrief introduction:Mysqldump Backup method is the use of logical backup, the biggest drawback is that the backup and recovery is slow, for less than 50G of data can be accepted, if the data is very large, you can use open source

##################### mysql5.6 configuration file #############################################[Client]Port= 3306Socket=/tmp/mysql.sockDefault-character-set=utf8[MySQL]Default-character-set=utf8[Mysqld]Port=

Create databases Mysql> Show CREATE Database oldboy\g1. Row ***************************Database:oldboyCreate database:create Database ' Oldboy '/*!40100 DEFAULT CHARACTER SET UTF8 */1 row in Set (0.00 sec)Establish a GBK character set database named

There are two ways to modify a global variable, the first of which is to modify the configuration file, and the second is to set the value of the global variable by the SQL statement. (Refer to: http://www.cnblogs.com/qlqwjy/p/8046592.html)0.

First, the origin of database management softwareBased on what we've learned before, data is stored in a file for permanent preservation, without a doubt that a file can only exist on a single machine.If we ignore the efficiency of accessing data

The concept of GtidGTID (full name global transaction identifier) is the unique identifier for the transaction. The format is as follows:GTID = source_id:transaction_idSOURCE_ID: Identifies the source server, usually the server_uuid of the

In the actual work, sometimes need to perform MySQL database import and import operations, but for large SQL file import, phpMyAdmin is not, there are too many restrictions, such as records, memory, etc.!Export command: A) export the entire

Workaround:1. View the system character Set settings:　　　　　　　　　　Show variables like '%char% ';Here are the coding-related settings that have been solved for the problem!The meaning of each field representation:Open the database my.ini file, note that

Write an SQL statement to find the average of 2 and 2 failed subjects> to have 2 or more 2-door disciplines fail> calculates the average score for all subjects of the examinee, not just the number of failed#创建表:Create Table' ecs_mian2 '

CentOS7 + mysql5.6 configure Master/Slave, centos7mysql5.6 I. installation environment OS: CentOS-7-x86_64-DVD-1611.iso database version: mysql-5.6.39-linux-glibc2.12-x86_64.tar.gz database address: 192.168.2.1 (master) 192.168.2.2 (slave)   The

Mysql Stored Procedure (batch generation of Forum posts, replies, topics, and other data), mysql Stored Procedure USE Database Name 1;Drop procedure if exists database name 1. Stored PROCEDURE name;Delimiter $Create procedure database name 1. Stored

10 SQL statement optimization techniques to improve MYSQL query efficiency, mysqlsql The execution efficiency of the MySQL database has a great impact on the execution speed of the program. It is very useful to effectively process and optimize the

Iscsi linux client, iscsilinux Use of iSCSI Linux clientsIn Linux, you need to install the ISCSI client software iscsi-initiator. The installation process is as follows:Step 0: Install the iSCSI client software through yum or rpm.Step 1: Configure