MySQL

1. Use Substring_index (Src,target,index) to find the index target from the beginning of SRC. The returned substring is the string from the beginning of the SRC to the num target. Likesubstring_index (' ABSSCDESSFSS ', ' SS ', 1) return

Reference Document: Http://dev.mysql.com/doc/refman/5.6/en/linux-installation-yum-repo.html1. Download the rpm file:wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm2. Installing the RPM filesudo yum localinstall

Important Configuration parameters --prefix # Set the installation path, the default is:/usr/local/; --datadir # Set the data file storage path; --with-charset # Sets the default character set; --with-collation # system default check

There was a conflict with the package mysql-libs-5.1.73-3.el6_5.x86_64 when installing MySQL on red Hat Enterprise Linux6.6 [[email protected] tmp] # RPM-IVH mysql-server-advanced-5.6.20-1.rhel5.x86_64.rpm ###########################################

MySQL 5.6 (XP)/5.7 (Win7) adds the user and sets the local area access operation. Please download MySQL Control Center (not the installation version) in http://sourceforge.net/.1 UseMySQL;2 3 Select * from User;4 5 Update User

Indexing is the key to fast searching. MySQL indexing is important for the efficient operation of MySQL. Here are a few common types of MySQL indexes.In a database table, indexing a field can greatly improve query speed. Suppose we create a mytable

Tag: Error ' table ' t ' already exists ' on query. Defaul T database: ' Test '. Query: ' CREATE TABLE t (T1 int primary key) 'The problem is as follows:Mysql> Show Slave status \g1. Row ***************************Slave_io_state:master_host:172.168.3

MySQL provides synchronous backup of database, can help us to realize database redundancy, backup/restore, load balancing, etc.Specific operation1 The hardware environment of the synchronous database is best consistent with the primary database, the

CentOS Source Installation MySQLThe installation is selected from the Source code platformDownload version mysql-5.6.23.tar.gzThis version has to be compiled by itself, so it's best.Install the tools and libraries needed to compile the source

1. Do not use SELECT * FROM table XXX.You need to query which columns are indicated in the statement, a table structure is complex, there may be hundreds of columns, using * To query can cause a lot of waste.2. Select the appropriate property and

Today I turn to the stored procedure of the data in the batch Update table, so I'll make a record here.At that time, the table name in MySQL has the following characteristics, that is, according to the requirements of the Business table type is

Take notes on Linux (5)-Mysql application, linux-mysqlCheck whether mysql is installed: # Rpm-qa mysql;If the installation has been completed, delete the command: # Rpm-e -- nodeps mysql (-- nodeps is forcibly deleted) Also, use the command

How to add a mysql path to an environment variable 1. Open the terminal and enter: cd ~ Will enter ~ Folder 2. Enter touch. bash_profile. After you press enter to execute, 2. Enter open-e. bash_profile. This file will be opened in TextEdit (if

How to implement two-way replication in MySQL Introduction I know there are many articles and guides to implement master-slave replication on the Internet. In master-slave replication, the host affects the slave. However, any changes from the

MySql database learning-stored procedure (1), mysql Stored Procedure In MySQL 5, we finally introduced the new feature of stored procedures, which will greatly enhance the MYSQL database processing capability. This article will guide you to quickly

View and set connections in mysqlView and set the number of database connections in mysql. Use the following syntax to view the number of other connections to the current database.Show global status like 'max _ used_connections ';The following

Mysql Master never synchronizes processing-database Initialization Learn from online content for troubleshooting Re-master, full synchronization After creating a new table in the master database, the data in the slave segment is not

Setup and startup of MySQLWindowsZIP without Installation MySQL Windows ZIP is free of installation, and the setup and startup process is actually quite troublesome. The following describes the procedure: 1. Download Windows (x86, 64-bit), ZIP

Mysql indexing skills Index is the key to quick search. The establishment of MySQL indexes is very important for the efficient operation of MySQL. The following describes several common MySQL index types. Index fields in database tables can greatly

MySQL: [Err] 1093, mysqlerr1093 The error means that some values in the same table cannot be selected before the table is updated (in the same statement ). For example, the following SQL statement: Delete from tbl where id in(Select max (id) from