MySQL database technology (15) [group chart] _ MySQL

MySQL database technology (15) [group chart] 3.5 obtain information about databases and tables

MySQL provides several statements for obtaining database and table information. These statements are helpful for understanding the database content and the structure of your table. They can also be used as an auxiliary means to use a lter table. it is easier to plan how to change the column if you know how the current column is defined. The SHOW statement can be used to obtain information about databases and tables. it has the following usage:

The DESCRIBE tbl_name and EXPLAIN tbl_name statements have the same functions as show columns from tbl_name statements.

The mysqlshow Command provides the same information as the SHOW statement. it allows you to obtain information about databases and tables from the shell: