MySQL

Create userCREATE user ' username ' @ ' localhost ' identified by ' password ';Delete UserDROP user ' username ' @ ' localhost ';Permissions List AllOrAll PrivilegesRepresents all permissions for the specified permission level.ALTERALTER TABLE is

1. Installing the mysql-5.5 Yum sourcerpm -ivh http://repo.mysql.com/yum/mysql-5.5-community/el/6/x86_64/mysql-community-release-el6-5.noarch.rpmTo install MySQL5.6, you can install:rpm -ivh

In the enterprise, a single database will not be able to undertake all read and write operations with a large number of data requests. Workaround: Configure multiple data servers for master-slave replication + read-write separationThe proxy server

1. The console runs the following command for MySQL installation:sudo apt-get install Mysql-serverThe above command installs the following packages: AppArmor mysql-client-5.7 Mysql-common Mysql-server mysql-server-5.7

MySQL Account management Before we logged in to MySQL we were all directly using the root user, the root user belongs to the Super Administrator in the database system, and has the right to do whatever you want to do with MySQL. If you

configuration to be modified after installing MySQL[Mysql]default-character-set=utf8[mysqld]# turn off domain name reverse solution skip_name_resolve# A separate tablespace file per table (recommended) Innodb_file_per _table# Set Data Directory

Creating a database create databases MMP;Creating a database table is not a blank field and requires at least one fieldCREATE TABLE Info (ID TINYINT primarry Key auto_increment,//id is a field-primary key and self-incrementName VARCHAR

This is the "MySQL built-in command quick notes," the sister article, nonsense no longer repeat, directly on dry, with the old iron slowly product1, mysql-hlocalhost-uroot-proot,-h,-u,-p respectively represents Ip,username,password, the commonplace

(Backup restore operation) # # #导出数据库/usr/bin/mysqldump-u root-pwd Database > database20180808.sql## #导入数据库mysql-u root-p Database Extract database20180808.sql.gz### Compressed files from gzip $backupdir/database$time.sql.gz        #        find $

Under Ubuntu 16.04, install MySQL details by entering the following 3 commands, respectively:sudo apt-get install mysql-serversudo apt install mysql-clientsudo apt install libmysqlclient-devAfter the installation is successful, you can test whether

1. GroupingGrouping means dividing a "dataset" into several "small areas" and then processing data for several small regions.2. Characteristics of the Grouping1.) The meaning of GROUP by: Group The results of the query into 1 or more fields with the

1. IF (EXPR1,EXPR2,EXPR3) function:If Expr1 is true, the return value of if () is expr2; Otherwise the return value is EXPR3.The return value of IF () is a numeric value or a string value, depending on the context in which it is located.Cases:2,

A SELECT statement that contains another or more SELECT statements is a subqueryWHERE after:Consider the result of a SELECT query as a condition# Querying and John Doe the same sex peopleSELECT * from students where gender = (SELECT gender from

Mysqldump Principle IntroductionHttp://www.unixfbi.com/475.htmlAbout mysqldump parameters and how to use themHttp://www.unixfbi.com/336.htmlThe principle and practice of Percona Xtrabackup BackupHttp://www.unixfbi.com/349.htmlcopy. mysql Database

MySQL intercepts strings based on characters (summary)1.1 PrefaceIn order to combine their usual search data habits, I will give examples, and then the relevant knowledge to explain. The function used in this case is:substring_index1.2 Actual

Check out the MySQL slow query log today to see a four-table associated SQL operation that takes 1006s of time. This is also based on the idea of sub-query, the above table is optimized. Reduce time complexity to the n^2 level. But after the

Run well on the local, and then publish to the server, always error, and then check the log, get the following error log:[Org.hibernate.engine.jdbc.spi.SqlExceptionHelper] Packet for query is too large (1079 > 1024). You can change this value on the

The 1th chapter of the course IntroductionCourse Introduction1-1 Mycat-Guided studies1-2 Course Introduction2nd Chapter Mycat IntroductionIn this chapter, we will review the basic concepts of vertical slicing, horizontal slicing, and sub-Library

1. Add the jar bundle that connects MySQL to the test planMysql-connector-java-5.1.7-bin.jar2, Thread group Add configuration component-jdbc Connection configInput variable name for created pool input WangSet in database connection ConfiguractionA,

One: Django Configuration connection database:Before you manipulate the database, you first connect to the database. Here we take the example of configuring MySQL to explain. Django connects to the database and does not need to create a separate