MySQL

Commonly used in a total of 4 methods, as follows: 1. Using the Locate () method1.1. General Usage:SELECT ' column ' from ' Table ' where locate (' keyword ', ' condition ') >0Java-like indexOf (), but locate () can only find the returned result is

function functionsFunctions are much more useful, and are generally used after the SELECT query statement and the WHERE condition statement. According to the result returned by the function,Can be divided into: multi-line functions and single-line

Troubleshoot remote connections MySQL error 1130Remotely connect to MySQL server's database, error code is 1130,error 1130:host xxx.xxx.xxx.xxx are not allowed to connect to this MySQL serverConjecture is a problem with user permissions that cannot

#!/bin/bashMysqldump-hip or domain name (default localhost)-u account-p Password Database | gzip >/home/backup/sql/Database _$ (date +%y%m%d_%h%m%s). sql.gzWe're joining the Linux program.Cron DaemonCRONTAB-E//Editing tasksCrontab-l//View

This article compares common MySQL data types with Java data types.Type Comparison Summary: Java type MySQL type Default value Note MyBatis's Jdbctype String varchar Null The usual

First explain the MySQL version:Mysql> select version ();+-----------+| Version () |+-----------+| 5.7.17 |+-----------+1 row in Set (0.00 sec)Table structure:mysql> desc test;+--------+---------------------+------+-----+---------+----------------+|

When installing MySQL:Error phenomena:[[email protected] opt]# rpm-ivh mysql-server-5.5.32-1.el6.x86_64.rpm Preparing ... ################## ######################### [100%]file/usr/share/mysql/charsets/index.xml from Install of mysql-server-5.5.32-1

mysql-Learning -13-20170621-mysql Backup Recovery-xtrabackup-3MariaDB Mysqlbinlog 10.2 Belt"Admin" Wu Bingxi (82565387) 20:35:31Maxscale Proxy: Support semi-synchronousThe two tools under Binlog Server can support Binlog rollback BINLOG

http://mp.weixin.qq.com/s/a8klpzM5iam0_JYSw7-U4gWhen we design the database, whether it will break through the conventional, to find the most suitable for their own needs of the design, the following example:Commonly used adjacency table design,

Find a lot of ways to summarize the following online:Issue with 1.MySQL driver version. This is usually after the MySQL version is updated before the error. Workaround Add "&useoldaliasmetadatabehavior=true" to JDBC2. May be a DateTime format

Common String functions for MySQLOrganize yourself from official documents.1.1     SUBSTR or SUBSTRINGSUBSTR (Str,pos), SUBSTR (str from POS), SUBSTR (Str,pos,len), SUBSTR (str fromPOS for Len)SUBSTR () is a synonym for SUBSTRING ().SUBSTRING

Today's program requires a stored procedure, which is then called with a PHP program.The stored procedure is as follows: Delimiter $ $CREATE PROCEDURE disagree_upgrade_detail (a int,b text) beginset NAMES ' UTF8 '; UPDATE ' upgrade_detail ' SET '

Tag: Cal State stop TCP sys strong min related useraddDescription:Operating system: CentOS 5.6 32-bitprepare the article:First, configure the IP, DNS, gateway, to ensure the use of remote connection tools to connect the server II, configure the

Chapter One, DBA5 minute ExpressThe knowledge points in this chapter are as follows: Look for a statement that runs slow sql: Show full processlist view all executing processes and the execution of the statement time-consuming;

The display width of the integer value is specified in parentheses following the MySQL type keyword (for example, INT (11)). The optional display width specifies that the width is filled from the left when the value that is less than the specified

mysql-Learning -13-20170619-mysql Backup Recovery-xtrabackup-2"Admin" Wu Bingxi (82565387) 20:34:15Based on Xtrabackup, you only need to knowIf you need to add a backup, you can back up Binlog with compressed packaging:Without gzip-you can alsoTo

First, MySQL architectureMySQL is a single-process multithreaded architecture database.Second, the storage engineInnoDB: Support Transactions Row lock Read Operation no lock 4 isolation levels, default to repeatable Adaptive

The regular expression acts as a matching party, comparing a pattern (regular expression) with a text string.MySQL provides preliminary support for regular expressions with a WHERE clause, allowing you to specify that the data retrieved by select is

Suddenly received Zabbix alarm, said MySQL server/directory disk space is insufficient.Log on to the server, looked at the root of the discovery 100GB, incredibly used almost 90GB. This server only ran a MySQL, should not log not clean up and other

Original: http://www.cnblogs.com/xwdreamer/archive/2010/12/15/2297058.htmlInternal connection: The data corresponding to two tables are isolatedOuter joins: Isolate the corresponding data based on a tableFirst create the table in the database with