Mysql database learning-1. Get the original data

Show databasesshow tablesinformation_schema> show databases view the create database statement of the given database> show create database db_name> show tables from db_name view the create table statement of the data table of the given database> show create table tbl_name> show columns from tbl_name> show index from tbl_name> describe tbl_name> explain tbl_name> show table status from db_name> show columns from tbl_name like '% s'> show columns from tbl_name like '_ s'> show columns from tbl_name where 'key' = 'pri'

Mysqlshow command

The database managed by the mysqldump command server (if the display is rejected, you must provide the host. the user name and password are as follows. If the host has changed the default port, you must also provide the port uppercase P-P) list the data tables of a given database view the data column information in a given data table view the index information in a given data table view the description information of the data table in a given database list the structure information of the data table in a given database (if without the -- no-data parameter, data in all tables will be listed at the same time)