MySQL

If you need reprint, please specify the source http://blog.csdn.net/slimboy123/archive/2009/07/30/4394782.aspxToday, my colleague, when using MySQL, needs to intercept the specified content in a string.such as the existing string

Configure iptables, allowing him to allow 3306 of access Add the following script ... The problem disappears (execute the following statement directly in the command line interface): Iptables-i INPUT -P TCP--DPort 3306-j ACCEPT; //access to the

1, copy of the introductionMySQL supports one-way, asynchronous replication, during which one server acts as the primary server, and one or more other servers act as slave servers. The primary server writes the update to the binary log file and

11 Steps to choose the most stable version of MySQL Source:CSDNNetworkPosted in:2012-07-18 08:36Click: MySQL open source database has several important branches, currently has the following branches: MySQL Cluster, MySQL 5.1, MySQL 5.5, MySQL 6.2.

Personal Original: http://www.phpthinking.com/archives/365First, clear the MySQL table dataDelete from table name;TRUNCATE TABLE name;The DELETE statement without the Where parameter removes everything from the MySQL table, and you can also empty

Reprint: http://blog.longwin.com.tw/2008/07/mysql_set_master_slave_replication_fase_online_2008/Already online MySQL Master, hope to be in the shortest possible time to do mysqldump, and then immediately let him restore on-line, so the main is to

Installation methodGo to download page: Http://www.navicat.com.cn/download/navicat-for-mysql, select the Linux version to download, download and unzip the installation package, run Start_navicat.1 [email protected]4752: ~$ cd

To determine whether a field exists:1 DROP PROCEDURE IF EXISTSSchema_change; 2DELIMITER//3 CREATE PROCEDURESchema_change ()BEGIN 4 DECLARECurrentDatabaseVARCHAR( -);5 SELECT DATABASE() intocurrentdatabase;6 IF not EXISTS(SELECT *

1. Environmental statementRHEL 6.4 x86_64 + mysql 5.5.37 and MySQL 5.6.19Blog Address: http://blog.csdn.net/hw_libo/article/details/392157232. Case: Redo log file (ib_logfile) size parameter modified: innodb_log_file_sizeInnodb_log_file_size = 256M--

The memory table is the table in memory, the size of the memory used can be specified by the max_heap_table_size in my.cnf, such as max_heap_table_size=1024m, the memory table and the temporary table is not the same, the temporary table is stored in

1. Connection database format: mysql-h host address-u user name-P user password 1.1. Connect to MySQL on this computer. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after you are

1. Turn off the MySQL service2. Start the MySQL service in a privilege free modeNow start the MySQL service without login, can be connected by no password.Use Mysql.exe-hlocalhost-uroot to connect up3. Use the MySQL console to connect to MySQL and

*SQL of databse 1.create databseCreate Database mydb1;Create database mydb2 character set UTF8;Create database mydb3 character Set UTF8 collateCreate database name;Create database name character set code;Create database name character Set code

Query speed optimization for MySQL to improve millions data1. To optimize the query, avoid full-table scanning as far as possible, and first consider establishing an index on the columns involved in the Where and order by.2. You should try to avoid

Error prompting mysql:the server quit without updating PID file when compiling installation MySQL5.6 startupFirst Execute /bin/mysqld_safe--user=mysql &Failed error log prompt Mysqld_safe mysqld from PID file endedContinue initializing MySQL

This article is reproduced from De.cel, "MySQL string connection function CONCAT, Concat_ws,group_concat"In search of MySQL How to implement a column of multiple rows of data merge into a row, found the group_contact function, which is more

1. Start the MySQL serviceThe command to start the MySQL service is: /etc/init.d/mysqld start The command executes after 7-5, indicating that the MySQL service started successfully.

MySQL function learning NOTE 2: character Functions 1. Calculate the number of characters and length of a string-CHAR_LENGTH (s) CHAR_LENGTH (str): Returns the number of characters contained in str. Mysql> select CHAR_LENGTH ('mysql '); + -----------

Use mysqld_multi to configure multiple MySQL Server instances in a single system. This article describes how to use MySQL source code to install MySQL and use mysqld_multi to configure multiple instances. 1. Download the MySQL source code

Detailed description of mysql obtaining the current date function and time formatting parameters, and detailed description of mysql Parameters MYSQL obtains the current date and Date FormatGet system date: NOW ()Format date: DATE_FORMAT (date,