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

Source: Internet
Author: User
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:

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.