This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › MySQL › MySQL database name, table name, and field name query
View: 12663|Reply: 2

[Source] MySQL database name, table name, and field name query

[Copy link]
Posted on 1/28/2019 5:40:29 PM | | | |
This post was last edited by QWERTYU on 2019-1-28 17:42

1. Query all fields in all tables:


Effect:
  

2. Query all fields in the specified table:
Effect:


3、Query the specified type for all fields in a given table, comment:
Effect:

4、Query all tables that contain this field name:
Effect:

5、Query a table with this field name in the specified database:
Effect:


6、Query all fields of a specified table in the specified table database
Effect:

7、Query the second field name of the specified table in the database specified table:
Effect:







3.png (15.48 KB, Number of downloads: 318)





Previous:C# generic examples are explained in detail
Next:January 29, 2019 (Tuesday) Xie You Morning Post

Related Posts
 Landlord| Posted on 7/20/2020 4:51:54 PM |
SQL serve：
 Landlord| Posted on 7/20/2020 4:52:48 PM |
MySQL：
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com