Mysql Field Types

mysql tutorial to modify the table / field to add / delete table index create table test (blob_col blob, index (blob_col (10))); In mysql 5.1, myisam and innodb table prefix can reach 1000 bytes long. Note that the prefix limit should be measured in bytes, while the prefix length in the create table statement is interpreted as the number of characters. Must be considered when specifying the prefix length for columns that use multi-byte character sets. ...

Intermediary transaction SEO diagnose Taobao guest Cloud host technology Lobby database optimization is a very complex task, because it ultimately requires a good understanding of system optimization. 　　Even though the system or application system does not know much about the optimization effect is good, but if you want to optimize the effect of better, then you need to know more about it. 1, the optimization of the system to run faster the most important factor is the basic design of the database. 　　And you have to be aware of what your system is going to do, and the bottlenecks that exist. The most common system bottlenecks are as follows: ...

First, the importance of the index The index is used to quickly find a column in a particular value of the line. Instead of using an index, MySQL must start with the first record and then read the entire table until it finds the relevant row. The larger the table, the more time it takes. If the table in the query column index, MySQL can quickly reach a location to search the middle of the data file, there is no need to see all the data. Note that if you need to access most of the rows, sequential reads are much faster since we avoid disk searches. If you use Xinhua Dictionary to find "Zhang" the Chinese characters, do not use the directory, then ...

1, use the index to traverse the table faster. The index created by default is a non-clustered index, but sometimes it is not optimal. Under non-clustered indexes, the data is physically stored on the data page. Reasonable index design should be based on the analysis and prediction of various inquiries. In general: a. A large number of duplicate values, and often range query (>, <,> =, <=) and order by, group by occurred column, consider the establishment of cluster index; b. Column, ...

1, use the index to traverse the table faster. The index created by default is a non-clustered index, but sometimes it is not optimal. Under non-clustered indexes, the data is physically stored on the data page. Reasonable index design should be based on the analysis and prediction of various inquiries. In general: a. There are a large number of duplicate values, and often range query (>, <,> =, <=) and order by, group by occurred columns, consider the establishment of cluster index; Column, and each column contains duplicate values ​​can be ...

The database holds one or more tables. Create a Database The CREATE DATABASE statement is used to create a database in MySQL. Syntax CREATE DATABASE database_name In order for PHP to execute the above statement, we must use the mysql_query () function. This function is used to send queries or commands to the MySQL connection. Example In the following example, we create a database named "my_db": ...

This article mainly introduces the practical steps of character (string) in MySQL database. We all know that the character (string) of MySQL database is often used in practice, so you know more about it is still good Hopefully this will bring you some help in this regard. MySQL database character (string) class Do not think that the character type is CHAR CHAR and VARCHAR difference is that CHAR is a fixed length, as long as you define a field is CHAR (10), no matter whether your stored data reached 10 bytes , ...

It is well known that query optimization is an unavoidable topic in any database. For database engineers, optimization is the most challenging job. MySQL Open source database is no exception. In fact, the author believes that the database optimization is not as much as we imagine the suffering. 　　Under normal circumstances, you can start from the following four details to do a good job in the MySQL database query optimization. First, use the Explain keyword to evaluate the flaw in the query statement as shown in the following figure, now the author in the database to execute a simple select ...

Absrtact: Build station use what build station system, often see on the network have child shoes in ask: I want to build a website, ask what CMS system can be used. In fact, there are many CMS network, different types of Web sites, there are different building software. Today, Q Pig Station use what to build the station system, often see the network has children's shoes in the question: I want to build a website, I can use what CMS system. In fact, there are many CMS network, different types of Web sites, there are different building software. Today, Q Pig share is, build station open source CMS system collection, inventory most flow ...

Either in the pitiful free database space or large e-commerce sites, reasonable design table structure, make full use of space is very necessary. This requires that we have a full understanding of the commonly used MySQL data types for database systems. Now I will write down my little experience to share with you. The numeric type of the MySQL data type The numeric type is divided into three categories according to my classification: integer classes, decimal classes, and numeric classes. My so-called "digital class" refers to DECIMAL and NUMERIC, which are the same type. It is strictly speaking not ...