What is the sql command to view the table structure?

The sql command to view the table structure is "desc table name". The specific viewing method is: first open the mysql console and enter the password; then enter "use database name" and press the Enter key on the keyboard; Finally, enter "desc table name;" and press the Enter key on the keyboard to view the table structure.

The operating environment of this tutorial: windows7 system, mysql5.6 version, Dell G3 computer.

Open the mysql console and enter the password

After the verification is passed, enter "use database name" and press the Enter key

Enter the "desc table name;" sql statement and press the Enter key

After pressing the Enter key, you can see the table Structure

Related learning recommendations: mysql tutorial(video)

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