How to understand the data in the table created by phpmyadmin

The following tutorial column ofphpmyadminwill introduce to you how to understand the data in the table created by phpmyadmin. I hope it will be helpful to friends in need!

phpmyadmin How to understand the data in the created table?

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

②.add part means that if we suddenly find something else we want to add during the process of writing the data table, just choose to add N pieces of data here. After selecting, click the following Execute, and there will be more entries for the added quantity below.

③. Name is the code for the number of entries. It mainly means filling in some entry names we need. Pingzi recommends that you choose some familiar names to facilitate subsequent viewing. It is recommended to use English

④. The type is selected based on the name. For example, if it is a numeric type, choose the int type. If it is a text, choose the VARCHAR type. Of course, there are many other types. You can learn about it in the specific learning process. Pingzi I won’t explain them one by one

⑤. The length/value is ultimately set based on the name. As shown in the figure, we should set the quantity according to the actual situation. Remember, more is not always better, don’t waste space, it’s best to set it appropriately

⑥. Sorting rules, here we generally choose the utf8_bin format, which means to compile each string with binary data Storage will not cause garbled characters or other problems. Of course, if the situation requires, there are still many other options to choose from.

⑦. Index, its purpose is mainly to improve the query speed. For example, if we query a set of mobile phone numbers, but imagine that if we know the first four digits or something, it will be easier than not knowing anything. many. But in fact, it has side effects. While improving the query speed, it will also reduce the speed of MySQL statement insertion and update.

⑧.A_I means auto-increment, so we generally only set the primary key id, which means that during the setting process, it will automatically increase without setting. It should be noted that A_I and index complement each other for the primary key

⑨. Comments are comments on the number of data table entries to prevent us from forgetting the meaning of the entries, which will be displayed above the subsequent data table.

⑩. Table annotation has the same meaning as annotation, in order to annotate the theme of this data table

⑩, (haha, just mean 11 like this, don’t blame me~), its meaning and ordering The specifications are the same

⑩, storage engine, here we choose MyISAM, which is simply the storage method.

MYISAM and INNODB are two storage engines provided by Mysql database. The advantages and disadvantages of both can be said to be different. INNODB will support some advanced functions of relational databases, such as transaction functions 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.

The above is the detailed content of How to understand the data in the table created by phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!