Home > Database > Mysql Tutorial > body text

How to view the table creation process in mysql

王林
Release: 2020-10-13 14:30:57
Original
3187 people have browsed it

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;
Copy after login

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;< table_name is the table name>)

desc student;
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template