MySQL कमांड लाइन से सभी आरक्षित शब्दों की सूची प्राप्त करना

MySQL में सभी आरक्षित शब्दों (रिज़र्व्ड कीवर्ड्स) की सूची प्राप्त करने के लिए mysql.help_keyword सिस्टम टेबल को क्वेरी करें। यह जानकारी टेबल/कॉलम नामकरण संघर्ष से बचने के लिए उपयोगी है।

सिंटैक्स

SELECT * FROM mysql.help_keyword;

उदाहरण आउटपुट

क्वेरी चलाने पर सभी आरक्षित शब्दों की सूची प्रदर्शित होती है (आंशिक सूची):

+----------------+
| name           |
+----------------+
| ACCESSIBLE     |
| ACCOUNT        |
| ACTION         |
| ADD            |
| AFTER          |
| AGAINST        |
| AGGREGATE      |
| ALGORITHM      |
| ALL            |
| ALTER          |
| ANALYZE        |
| AND            |
| ANY            |
| AS             |
| ASC            |
| ASENSITIVE     |
| BEFORE         |
| BETWEEN        |
| BIGINT         |
| BINARY         |
| BLOB           |
| BOTH           |
| BY             |
| CALL           |
| CASCADE        |
| CASE           |
| CHANGE         |
| CHAR           |
| CHARACTER      |
| CHECK          |
| COLLATE        |
| COLUMN         |
| CONDITION      |
| CONSTRAINT     |
| CREATE         |
| CROSS          |
| CURRENT_DATE   |
| CURRENT_TIME   |
| CURRENT_TIMESTAMP |
| CURRENT_USER   |
| CURSOR         |
| DATABASE       |
| DATABASES      |
| DAY_HOUR       |
| DAY_MICROSECOND|
| DAY_MINUTE     |
| DAY_SECOND     |
| DEC            |
| DECIMAL        |
| DECLARE        |
| DEFAULT        |
| DELAYED        |
| DELETE         |
| DESC           |
| DESCRIBE       |
| DETERMINISTIC  |
| DISTINCT       |
| DISTINCTROW    |
| DIV            |
| DOUBLE         |
| DROP           |
| DUAL           |
| EACH           |
| ELSE           |
| ELSEIF         |
| ENCLOSED       |
| END            |
| ENUM           |
| ESCAPED        |
| EXCEPT         |
| EXISTS         |
| EXIT           |
| EXPLAIN        |
| FALSE          |
| FETCH          |
| FLOAT          |
| FLOAT4         |
| FLOAT8         |
| FLUSH          |
| FOR            |
| FORCE          |
| FOREIGN        |
| FROM           |
| FULLTEXT       |
| FUNCTION       |
| GENERAL        |
| GRANT          |
| GROUP          |
| HAVING         |
| HIGH_PRIORITY  |
| HOUR_MICROSECOND|
| HOUR_MINUTE    |
| HOUR_SECOND    |
| IDENTIFIED     |
| IF             |
| IGNORE         |
| INDEX          |
| INFILE         |
| INNER          |
| INOUT          |
| INSENSITIVE    |
| INSERT         |
| INT            |
| INT1           |
| INT2           |
| INT3           |
| INT4           |
| INT8           |
| INTEGER        |
| INTERSECT      |
| INTERVAL       |
| INTO           |
| IS             |
| ITERATE        |
| JOIN           |
| KEY            |
| KEYS           |
| KILL           |
| LEADING        |
| LEAVE          |
| LEFT           |
| LIKE           |
| LIMIT          |
| LINEAR         |
| LINES          |
| LOAD           |
| LOCALTIME      |
| LOCALTIMESTAMP |
| LOCK           |
| LONG           |
| LONGBLOB       |
| LONGTEXT       |
| LOOP           |
| LOW_PRIORITY   |
| MASTER_BIND    |
| MASTER_SSL_VERIFY_SERVER_CERT |
| MATCH          |
| MAXVALUE       |
| MEDIUMBLOB     |
| MEDIUMINT      |
| MEDIUMTEXT     |
| MIDDLEINT      |
| MINUTE_MICROSECOND|
| MINUTE_SECOND  |
| MOD            |
| MODE           |
| MODIFIES       |
| NATURAL        |
| NO_WRITE_TO_BINLOG |
| NOT            |
| NULL           |
| NUMERIC        |
| NVARCHAR       |
| OF             |
| OFFSET         |
| ON             |
| ONLY           |
| OPTIMIZE       |
| OPTION         |
| OPTIONALLY     |
| OR             |
| ORDER          |
| OUT            |
| OUTER          |
| OUTFILE        |
| OVER           |
| OWNER          |
| PACK_KEYS      |
| PAGE           |
| PARSER         |
| PARTIAL        |
| PARTITION      |
| PASSWORD       |
| PHASE          |
| PRECISION      |
| PREPARE        |
| PRESERVE       |
| PRIMARY        |
| PRIVILEGES     |
| PROCEDURE      |
| PROCESS        |
| PROCESSLIST    |
| PURGE          |
| QUICK          |
| RANGE          |
| READ           |
| READS          |
| REAL           |
| RECURSIVE      |
| REFERENCES     |
| REGEXP         |
| RELEASE        |
| RENAME         |
| REPEAT         |
| REPLACE        |
| REQUIRE        |
| RESTRICT       |
| RETURN         |
| REVOKE         |
| RIGHT          |
| ROLLBACK       |
| ROW            |
| ROWS           |
| SCHEMA         |
| SCHEMAS        |
| SECOND_MICROSECOND|
| SELECT         |
| SENSITIVE      |
| SEPARATOR      |
| SET            |
| SHOW           |
| SIGNAL         |
| SMALLINT       |
| SPATIAL        |
| SPECIFIC       |
| SQL            |
| SQLEXCEPTION   |
| SQLSTATE       |
| SQLWARNING     |
| SSL            |
| STARTING       |
| STATISTICS     |
| STORED         |
| STRAIGHT_JOIN  |
| TABLE          |
| TABLES         |
| TABLESPACE     |
| TEMPORARY      |
| TERMINATED     |
| TEXT           |
| THAN           |
| THEN           |
| TINYBLOB       |
| TINYINT        |
| TINYTEXT       |
| TO             |
| TRAILING       |
| TRIGGER        |
| TRUE           |
| TRUNCATE       |
| TYPE           |
| TYPES          |
| UNCOMMITTED    |
| UNDEFINED      |
| UNDO           |
| UNION          |
| UNIQUE         |
| UNLOCK         |
| UNSIGNED       |
| UNTIL          |
| UPDATE         |
| USAGE          |
| USE            |
| USING          |
| UTC_DATE       |
| UTC_TIME       |
| UTC_TIMESTAMP  |
| VALUES         |
| VARBINARY      |
| VARCHAR        |
| VARYING        |
| VIEW           |
| VIRTUAL        |
| WARNINGS       |
| WEEK           |
| WHEN           |
| WHERE          |
| WHILE          |
| WITH           |
| WORK           |
| WRAPPER        |
| WRITE          |
| X509           |
| XOR            |
| YEAR_MONTH     |
| ZEROFILL       |
+----------------+
(सैकड़ों पंक्तियाँ)

फ़िल्टर की गई खोज

-- विशिष्ट शब्द खोजें
SELECT * FROM mysql.help_keyword WHERE name LIKE '%INDEX%';

-- केवल कीवर्ड्स (गैर-कीवर्ड सहायता विषयों को छोड़कर)
SELECT name FROM mysql.help_keyword 
WHERE name NOT IN (SELECT name FROM mysql.help_topic);

व्यावहारिक उपयोग

• टेबल/कॉलम नाम चुनते समय संघर्ष जांचने के लिए
• यदि नाम आरक्षित शब्द है, तो बैकटिक्स का उपयोग करें: \`select\`, \`from\`, \`order\`
• आव्रजन स्क्रिप्ट्स में नाम सत्यापन के लिए

MySQL 8.0+ में कीवर्ड सूची

SELECT * FROM INFORMATION_SCHEMA.KEYWORDS WHERE RESERVED = 1;