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

How does mysql view tables that have been created? This problem may be our daily study or work often see. I hope you learned something from this question. The following is the reference content brought to you by Xiaobian. Let's take a look together!

mysql View the established data table method: Use SHOW CREATE TABELE to view the data table, SHOW CREATE TABLE statement can not only view the definition statement when creating the table, but also check the character code of the table, the code is [SHOW CREATE TABLE TB_GRADE;]

mysql View the established data table:

View Datasheet with SHOW CREATE TABELE

In MySQL, the SHOW CREATE TABLE statement allows you to view not only the definition statements at the time of table creation, but also the character encoding of the table. The basic syntax for the SHOW CREATE TABLE statement is as follows:

SHOW CREATE TABLE table name;

In the above format,"table name" refers to the name of the data table to be queried. For example, we have previously created a data table named tb-gradede. Use the SHOW CREATE TABLE statement to view the tb_grade table. The SQL statement is as follows:

SHOW CREATE TABLE TB_GRADE;

The results of the run are as follows:

As can be seen from the above execution results, the definition information of tb_grade data table is displayed, but the displayed results are very confusing. At this time, you can add the parameter "\G" after the table name of SHOW CREATE TABLE statement to make the displayed results neat and beautiful. SQL statement is:

SHOW CREATE TABLE TB_GRADE\G

Note that there is no ";" at the end of the code, and the execution results are as follows.

Thank you for reading! After reading the above content, do you have a general understanding of how mysql views the established tables? I hope the content of this article is helpful to everyone. If you want to know more about related articles, please pay attention to 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.