MySQL

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

Wget-i-C http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpmYum-y Install mysql57-community-release-el7-10.noarch.rpmYum-y Install Mysql-community-serverTurn on MySQL serviceSystemctl Start Mysqld.serviceView MySQL Service

1. Modify the table name ALTER TABLE test rename test1;2. Add a row of ALTER TABLE test ADD column name varchar (ten) not null;3. Delete the row ALTER TABLE test drop column name;4 Modifying the column type ALTER TABLE test modify name varchar

Sub-query classificationScalar Quantum query: Query results are single rowColumn query: More than one rowRow subquery: Multi-column single rowTable subquery: Multi-row multi-columnSub-query support rulesSelect scalar Quantum QueryFrom "Join" Table

Today to learn MySQL user management, accidentally the root user in the Mysql.user table is deleted, and then can not log in MySQL, the web found the solution of Linux, I made a simple modification, changed to my Windows edition , The recovery

First, query MySQL database using PHP:1. The steps to access MySQL via PHP are: Connect to MySQL Select the Operational database Create a field for a query The statement that executes the query Retrieve the results and

Modifying a configuration fileShow_query_log = OFF whether to turn on slow log query long_query_time = 2 time limit, over time, record slow_query_log_file =/usr/slow.log log file _queries_not_using_indexs = OFF to open the log for searches that do

This format describes the event that was introduced in Binlog version 4 in order to replace the previous release of the Start_event_3 event. Is the first event of the Binlog file and appears only once in a Binlog file. Specific

The operation and maintenance of MySQL database mainly includes the setting of user rights, backup and recovery of database.I. Granting permissionsGrant permission list on the Library name. Table name to User name @ Source Address {identified by '

The following are excerpts from the Code Audit: Enterprise Web code Security Architecture Book1.floor ()SELECT * FROM Test where id=1 and (select 1 from (SELECT COUNT (*), concat (User (), Floor (rand (0)) × from information_schema . Tables GROUP by

1.1 MySQLmaster-slave replication:Environment Planning : There are DB01 servers in the cluster as the database master server , because of the notebook space problem here the Backup server as Slave server , Don't install new machines , save some

[[email protected] mysql]# service mysql restart Starting MySQL...[ERROR] The server quit without updating PID file (/usr/local/mysql/data/mysqld.pid).See this do not panic, the configuration has just changed the comments out, to see if the

MySQL official definition of index: index is the data structure that helps MySQL to get data efficiently. Indexes are implemented in the storage engine, so the indexes in each of the storage engines are different. such as the MyISAM and InnoDB

Installation Environment: [Email protected] rookie]# lsb_release-aLSB Version:: Core-4.1-amd64:core-4.1-noarchDistributor Id:centosDescription:centos Linux release 7.4.1708 (Core)release:7.4.1708Codename:core Installing

SQL statementsSQL is an abbreviation for Structured query Language (Structured Query language). SQL is a set of operational commands built for the database and is a fully functional database language.SQL specification In a database system,

This Friday before work, found a strange problem, presumably this backgroundA table with a structure ofCreate Table:CREATE TABLE' out_table ' (' ID ')int( One) not NULLauto_increment, ' name 'varchar( -) not NULL, PRIMARY KEY(' id '))

Note: MySQL has been prompted with the following error recentlyPacket for query is too large (1185 > 1024). You can change this value on the server by setting the Max_allowed_packet ' variable....Check Max_allowed_packet on-line requirementsShow

Reference:http://blog.csdn.net/apple9005/article/details/53033148Issue one: When connecting to server MySQL via Navicat under the host, Prompt "2003 Can ' t connect to MySQL server on ' xxx.xxx.xxx.xxx ' (10038)"Cause: Server 3306 remote port is not

18 Common commands in the MySQL command line, mysql Command Line Many SQL statements are used in daily website maintenance and management,Skillful Use has many benefits for website management, especially when managing website groups. Below are some

MySQL can be used to change the ROOT password. Method 1: use the set password command Use the following command on the mysql command line interface: 1 MySQL-u root2 mysql> set password for 'root' @ 'localhost' = PASSWORD ('newpass '); Method 2: