MySQL

User ManagementTables in the MySQL database are no different from any other relational tables, and can be modified with typical SQL commands to modify their structure and data. You can use the GRANT and REVOKE commands. With these commands, users

Select *,if (sva=1, "male", "female") as Ssva from Taname where sva<> ""12.2. Control process functionsCase value when [compare-value] and then result [when [compare-value] then result ...] [ELSE result] END case [condition] then result [when

In this paper, the MySQL transaction problem of PHP is analyzed. Share to everyone for your reference, as follows:For MyISAM databases, you can control the conduct of transactions: $MYSQLRL = mysql_connect ($db _config ["host"], $db _config

Mysql-uspider_55haitao-pspider_55haitao-dspider_55haitaomethod One executes with the cmd command (under Windows, UNIX or Linux under its console)"MySQL Bin directory" \mysql–u user name –p password –d database

MySQL performance optimization common tools:Common Performance testing toolsShow Engine InnoDB StatusShow Full ProcesslistInformation_schema.processlistExplainCREATE TABLE Innodb_table_monitor (a int) engine=innodb;Innodb_locksInnodb_lock_waitInnodb_

Reprint Https://www.baidu.com/s?ie=UTF-8&wd=cnblogThe original tears Yunshan Hai blog MySQL data type1. Integral type MySQL data type Meaning (Signed) tinyint (m) 1 byte range ( -128~127) smallint (

1. UnzipTAR-XF mysql-5.6.30-linux-glibc2.5-x86_64.tar.gz-c/usr/local/cd/usr/local/&& MV Mysql-5.6.30-linux-glibc2.5-x86_64/mysql2. Configure the Init script after installing Zabbix[[email protected] ~]# cat install_mysql.sh #!/bin/bash# Create user

Because many of the MySQL production environments are under Linux, I decided to point out some important optimizations for Linux running MySQL. This is what everyone knows, and nothing new, but I want to collect and collate Linux-related

First, MySQL JOIN classificationJOIN is broadly divided into three categories as follows:INNER join (inner JOIN): Gets the record that has a connection matching relationship in two tables.Left join: Gets the left table (table1) full record, that is,

First, demand:Because we are a game business, to use MySQL, a server running multiple MySQL instances is also very normal. Adding web monitoring is too time-consuming if you modify agent.conf manually on a single station. So just think about using

Due to testing or learning needs, we often insert more than millions of rows of data into a new data table to verify some of our ideas, such as the rational construction of the index, the Design of table field type, and so on, the following shows

1. Queries with restricted conditionsThe most common is to use the WHERE clause to specify the query criteria to filter the dataChestnut 1: Check the dir_id=4 of all goodsSELECT *From productWHERE dir_id=4;Chestnut 2: Enquiry for all goods with a

Mysqldump commonly used backup options, only the method of backing up data or structure,Common options:--all-databases,-A: Backing Up all databases--databases,-B: For backing up multiple databases, if there is no option, Mysqldump takes the first

The application of MySQL database under Linux has always been a tricky one for me, and this time I built Linux learning environment by studying and learning MySQL database and installing and uninstalling it under Linux.1, first look at unloading it,

Set the character encoding used by the SQL statement: set names UTF8;Determines whether the specified database exists: DROP db if EXISTS library;Start using the specified database: use library;Create database for creating databases;Create data table

Uninstall the old version of MySQL first# See if the MySQL database is already installed on the operating system grep MySQL # execution result: mysql-libs-5.1. 3. el6_5.x86_64# Normal deletion may prompt that a dependent component cannot be

The SQL standard defines four isolation levels, with improper use of different levels of isolation, with dirty reads, non-repeatable reads, and Phantom reads, and the presence of isolation levels is a balance between transaction efficiency and

Bulk Deleteva"-//W3C//DTD XHTML 1.0 transitional//en" "HTTP://WWW.W3.ORG/TR/XHTML1/DTD/XHTML1-TRANSITIONAL.DTD">"http://www.w3.org/1999/xhtml">"Content-type"Content="text/html; Charset=utf-8"/> Untitled document

Basic mysql operation Study Notes (2) ---- index, mysql Study Notes Why create an index? With the same question, I can only explain that the speed required for database query is reduced. If the time difference between a normal query and an index

About binlog (3) (mysql5.7.13), binlogmysql5.7.13 This time we are going to explore more detailed binlog content. The Query_event and Rows_event discussed last time certainly have some confusing questions. What are the status-vars environment