Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to understand the data in the phpmyadmin table. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

How to understand the data in the phpmyadmin table?

1. The name of the data table, although we have set the name in the previous step, we are allowed to change it here.

The ② .add part means that if we suddenly find anything else we want to join in the process of writing the datasheet, just choose to add N pieces of data here, click on the following execution, and the number of entries will be added below.

3. The name is the code name of the number of items, mainly to fill in some item names we need. Pingzi suggests that we take some names that we know by name, which is convenient for follow-up inspection. I suggest you use English.

4. The type is selected according to name. For example, if it is a numeric type, we will choose the int integer type, and if it is a text, we will choose the VARCHAR type. Of course, there are many other types, which you can learn in the process of learning. Pingzi will not explain them one by one.

5. The length / value, in the final analysis, is also set according to name, as shown in the figure, we should set the quantity according to the actual situation. Remember, it's not as much as possible. Don't waste space. You'd better set it up properly.

6. Collation, here we generally choose utf8_bin format, the meaning is to compile and store each string with binary data, will not cause garbled or other situations, of course, if the situation requires, there are still many other options to choose from.

7. The main purpose of indexing is to improve the query speed, for example, we query a set of mobile phone numbers, but imagine that if we know the first four digits or something, it will be much easier to query than nothing. But in fact, it has side effects, which will not only improve the query speed, but also reduce the speed of mysql statement insertion and update.

⑧. A _ I, which means self-increment, so we usually only set the primary key id, which means that it will automatically increase without setting during the setting process. It should be noted that AbeliI and index are complementary to the primary key.

9. Comments, which are comments on the number of items in the data table, prevent us from forgetting the meaning of the items, which will be displayed at the top of the data table later.

10. Table comments, which have the same meaning as comments, in order to annotate the subject of this data table

⑩ +, (, it means 11 in this way, don't blame it, don't blame it), it means the same as the sort specification.

⑩ + +, storage engine. Here we choose MyISAM, which simply means storage.

MYISAM and INNODB are two storage engines provided by the Mysql database. It can be said that each has its own advantages and disadvantages. INNODB supports some advanced features of relational databases, such as transaction capabilities and row-level locks, which MYISAM does not support. MYISAM has better performance and takes up less storage space. Therefore, the choice of storage engine depends on the specific application.

This is the end of the article on "how to understand the data in the phpmyadmin table". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.