कॉलम नाम दिए जाने पर MySQL डेटाबेस में कौन सी टेबल्स में वह कॉलम है, कैसे पता करें?

डेटाबेस में कौन सी टेबल में विशिष्ट कॉलम है, यह पता करने के लिए COLUMN_NAME का उपयोग करें।

उदाहरण

टेबल बनाएं:

mysql> create table DemoTable (
    -> CustomerId int,
    -> CustomerName varchar(20),
    -> CustomerCountryName varchar(100)
    -> );
Query OK, 0 rows affected (1.05 sec)

विशिष्ट कॉलम "CustomerCountryName" किन टेबल्स में है, यह पता करने की क्वेरी:

mysql> select * from information_schema.columns WHERE COLUMN_NAME = 'CustomerCountryName';

आउटपुट

+---------------+--------------+--------------+---------------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+-----------------+--------------+------------+-------+---------------------------------+----------------+-----------------------+-------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME   | COLUMN_NAME         | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | COLUMN_TYPE | COLUMN_KEY | EXTRA | PRIVILEGES                      | COLUMN_COMMENT | GENERATION_EXPRESSION | SRS_ID |
+---------------+--------------+--------------+---------------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+-----------------+--------------+------------+-------+---------------------------------+----------------+-----------------------+-------+
| def           | sample       | demotable189 | CustomerCountryName | 4                | NULL           | YES         | varchar   | 100                      | 300                    | NULL              | NULL          | NULL               | utf8               | utf8_general_ci | varchar(100) |            |       | select,insert,update,references |                | NULL                  | NULL   |
| def           | web          | DemoTable    | CustomerCountryName | 4                | NULL           | YES         | varchar   | 20                       | 60                     | NULL              | NULL          | NULL               | utf8               | utf8_unicode_ci | varchar(20)  |            |       | select,insert,update,references |                | NULL                  | NULL   |
| def           | web          | DemoTable    | CustomerCountryName | 3                | NULL           | YES         | varchar   | 100                      | 300                    | NULL              | NULL          | NULL               | utf8               | utf8_unicode_ci | varchar(100) |            |       | select,insert,update,references |                | NULL                  | NULL   |
+---------------+--------------+--------------+---------------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+-----------------+--------------+------------+-------+---------------------------------+----------------+-----------------------+-------+
3 rows in set (0.68 sec)

ऊपर "CustomerCountryName" कॉलम 3 टेबल्स में मौजूद है।