- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How can I check MySQL tables from a database in accordance with particular column/s name?
The following statement shows the list of two tables having a column ‘email’ in Sample database −
mysql> SELECT DISTINCT TABLE_NAME
-> FROM INFORMATION_SCHEMA.COLUMNS
-> WHERE COLUMN_NAME IN('EMAIL')
-> AND TABLE_SCHEMA = 'SAMPLE';
+---------------+
| TABLE_NAME |
+---------------+
| employee |
| new_student |
+---------------+
2 rows in set (0.04 sec)
Updated on 28-Jan-2020 10:58:20
- Related Questions & Answers
- How Can I check the size of the tables in a particular MySQL database?
- Given a column name how can I find which tables in a MySQL database contain that column?
- How do I select four random tables from a MySQL database having thousands of tables?
- How can I check the tables of databases other than current database?
- How can I check the character set of all the tables along with column names in a particular MySQL database?
- Can I use InnoDB and MyISAM tables in a single database in MySQL?
- Can we create a database with a numeric name with MySQL?
- How can I describe all tables in the database through a single statement in MySQL?
- How can I merge two MySQL tables?
- How can I count unique records from a column in MySQL database?
- While connecting to one MySQL database, how can I see the list of tables of other MySQL database?
- How can we check the character set of all the tables in a particular MySQL database?
- How can I display all databases in MySQL and for each database show all tables?
- How can we analyze the tables of a particular database from MySQL Server command line?
- How to join tables and fetch values from a MySQL database?
Advertisements