MySQL

Copy to TMP tableWhen you modify the table structure by ALTER TABLERecommendation: Early morning executionCopying to TMP tableCopy data to a temporary table in memory, common in group by operationsRecommendation: Create an indexCopying to TMP table

1. Use the index to traverse the table more quickly.The index established by default is a non-clustered index, but sometimes it is not optimal. Under a non-clustered index, the data is physically randomly stored on the data page. A reasonable index

There are two ways to install MySQL under Mac, one is to go directly to http://dev.mysql.com/downloads/mysql/to download a DMG installation package, and then install it all the way. However, there is a problem, because the Mac file system and Linux

Four date formats:Each time type has a valid value range and a value of "0", and a value of "0" is used when specifying an illegal MySQL value that cannot be represented .　　　　Year 0000 YYYY ' 2015 'Date 0000-00-00 yyyy-mm-dd ' 2015-04-24 'Time 00:00:

In MySQL, there are 4 different logs, namely error log, binary log, query log, and slow query log.Error logThe error log records information about when MySQL starts and stops, and when a critical error occurs during the run of the server.To view the

The following respectively create three tables, and insert 1W simple data for testing, the details are as follows: [1] test_a has a primary key but no index  create TABLE ' test_a ' (  ' id ' int () unsigned not NULL AUT o_increment,  ' title '

1. Index functionIn addition to the ordered lookups mentioned above, the database uses a variety of fast location techniques to greatly improve the query efficiency. In particular, when the amount of data is very large and the query involves more

When the server is installed with the appropriate notes, this method is the first-hand experience of success, as the version is constantly updated, there may be some differences, but the rationale is the same.1. Install CentOS 6, you can choose the

1. Download the MySQL installation file to install MySQL requires the following two files:mysql-server-4.0.16-0.i386.rpmmysql-client-4.0.16-0.i386.rpmTo: http://www.mysql.com/downloads/mysql-4.0.html, open this page, drop-down page find "Linux x86

Ubuntu build MySQL Reference http://www.cnblogs.com/wuhou/archive/2008/09/28/1301071.html1. sudo apt-get install Mysql-server\You need to make the root password password.2. vi/etc/mysql/my.cnfComment out binding-address=127.0.0.13. If you need to

Installing the MySQL module on the Windows platform for Python developmentWhen using Python to connect to MySQL, you need to use the installation version, the source code version is prone to error prompts. The bottom is packaged in 32 and 64

To the next article:Http://www.cnblogs.com/xiaoit/p/4430300.html1: First delete the previous established index and re-establish one.Mysql> DROP INDEX idx1 on Tab_index; Query OK, rows affected (0.01 sec) records:55 duplicates:0 warnings:0　　Mysql>

To the next article:Http://www.cnblogs.com/xiaoit/p/4430387.htmlSometimes a field is created to create an index, but when you look at the execution plan, do you see that the table is completely scanned?You can force a walk down the index to see how

If MySQL was installed before the machine, it is best to uninstall the previous content before reinstalling MySQL, otherwise unforeseen problems may occur./* * * @author Jenkihuang * @email [email protected] * @version 20150402 *//delete existing

The first time you run the program, the Hibernate.hbm2ddl.auto in Hibernte is set to create, allowing hibernate to help automatically build the table, but not successfully, with the following information:You have a error in your SQL syntax; Check

1. TRUNCATE TABLE XXX In the test, I hate the primary key of a table has been growing, always feel the most comfortable starting from 1, ^_^, TRUNCATE table can help me, compared to the delete from, it makes the data table from the growth of the

MySQL Database Security Settings With the popularization of networks, more and more network-based applications are available. Network databases are one of them. One or several servers can provide services to many customers. This method brings many

(13) Process Control in mysqlOverview In mysql, you can use the if/case/loop/leave/iterate/repeat/while statement to control the process. If statement The if statement is similar to the if statement in the advanced language (c/c ++/php/java. if

Character Set in mysqlOverview In essence, a computer only recognizes binary code. Therefore, no matter the computer program or the data it processes, it must eventually be converted into a binary code before the computer can recognize it. People

MySQL control (Off, open) automatic submission function, mysql submit When executing commands in MySQL, it is usually determined that the command is submitted directly. That is to say, the user does not need to be aware of this issue, and all