Home  >  Article  >  Database  >  How to view the table creation process in mysql

How to view the table creation process in mysql

王林
王林Original
2020-10-13 14:30:573132browse

Mysql method to view the table creation process: execute the [show create table table_name;] statement to view. If you want to view the structure of the data table, you can execute the [desc student;] command.

How to view the table creation process in mysql

View the creation process of the table: (show create table table_name;)

(Recommended tutorial:mysql video tutorial)

show create table student;

As shown in the picture:

How to view the table creation process in mysql

##To view the structure of the data table, the command is relatively simple: (desc table_name;)

desc student;

How to view the table creation process in mysql

Related recommendations:

mysql tutorial

The above is the detailed content of How to view the table creation process in mysql. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn