How to view the table structure in mysql?

How to view the table structure in mysql? The following article will introduce to you the commonly used methods to view the mysql table structure. I hope it will be helpful to you.

Mysql method to view the table structure:

1. Use the desc command

Syntax:

desc 表名;

Example: Take the view of student (sid,sname,birthday,sex) as an example

Use the following command to view the table structure:

desc student;

2. Use the describe command

Syntax:

describe 表名;

3. Use the show command

The show command can be used in many ways to view the table structure:

Syntax 1:

show columns from 表名;

Syntax 2:

show create table 表名;

Example:

show create table student;

Grammar 3:

show full fields from 表名;

Example:

show full fields from student;

show fields from 表名;

show fields from student;

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