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

Xiaobian to share with you MySQL how to display the statement to create a table, display the table structure and delete the table, I believe most people do not know how to, so share this article for your reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

Show statements that create tables

Grammar:

show create table name

mysql> use bs_ky_blog

Database changed

mysql> show tables;

+----------------------+

| Tables_in_bs_ky_blog

+----------------------+

| bg_category

| bg_post

| bg_user

+----------------------+

3 rows in set (0.00 sec)

mysql> show create table bg_post; Show table structure:

Grammar:

describe table name

mysql> describe bg_post; delete table

Grammar:

drop table [ if exists] Table name 1, Table name 2...

mysql> drop table stu1;

Query OK, 0 rows affected (0.03 sec)

mysql> drop table if exists stu;

Query OK, 0 rows affected (0.01 sec)

The above is "MySQL how to display the statement to create a table, display the table structure and delete the table" all the content of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to 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.