Shulou(Shulou.com)06/01 Report--

Editor to share with you what can not be done in the mysql datasheet view, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

What can't be done in Datasheet view?

What cannot be done in Datasheet view is to modify the type of the field.

You can edit, add, delete, delete records and find data in the Datasheet view, but the table structure established by the Datasheet view only describes the field name in the table. however, it does not specify the data type and attribute value of each field, and cannot be modified.

Related introduction:

A view is a virtual table derived from one or more basic tables (or views). Only the definition of the view is stored in the data dictionary of the system, and the corresponding data of the view is not stored.

A view is a transformation of the original database data and another way to view the data in a table. You can think of the view as a moving window through which you can see the data of interest. Views are obtained from one or more actual tables whose data is stored in the database. The tables used to generate the view are called the base tables for that view. One view can also be generated from another view.

The definition of the view is stored in the database, and the data related to this definition is not stored in the database. The data seen through the view is stored in the base table.

The view looks very much like the physical table of the database and operates on it just like any other table. When you modify data through a view, you are actually changing the data in the base table; conversely, changes in the base table data are automatically reflected in the view generated by the base table. For logical reasons, some views can modify the corresponding base table, while others are not (only queried) relevant.

The above is all the contents of what cannot be done in the mysql Datasheet view. Thank you for your reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.