MySQL View table structure command

MySQL view table structure SQL statement

=

MySQL view table structure command, as follows:

DESC table name;
Show columns from table name;
describe table name;
Show create table table name;

Use INFORMATION_SCHEMA; #切换到information_schema数据库
SELECT * from columns where table_name= ' table name '; #查看表信息

By the way, MySQL commonly used statements:
show databases;
Use database name;
Show tables;

In addition Oracle several useful statements:

Select *from v$database;
SELECT * from All_users;
SELECT * from User_tables;

MySQL View table structure command