MySQL में उन सभी कॉलम को कैसे ढूंढें जहां कॉलम नाम की लंबाई 5 से अधिक हो?

MySQL में HAVING से लंबे कॉलम नाम वाले कॉलम ढूंढें

कॉलम नाम की लंबाई 5 से अधिक वाले सभी कॉलम ढूंढने के लिए HAVING का उपयोग करें। यह निम्नलिखित आउटपुट देगा:

+-------------------+-------------------------+
| TABLE_NAME        | COLUMN_NAME             |
+-------------------+-------------------------+
| DemoTable         | UserId                  |
| DemoTable         | EndDate                 |
| DemoTable         | StartDate               |
| DemoTable         | StudentFavouriteSubject |
| DemoTable         | StudentFirstName        |
| DemoTable         | StudentId               |
| DemoTable         | ShippingDate            |
| DemoTable         | Number                  |
| DemoTable         | Value1                  |
| DemoTable         | Value2                  |
| DemoTable         | ArrivalDate             |
| DemoTable         | ShippingDate            |
| DemoTable         | UserAge                 |
| DemoTable         | UserId                  |
| DemoTable         | UserName                |
| DemoTable         | CustomerId              |
| DemoTable         | CustomerValue           |
| DemoTable         | UserId                  |
| DemoTable         | UserMailId              |
| DemoTable         | FirstName               |
| DemoTable         | Number                  |
| DemoTable         | isMarried               |
| DemoTable         | Number                  |
| DemoTable         | FruitName               |
| DemoTable         | FruitPrice              |
| DemoTable         | CustomerAllProductPrice |
| DemoTable         | CustomerId              |
| DemoTable         | CustomerName            |
| DemoTable         | UserId                  |
| DemoTable         | UserScore               |
| DemoTable         | StudentAge              |
| DemoTable         | StudentCountryName      |
| DemoTable         | StudentFirstName        |
| DemoTable         | StudentId               |
| DemoTable         | StudentLastName         |
| DemoTable         | FirstName               |
| DemoTable         | Arrivaldatetime         |
| DemoTable         | Amount                  |
| DemoTable         | Number                  |
| DemoTable         | Number                  |
| DemoTable         | FirstName               |
| DemoTable         | CustomerId              |
| DemoTable         | CustomerPrice           |
| DemoTable         | CustomerProductName     |
| DemoTable         | CustomerProductQuantity |
| DemoTable         | Value1                  |
| DemoTable         | Value2                  |
| DemoTable         | FirstName               |
| DemoTable         | LastName                |
| DemoTable         | UserId                  |
| DemoTable         | MonthNumber             |
| DemoTable         | YearNumber              |
| insertcurrentdate | currentDate             |
| student           | first_name              |
| student           | last_name               |
+-------------------+-------------------------+
55 rows in set (0.01 sec)

क्वेरी:

SELECT TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'your_database_name'
HAVING LENGTH(COLUMN_NAME) > 5;

व्याख्या: INFORMATION_SCHEMA.COLUMNS सभी टेबल के कॉलम मेटाडेटा रखता है। HAVING LENGTH(COLUMN_NAME) > 5 उन कॉलम को फ़िल्टर करता है जिनके नाम की लंबाई 5 वर्ण से अधिक है। TABLE_SCHEMA फ़िल्टर अपने डेटाबेस तक सीमित करने के लिए जोड़ें।