MySQL

Install a MySQL to D drive. Then copy the D-disk MySQL folder to another disk. I choose the e-drive here.After you modify the My.ini port number in the root directory[Mysqld]Port= 3307PS: Be sure to separate from the other area.Installation Services

1. Back up all databases mysqldump-uroot-p--all-database >C:\all.sql backing up all databases to the All,sql file under the C drive2. Back up a database mysqldump-uroot-p foo >C:\foo.sql backup only foo database3. Back up a table mysqldump-uroot-p

1.RAID Redundant Array of inexpensive Disks 2. Symbolic links Easy to understand is that through the connector point to the operation, artificial to distribute some databases to other folders/disk Linux: Mysql Data path:/opt/mysql/data

Mysql> show Processlist;Mysql> Show status;Mysql> show status like '% under variable% ';Aborted_clients the number of connections that have been discarded because the client did not properly close the connection already dead. Aborted_connects the

There are two types of solutions available online:The first is that each time a statement is executed, it is similar to PHP, and first executesOne sentence "Set names UTF8" or "Set names gb2312";1 New Mysqlcommand ("set names b2312", m_connection); 2

For example, there is now a data table label, field ID, name, and the character set for this table is gb2312 to Gb2312_chinese_ci.Setting the InnoDB engine's character set is also simplified Chinese, and is organized into GB2312_CHINESE_CI.The query

The mapper file is written as: (fuzzy query, query time period) and sc.com_name like CONCAT (CONCAT ('% ', #{com_name}), '% ') = date_format (#{check_begin_date}, '%Y-%m-% d ')]]>

Learn MySQL, without installing a MySQL database, installation must be very simple, in fact, I downloaded a MySQL5.7, Baidu a bit of installation steps, installed successfully. It's a lot simpler compared to Oracle.Bought two books, read "MySQL must

I like the following query condition shows:I hope the effect of the final displayMerge the group_name with the same ID into one line. Implementation method: Add the keyword group_concat in front of group_name. Then add the group by ID at the end of

PS: A real-world stored procedure caseCREATEDefiner=' Root ' @ ' localhost 'PROCEDURE' Sp_delete_article_by_id ' (inch' ID 'int)BEGIN#Routine body goes here ...DECLARE Temp INT;SET @aid =ID;SELECT COUNT(*) fromGk_reply_articleWHEREa_id= @aid into

SQL Server data import MySQLTools: Navicat for MySQL Baidu search an installation can, if you have installed MySQL1, create the target databaseClick on the Create a good target database website point table One item, on the right side of the Import

1generally, by default, Sql_mode is empty, which is not a strict SQL check.2if the Sql_mode is empty, test:Create TableTT3 (nameChar(2));//define a tt3 table with a name field length of 2Insert intoTt3Values('wo');//normal insertion, flawlessInsert

Installation of 64-bit Apache server under WindowsThe first thing to note is that the APACEH server does not have the official 64-bit version, only the folk master himself produced. The following are the specific installation steps. on the

1. MyISAM with memory support table level lock BDB page level lock 2. Table lock (not cousin) lock table read // read-only table lock, This means that after the lock is executed, the operation in the lock can only be read for the

MySQL default maximum connection number is 100, add the default MySQL connection number method has twoMethod One: Enter the MySQL installation directory to open the MySQL profile my.ini (Windows) or MY.CNF (Linux environment) lookup max_connections=1

After the query data, finally the MySQL master-slave copy is done. This version is mysql5.0. Okay, start talking about the steps.First, the previous article has already said that it is necessary to copy an installation file to another disk. Next,

It is always known that MySQL paging is written like this:select * From ' yourtable ' limit start,rowsNow, I have a table with 9969W data in my database, and it's called Tweet_data.Select COUNT (*) from Tweet_data Execute the first SQL statement,

SelectID= "XXX" >select * from XXXDynamicprepend= "Limit" > isnotequal Property= "num"CompareValue= "0" >0, #num #isnotequal> Dynamic> Select>OrSelectID= "XXX">select * from XXXDynamicprepend= "Limit"> Isnotnull Property=

Modify the default character set in MySQL. When I was working on a program project today, I needed to modify the default Character Set of MySQL. Baidu tried several methods in the blog post and finally succeeded. However, I feel that the blog posts

10. mysql transaction Introduction 1. myisam and memory support table-level locking BDB page-level locking Innodb row-level locking 2. table lock (not a table) lock table read // read-only table lock, that is, after the lock is executed, the