MySQL

1: Download the binary installation package (make sure no MySQL database server is installed): mariadb-10.2.12-linux-x86_64.tar.gz, mariadb-10.2.12.tar.gz.2: Create a System account specify the shell type (default automatically creates a group with

MySQL Chinese garbled processing Locate the My.ini file (default in the C:\ProgramData\MySQL\MySQL Server 5.7 folder); In the My.ini:Search to [client], modify or add Default-character-set=utf8;Search to [mysqld], modify or add

MySQL Data1. Database definition language (data Definition language DDL)A. Alter DATABASEB. Create DatabaseC. Drop databased. ALTER TABLEE. CREATE tableF. drop tableG. Rename tableH. CREATE indexI. DROP Index2. Data manipulation Language (DML)A.

The tests that were previously done on the latency correlation and index coverage were not recorded at the time, resulting in the recollection of forgetting some of the minutiae behind them. Today, take advantage of the impulse to revisit the test

Project Address: HTTPS://GITHUB.COM/EVA911128/EXPRESS4-MICROBLOG/TREE/V1The effect is as follows: Home: Login page: Registration interface: Post-Login Interface: After sending the content interface:

MySQL> select mod (29,9);//Modulo function+-----------+| MoD (29,9) |+-----------+| 2 |+-----------+row in Set (0.00sec)MySQL> select mod (29,2);+-----------+| MoD (29,2) |+-----------+| 1 |+-----------+row in Set (0.00sec)MySQL>

In the database command line only exports the data, does not have around the data structure the time appears secure_file_priv option so it cannot the execute this statement error.Here's how to fix it:1. Create a new directory to/path/to/mysql-files

1, inner connection inner JOINAn inner connection, also known as an equivalent connection, inner join produces a set of data that conforms to both A and B tables.INNER JOIN syntaxSELECT * FROM A inner join B on a.name = B.name;2, natural connection

The scenario is as follows:"Today's front-end suddenly said, I need to make a judgment, can not repeat the collection, I like the neck of the icy shudder, so think what I should do?" Why did she think that I didn't think it was my job?Think of three

1. CONCAT (string1,string2,...)SELECT CONCAT (' L7 's jersey number is ', L7number) from tableIf one of the parameters is null, the result of stitching is null2.concat_ws (SEPARATOR,STR1,STR2,...)Separator represents the delimiter, if the delimiter

Table structure replication (with data)CREATE TABLE New SELECT * FROM oldTable structure replication (without data)CREATE TABLE New SELECT * from old where 1=2This gives a where condition 1=2 is to give the data to an empty tableTable structure

Different versions of MySQL optimizer have a certain difference+ View Database versionSELECT @ @version;+ View the database being usedSelect Database ();+ See if MySQL turns on slow query logShow variables like ' Slow_query_log ';+ turn on MySQL

Xtrabackup backup MySQLMysqldump is based on a logical backup, which is equivalent to re-executing the SQL statement. Xtrabackup is equivalent to a physical backup of a file.Installation dependencieswget ftp://rpmfind.net/linux/dag/redhat/el6/en/x86_

Mysql storage engine and mysql StorageStorage engine Definition The database storage engine is the underlying software organization of the database. The database management system (DBMS) creates, deletes, modifies, and queries data through the

MySQL Chinese garbled characters and mysql garbled characters MySQL Chinese garbled Processing   MySQL viewing code -H indicates the server name, And localhost indicates local; -U indicates the database user name, and root indicates the

MySQL-index details, mysql-Index IndexIs used to quickly retrieve records with specific values. If no index exists, the database must scan the entire table from the first record until relevant rows are identified. The more data you need, the higher

Mysql stored procedure, Create a stored procedure 1. Create a stored procedure without parameters. Delimiter // # The default end mark of mysql is a semicolon, and now it is changed to two slashes. Create procedure pro_student () begin delete

Mysql exercise questions, Table Structure and data: http://www.cnblogs.com/wupeiqi/articles/5748496.html Question:2. query the student ID of all students whose score is higher than that of the "physical" course;1)Select A. student_id, biological

Mysql series learning, mysql Series # HelpHelp create user;# View current userSelect user ();# Create a userCreate user 'egon' @ 'localhost' identified by '2013 ';Create user 'Alex '@' % 'identified by '201312 ';Create user 'ton '@ '192. 192. %'

In linux, configure mysql5.6 to support IPV6 connections. Introduction: This article describes how to configure mysql to support IPV6 connections in linux. Environment requirements: 1. debian7.5 Operating System Virtual Machine 2. MySQL database,