mysql query

This section provides some guidance on how to select a data type to help improve the speed of your query: Do not use long when you can use short columns of data. If you have a fixed-length char data column, do not allow it to be longer than you

This code is modified from Uchome code because it is handled in order to solve the efficiency of uchome. This thinking is actually a long time, but has not been to do, I believe that some people have the same idea, if there is a similar, that really

mysql Download and installation 1, download the introduction MySQL believe that you must have heard, if you do not know what it is, you can go to Google. MySQL's base camp: http://www.mysql.com/MySQL Download address: http://dev.mysql.com/downloads/

From the application examples of most systems, query operation occupies the most proportion in various database operations, and the SELECT statement based on query operation is the most expensive statement in SQL statement. For example, if the

The maintenance table has three main purposes: 1, find and repair the damaged table. For MyISAM storage engines, table corruption is usually caused by a system crash. Other engines can also cause damage to the index due to hardware problems, MySQL'