MySQL व्यू की परिभाषा कैसे देखें? SHOW CREATE VIEW

सिंटैक्स:

SHOW CREATE VIEW yourViewName;

टेबल बनाएं

mysql> create table DemoTable (
    -> StudentName VARCHAR(20)
    -> );
Query OK, 0 rows affected (0.56 sec)

रिकॉर्ड्स डालें

mysql> insert into DemoTable values('Chris');
Query OK, 1 row affected (0.14 sec)
mysql> insert into DemoTable values('Robert');
Query OK, 1 row affected (0.18 sec)
mysql> insert into DemoTable values('David');
Query OK, 1 row affected (0.13 sec)

सभी रिकॉर्ड्स देखें

mysql> select * from DemoTable;

+-------------+
| StudentName |
+-------------+
| Chris       |
| Robert      |
| David       |
+-------------+
3 rows in set (0.00 sec)

टेबल के लिए व्यू बनाने का क्वेरी

mysql> CREATE VIEW view_DemoTable AS SELECT StudentName FROM DemoTable;
Query OK, 0 rows affected (0.12 sec)

MySQL व्यू की संरचना देखने का क्वेरी

mysql> SHOW CREATE VIEW view_DemoTable;

आउटपुट:

+-------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
| View              | Create View                                                                                                                               | character_set_client | collation_connection |
+-------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
| view_DemoTable    | CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `view_DemoTable` AS SELECT `DemoTable`.`StudentName` AS `StudentName` FROM `DemoTable` | utf8                 | utf8_general_ci      |
+-------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
1 row in set (0.00 sec)

व्यू रिकॉर्ड्स जांचें

mysql> SELECT * FROM view_DemoTable;

+-------------+
| StudentName |
+-------------+
| Chris       |
| Robert      |
| David       |
+-------------+
3 rows in set (0.05 sec)

मुख्य बिंदु:

• SHOW CREATE VIEW - व्यू परिभाषा SQL दिखाता है
• ALGORITHM=UNDEFINED - मर्ज/टेम्पटेबल एल्गोरिथम
• DEFINER - व्यू बनाने वाला यूज़र
• SQL SECURITY DEFINER - डिफाइनर के विशेषाधिकारों से निष्पादित
• व्यू एक वर्चुअल टेबल है, डेटा संग्रहीत नहीं करता