Translation update done using Pootle.
[phpmyadmin.git] / libraries / sqlparser.data.php
blobcd9a5fc0c070b77b39f3aa7b61532d52d9137b97
1 <?php
2 /* vim: set expandtab sw=4 ts=4 sts=4: */
3 /**
4 * SQL Parser Matching Data
6 * Copyright 2002 Robin Johnson <robbat2@users.sourceforge.net>
7 * http://www.orbis-terrarum.net/?l=people.robbat2
9 * This data is used by the SQL Parser to recognize keywords
11 * It has been extracted from the lex.h file in the MySQL BK tree
12 * (around 4.0.2) as well as the MySQL documentation.
14 * It's easier to use only uppercase for proper sorting. In case of
15 * doubt, use the test case to verify.
17 * @package PhpMyAdmin
19 if (! defined('PHPMYADMIN')) {
20 exit;
23 if (! isset($GLOBALS['sql_delimiter'])) {
24 $GLOBALS['sql_delimiter'] = ';';
27 /**
28 * @global array MySQL function names
30 $PMA_SQPdata_function_name = array (
31 'ABS',
32 'ACOS',
33 'ADDDATE',
34 'ADDTIME',
35 'AES_DECRYPT',
36 'AES_ENCRYPT',
37 'AREA', // Area() polygon-property-functions.html
38 'ASBINARY', // AsBinary()
39 'ASCII',
40 'ASIN',
41 'ASTEXT', // AsText()
42 'ATAN',
43 'ATAN2',
44 'AVG',
45 'BDMPOLYFROMTEXT', // BdMPolyFromText()
46 'BDMPOLYFROMWKB', // BdMPolyFromWKB()
47 'BDPOLYFROMTEXT', // BdPolyFromText()
48 'BDPOLYFROMWKB', // BdPolyFromWKB()
49 'BENCHMARK',
50 'BIN',
51 'BIT_AND',
52 'BIT_COUNT',
53 'BIT_LENGTH',
54 'BIT_OR',
55 'BIT_XOR', // group-by-functions.html
56 'BOUNDARY', // Boundary() general-geometry-property-functions.html
57 'BUFFER', // Buffer()
58 'CAST',
59 'CEIL',
60 'CEILING',
61 'CENTROID', // Centroid() multipolygon-property-functions.html
62 'CHAR', // string-functions.html
63 'CHARACTER_LENGTH',
64 'CHARSET', // information-functions.html
65 'CHAR_LENGTH',
66 'COALESCE',
67 'COERCIBILITY', // information-functions.html
68 'COLLATION', // information-functions.html
69 'COMPRESS', // string-functions.html
70 'CONCAT',
71 'CONCAT_WS',
72 'CONNECTION_ID',
73 'CONTAINS', // Contains()
74 'CONV',
75 'CONVERT',
76 'CONVERT_TZ',
77 'CONVEXHULL', // ConvexHull()
78 'COS',
79 'COT',
80 'COUNT',
81 'CRC32', // mathematical-functions.html
82 'CROSSES', // Crosses()
83 'CURDATE',
84 'CURRENT_DATE',
85 'CURRENT_TIME',
86 'CURRENT_TIMESTAMP',
87 'CURRENT_USER',
88 'CURTIME',
89 'DATABASE',
90 'DATE', // date-and-time-functions.html
91 'DATEDIFF', // date-and-time-functions.html
92 'DATE_ADD',
93 'DATE_DIFF',
94 'DATE_FORMAT',
95 'DATE_SUB',
96 'DAY',
97 'DAYNAME',
98 'DAYOFMONTH',
99 'DAYOFWEEK',
100 'DAYOFYEAR',
101 'DECODE',
102 'DEFAULT', // miscellaneous-functions.html
103 'DEGREES',
104 'DES_DECRYPT',
105 'DES_ENCRYPT',
106 'DIFFERENCE', // Difference()
107 'DIMENSION', // Dimension() general-geometry-property-functions.html
108 'DISJOINT', // Disjoint()
109 'DISTANCE', // Distance()
110 'ELT',
111 'ENCODE',
112 'ENCRYPT',
113 'ENDPOINT', // EndPoint() linestring-property-functions.html
114 'ENVELOPE', // Envelope() general-geometry-property-functions.html
115 'EQUALS', // Equals()
116 'EXP',
117 'EXPORT_SET',
118 'EXTERIORRING', // ExteriorRing() polygon-property-functions.html
119 'EXTRACT',
120 'EXTRACTVALUE', // ExtractValue() xml-functions.html
121 'FIELD',
122 'FIND_IN_SET',
123 'FLOOR',
124 'FORMAT',
125 'FOUND_ROWS',
126 'FROM_DAYS',
127 'FROM_UNIXTIME',
128 'GEOMCOLLFROMTEXT', // GeomCollFromText()
129 'GEOMCOLLFROMWKB', // GeomCollFromWKB()
130 'GEOMETRYCOLLECTION', // GeometryCollection()
131 'GEOMETRYCOLLECTIONFROMTEXT', // GeometryCollectionFromText()
132 'GEOMETRYCOLLECTIONFROMWKB', // GeometryCollectionFromWKB()
133 'GEOMETRYFROMTEXT', // GeometryFromText()
134 'GEOMETRYFROMWKB', // GeometryFromWKB()
135 'GEOMETRYN', // GeometryN() geometrycollection-property-functions.html
136 'GEOMETRYTYPE', // GeometryType() general-geometry-property-functions.html
137 'GEOMFROMTEXT', // GeomFromText()
138 'GEOMFROMWKB', // GeomFromWKB()
139 'GET_FORMAT',
140 'GET_LOCK',
141 'GLENGTH', // GLength() linestring-property-functions.html
142 'GREATEST',
143 'GROUP_CONCAT',
144 'GROUP_UNIQUE_USERS',
145 'HEX',
146 'HOUR',
147 'IF', //control-flow-functions.html
148 'IFNULL',
149 'INET_ATON',
150 'INET_NTOA',
151 'INSERT', // string-functions.html
152 'INSTR',
153 'INTERIORRINGN', // InteriorRingN() polygon-property-functions.html
154 'INTERSECTION', // Intersection()
155 'INTERSECTS', // Intersects()
156 'INTERVAL',
157 'ISCLOSED', // IsClosed() multilinestring-property-functions.html
158 'ISEMPTY', // IsEmpty() general-geometry-property-functions.html
159 'ISNULL',
160 'ISRING', // IsRing() linestring-property-functions.html
161 'ISSIMPLE', // IsSimple() general-geometry-property-functions.html
162 'IS_FREE_LOCK',
163 'IS_USED_LOCK', // miscellaneous-functions.html
164 'LAST_DAY',
165 'LAST_INSERT_ID',
166 'LCASE',
167 'LEAST',
168 'LEFT',
169 'LENGTH',
170 'LINEFROMTEXT', // LineFromText()
171 'LINEFROMWKB', // LineFromWKB()
172 'LINESTRING', // LineString()
173 'LINESTRINGFROMTEXT', // LineStringFromText()
174 'LINESTRINGFROMWKB', // LineStringFromWKB()
175 'LN',
176 'LOAD_FILE',
177 'LOCALTIME',
178 'LOCALTIMESTAMP',
179 'LOCATE',
180 'LOG',
181 'LOG10',
182 'LOG2',
183 'LOWER',
184 'LPAD',
185 'LTRIM',
186 'MAKEDATE',
187 'MAKETIME',
188 'MAKE_SET',
189 'MASTER_POS_WAIT',
190 'MAX',
191 'MBRCONTAINS', // MBRContains()
192 'MBRDISJOINT', // MBRDisjoint()
193 'MBREQUAL', // MBREqual()
194 'MBRINTERSECTS', // MBRIntersects()
195 'MBROVERLAPS', // MBROverlaps()
196 'MBRTOUCHES', // MBRTouches()
197 'MBRWITHIN', // MBRWithin()
198 'MD5',
199 'MICROSECOND',
200 'MID',
201 'MIN',
202 'MINUTE',
203 'MLINEFROMTEXT', // MLineFromText()
204 'MLINEFROMWKB', // MLineFromWKB()
205 'MOD',
206 'MONTH',
207 'MONTHNAME',
208 'MPOINTFROMTEXT', // MPointFromText()
209 'MPOINTFROMWKB', // MPointFromWKB()
210 'MPOLYFROMTEXT', // MPolyFromText()
211 'MPOLYFROMWKB', // MPolyFromWKB()
212 'MULTILINESTRING', // MultiLineString()
213 'MULTILINESTRINGFROMTEXT', // MultiLineStringFromText()
214 'MULTILINESTRINGFROMWKB', // MultiLineStringFromWKB()
215 'MULTIPOINT', // MultiPoint()
216 'MULTIPOINTFROMTEXT', // MultiPointFromText()
217 'MULTIPOINTFROMWKB', // MultiPointFromWKB()
218 'MULTIPOLYGON', // MultiPolygon()
219 'MULTIPOLYGONFROMTEXT', // MultiPolygonFromText()
220 'MULTIPOLYGONFROMWKB', // MultiPolygonFromWKB()
221 'NAME_CONST', // NAME_CONST()
222 'NOW', // NOW()
223 'NULLIF',
224 'NUMGEOMETRIES', // NumGeometries() geometrycollection-property-functions.html
225 'NUMINTERIORRINGS', // NumInteriorRings() polygon-property-functions.html
226 'NUMPOINTS', // NumPoints() linestring-property-functions.html
227 'OCT',
228 'OCTET_LENGTH',
229 'OLD_PASSWORD',
230 'ORD',
231 'OVERLAPS', // Overlaps()
232 'PASSWORD',
233 'PERIOD_ADD',
234 'PERIOD_DIFF',
235 'PI',
236 'POINT', // Point()
237 'POINTFROMTEXT', // PointFromText()
238 'POINTFROMWKB', // PointFromWKB()
239 'POINTN', // PointN() inestring-property-functions.html
240 'POINTONSURFACE', // PointOnSurface() multipolygon-property-functions.html
241 'POLYFROMTEXT', // PolyFromText()
242 'POLYFROMWKB', // PolyFromWKB()
243 'POLYGON', // Polygon()
244 'POLYGONFROMTEXT', // PolygonFromText()
245 'POLYGONFROMWKB', // PolygonFromWKB()
246 'POSITION',
247 'POW',
248 'POWER',
249 'QUARTER',
250 'QUOTE',
251 'RADIANS',
252 'RAND',
253 'RELATED', // Related()
254 'RELEASE_LOCK',
255 'REPEAT',
256 'REPLACE', // string-functions.html
257 'REVERSE',
258 'RIGHT',
259 'ROUND',
260 'ROW_COUNT', // information-functions.html
261 'RPAD',
262 'RTRIM',
263 'SCHEMA', // information-functions.html
264 'SECOND',
265 'SEC_TO_TIME',
266 'SESSION_USER',
267 'SHA',
268 'SHA1',
269 'SIGN',
270 'SIN',
271 'SLEEP', // miscellaneous-functions.html
272 'SOUNDEX',
273 'SPACE',
274 'SQRT',
275 'SRID', // general-geometry-property-functions.html
276 'STARTPOINT', // StartPoint() linestring-property-functions.html
277 'STD',
278 'STDDEV',
279 'STDDEV_POP', // group-by-functions.html
280 'STDDEV_SAMP', // group-by-functions.html
281 'STRCMP',
282 'STR_TO_DATE',
283 'SUBDATE',
284 'SUBSTR',
285 'SUBSTRING',
286 'SUBSTRING_INDEX',
287 'SUBTIME',
288 'SUM',
289 'SYMDIFFERENCE', // SymDifference()
290 'SYSDATE',
291 'SYSTEM_USER',
292 'TAN',
293 'TIME',
294 'TIMEDIFF',
295 'TIMESTAMP',
296 'TIMESTAMPADD',
297 'TIMESTAMPDIFF',
298 'TIME_FORMAT',
299 'TIME_TO_SEC',
300 'TOUCHES', // Touches()
301 'TO_DAYS',
302 'TRIM',
303 'TRUNCATE', // mathematical-functions.html
304 'UCASE',
305 'UNCOMPRESS', // string-functions.html
306 'UNCOMPRESSED_LENGTH', // string-functions.html
307 'UNHEX', // string-functions.html
308 'UNIQUE_USERS',
309 'UNIX_TIMESTAMP',
310 'UPDATEXML', // UpdateXML() xml-functions.html
311 'UPPER',
312 'USER',
313 'UTC_DATE',
314 'UTC_TIME',
315 'UTC_TIMESTAMP',
316 'UUID', // miscellaneous-functions.html
317 'VARIANCE', // group-by-functions.html
318 'VAR_POP', // group-by-functions.html
319 'VAR_SAMP', // group-by-functions.html
320 'VERSION',
321 'WEEK',
322 'WEEKDAY',
323 'WEEKOFYEAR',
324 'WITHIN', // Within()
325 'X', // point-property-functions.html
326 'Y', // point-property-functions.html
327 'YEAR',
328 'YEARWEEK'
332 * @global array MySQL attributes
334 $PMA_SQPdata_column_attrib = array (
335 'ARCHIVE', // Engine
336 'ASCII',
337 'AUTO_INCREMENT',
338 'BDB', // Engine
339 'BERKELEYDB', // Engine alias BDB
340 'BINARY',
341 'BLACKHOLE', // Engine
342 'CSV', // Engine
343 'DEFAULT',
344 'EXAMPLE', // Engine
345 'FEDERATED', // Engine
346 'HEAP', // Engine
347 'INNOBASE', // Engine alias InnoDB
348 'INNODB', // Engine InnoDB
349 'ISAM', // Engine
350 'MARIA', // Engine
351 'MEMORY', // Engine alias HEAP, but preferred
352 'MERGE', // Engine
353 'MRG_ISAM', // Engine
354 'MRG_MYISAM', // Engine alias MERGE
355 'MYISAM', // Engine MyISAM
356 'NATIONAL',
357 'NDB', // Engine alias NDBCLUSTER
358 'NDBCLUSTER', // Engine
359 'PRECISION',
360 'UNDEFINED',
361 'UNICODE',
362 'UNSIGNED',
363 'VARYING',
364 'ZEROFILL'
368 * words that are reserved by MySQL and may not be used as identifiers without quotes
370 * @see http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html
372 * @global array MySQL reserved words
374 $PMA_SQPdata_reserved_word = array (
375 'ACCESSIBLE', // 5.1
376 'ACTION',
377 'ADD',
378 'AFTER',
379 'AGAINST',
380 'AGGREGATE',
381 'ALGORITHM',
382 'ALL',
383 'ALTER',
384 'ANALYSE',
385 'ANALYZE',
386 'AND',
387 'AS',
388 'ASC',
389 'AUTOCOMMIT',
390 'AUTO_INCREMENT',
391 'AVG_ROW_LENGTH',
392 'BACKUP',
393 'BEGIN',
394 'BETWEEN',
395 'BINLOG',
396 'BOTH',
397 'BY',
398 'CASCADE',
399 'CASE',
400 'CHANGE',
401 'CHANGED',
402 'CHARSET',
403 'CHECK',
404 'CHECKSUM',
405 'COLLATE',
406 'COLLATION',
407 'COLUMN',
408 'COLUMNS',
409 'COMMENT',
410 'COMMIT',
411 'COMMITTED',
412 'COMPRESSED',
413 'CONCURRENT',
414 'CONSTRAINT',
415 'CONTAINS',
416 'CONVERT',
417 'CREATE',
418 'CROSS',
419 'CURRENT_TIMESTAMP',
420 'DATABASE',
421 'DATABASES',
422 'DAY',
423 'DAY_HOUR',
424 'DAY_MINUTE',
425 'DAY_SECOND',
426 'DECLARE',
427 'DEFINER',
428 'DELAYED',
429 'DELAY_KEY_WRITE',
430 'DELETE',
431 'DESC',
432 'DESCRIBE',
433 'DETERMINISTIC',
434 'DISTINCT',
435 'DISTINCTROW',
436 'DIV',
437 'DO',
438 'DROP',
439 'DUMPFILE',
440 'DUPLICATE',
441 'DYNAMIC',
442 'ELSE',
443 'ENCLOSED',
444 'END',
445 'ENGINE',
446 'ENGINES',
447 'ESCAPE',
448 'ESCAPED',
449 'EVENTS',
450 'EXECUTE',
451 'EXISTS',
452 'EXPLAIN',
453 'EXTENDED',
454 'FALSE',
455 'FAST',
456 'FIELDS',
457 'FILE',
458 'FIRST',
459 'FIXED',
460 'FLUSH',
461 'FOR',
462 'FORCE',
463 'FOREIGN',
464 'FROM',
465 'FULL',
466 'FULLTEXT',
467 'FUNCTION',
468 'GEMINI',
469 'GEMINI_SPIN_RETRIES',
470 'GENERAL',
471 'GLOBAL',
472 'GRANT',
473 'GRANTS',
474 'GROUP',
475 'HAVING',
476 'HEAP',
477 'HIGH_PRIORITY',
478 'HOSTS',
479 'HOUR',
480 'HOUR_MINUTE',
481 'HOUR_SECOND',
482 'IDENTIFIED',
483 'IF',
484 'IGNORE',
485 'IGNORE_SERVER_IDS',
486 'IN',
487 'INDEX',
488 'INDEXES',
489 'INFILE',
490 'INNER',
491 'INSERT',
492 'INSERT_ID',
493 'INSERT_METHOD',
494 'INTERVAL',
495 'INTO',
496 'INVOKER',
497 'IS',
498 'ISOLATION',
499 'JOIN',
500 'KEY',
501 'KEYS',
502 'KILL',
503 'LAST_INSERT_ID',
504 'LEADING',
505 'LEFT',
506 'LIKE',
507 'LIMIT',
508 'LINEAR', // 5.1
509 'LINES',
510 'LOAD',
511 'LOCAL',
512 'LOCK',
513 'LOCKS',
514 'LOGS',
515 'LOW_PRIORITY',
516 'MARIA', // 5.1 ?
517 'MASTER_CONNECT_RETRY',
518 'MASTER_HEARTBEAT_PERIOD',
519 'MASTER_HOST',
520 'MASTER_LOG_FILE',
521 'MASTER_LOG_POS',
522 'MASTER_PASSWORD',
523 'MASTER_PORT',
524 'MASTER_USER',
525 'MATCH',
526 'MAXVALUE',
527 'MAX_CONNECTIONS_PER_HOUR',
528 'MAX_QUERIES_PER_HOUR',
529 'MAX_ROWS',
530 'MAX_UPDATES_PER_HOUR',
531 'MAX_USER_CONNECTIONS',
532 'MEDIUM',
533 'MERGE',
534 'MINUTE',
535 'MINUTE_SECOND',
536 'MIN_ROWS',
537 'MODE',
538 'MODIFY',
539 'MONTH',
540 'MRG_MYISAM',
541 'MYISAM',
542 'NAMES',
543 'NATURAL',
544 // 'NO' is not allowed in SQL-99 but is allowed in MySQL
545 //'NO',
546 'NOT',
547 'NULL',
548 'OFFSET',
549 'ON',
550 'OPEN',
551 'OPTIMIZE',
552 'OPTION',
553 'OPTIONALLY',
554 'OR',
555 'ORDER',
556 'OUTER',
557 'OUTFILE',
558 'PACK_KEYS',
559 'PAGE', // 5.1-maria ?
560 'PAGE_CHECKSUM', // 5.1
561 'PARTIAL',
562 'PARTITION', // 5.1
563 'PARTITIONS', // 5.1
564 'PASSWORD',
565 'PRIMARY',
566 'PRIVILEGES',
567 'PROCEDURE',
568 'PROCESS',
569 'PROCESSLIST',
570 'PURGE',
571 'QUICK',
572 'RAID0',
573 'RAID_CHUNKS',
574 'RAID_CHUNKSIZE',
575 'RAID_TYPE',
576 'RANGE', // 5.1
577 'READ',
578 'READ_ONLY', // 5.1
579 'READ_WRITE', // 5.1
580 'REFERENCES',
581 'REGEXP',
582 'RELOAD',
583 'RENAME',
584 'REPAIR',
585 'REPEATABLE',
586 'REPLACE',
587 'REPLICATION',
588 'RESET',
589 'RESIGNAL',
590 'RESTORE',
591 'RESTRICT',
592 'RETURN',
593 'RETURNS',
594 'REVOKE',
595 'RIGHT',
596 'RLIKE',
597 'ROLLBACK',
598 'ROW',
599 'ROWS',
600 'ROW_FORMAT',
601 'SECOND',
602 'SECURITY',
603 'SELECT',
604 'SEPARATOR',
605 'SERIALIZABLE',
606 'SESSION',
607 'SHARE',
608 'SHOW',
609 'SHUTDOWN',
610 'SIGNAL',
611 'SLAVE',
612 'SLOW',
613 'SONAME',
614 'SOUNDS', // string-functions.html
615 'SQL',
616 'SQL_AUTO_IS_NULL',
617 'SQL_BIG_RESULT',
618 'SQL_BIG_SELECTS',
619 'SQL_BIG_TABLES',
620 'SQL_BUFFER_RESULT',
621 'SQL_CACHE',
622 'SQL_CALC_FOUND_ROWS',
623 'SQL_LOG_BIN',
624 'SQL_LOG_OFF',
625 'SQL_LOG_UPDATE',
626 'SQL_LOW_PRIORITY_UPDATES',
627 'SQL_MAX_JOIN_SIZE',
628 'SQL_NO_CACHE',
629 'SQL_QUOTE_SHOW_CREATE',
630 'SQL_SAFE_UPDATES',
631 'SQL_SELECT_LIMIT',
632 'SQL_SLAVE_SKIP_COUNTER',
633 'SQL_SMALL_RESULT',
634 'SQL_WARNINGS',
635 'START',
636 'STARTING',
637 'STATUS',
638 'STOP',
639 'STORAGE',
640 'STRAIGHT_JOIN',
641 'STRING',
642 'STRIPED',
643 'SUPER',
644 'TABLE',
645 'TABLES',
646 'TEMPORARY',
647 'TERMINATED',
648 'THEN',
649 'TO',
650 'TRAILING',
651 'TRANSACTIONAL', // 5.1 ?
652 'TRUE',
653 'TRUNCATE',
654 'TYPE',
655 'TYPES',
656 'UNCOMMITTED',
657 'UNION',
658 'UNIQUE',
659 'UNLOCK',
660 'UPDATE',
661 'USAGE',
662 'USE',
663 'USING',
664 'VALUES',
665 'VARIABLES',
666 'VIEW',
667 'WHEN',
668 'WHERE',
669 'WITH',
670 'WORK',
671 'WRITE',
672 'XOR',
673 'YEAR_MONTH'
677 * words forbidden to be used as column or table name wihtout quotes
678 * as seen in http://dev.mysql.com/doc/mysql/en/reserved-words.html
680 * @global array MySQL forbidden words
682 $PMA_SQPdata_forbidden_word = array (
683 'ACCESSIBLE', // 5.1
684 'ACTION',
685 'ADD',
686 'AFTER',
687 'AGAINST',
688 'AGGREGATE',
689 'ALGORITHM',
690 'ALL',
691 'ALTER',
692 'ANALYZE',
693 'AND',
694 'ANY',
695 'AS',
696 'ASC',
697 'ASCII',
698 'ASENSITIVE',
699 'AUTO_INCREMENT',
700 'AVG',
701 'AVG_ROW_LENGTH',
702 'BACKUP',
703 'BDB',
704 'BEFORE',
705 'BEGIN',
706 'BERKELEYDB',
707 'BETWEEN',
708 'BIGINT',
709 'BINARY',
710 'BINLOG',
711 'BIT',
712 'BLOB',
713 'BOOL',
714 'BOOLEAN',
715 'BOTH',
716 'BTREE',
717 'BY',
718 'BYTE',
719 'CACHE',
720 'CALL',
721 'CASCADE',
722 'CASCADED',
723 'CASE',
724 'CHAIN',
725 'CHANGE',
726 'CHANGED',
727 'CHAR',
728 'CHARACTER',
729 'CHARSET',
730 'CHECK',
731 'CHECKSUM',
732 'CIPHER',
733 'CLOSE',
734 'COLLATE',
735 'COLLATION',
736 'COLUMN',
737 'COLUMNS',
738 'COMMENT',
739 'COMMIT',
740 'COMMITTED',
741 'COMPACT',
742 'COMPRESSED',
743 'CONCURRENT',
744 'CONDITION',
745 'CONNECTION',
746 'CONSISTENT',
747 'CONSTRAINT',
748 'CONTAINS',
749 'CONTINUE',
750 'CONVERT',
751 'CREATE',
752 'CROSS',
753 'CUBE',
754 'CURRENT_DATE',
755 'CURRENT_TIME',
756 'CURRENT_TIMESTAMP',
757 'CURRENT_USER',
758 'CURSOR',
759 'DATA',
760 'DATABASE',
761 'DATABASES',
762 'DATE',
763 'DATETIME',
764 'DAY',
765 'DAY_HOUR',
766 'DAY_MICROSECOND',
767 'DAY_MINUTE',
768 'DAY_SECOND',
769 'DEALLOCATE',
770 'DEC',
771 'DECIMAL',
772 'DECLARE',
773 'DEFAULT',
774 'DEFINER',
775 'DELAYED',
776 'DELAY_KEY_WRITE',
777 'DELETE',
778 'DESC',
779 'DESCRIBE',
780 'DES_KEY_FILE',
781 'DETERMINISTIC',
782 'DIRECTORY',
783 'DISABLE',
784 'DISCARD',
785 'DISTINCT',
786 'DISTINCTROW',
787 'DIV',
788 'DO',
789 'DOUBLE',
790 'DROP',
791 'DUAL',
792 'DUMPFILE',
793 'DUPLICATE',
794 'DYNAMIC',
795 'EACH',
796 'ELSE',
797 'ELSEIF',
798 'ENABLE',
799 'ENCLOSED',
800 'END',
801 'ENGINE',
802 'ENGINES',
803 'ENUM',
804 'ERRORS',
805 'ESCAPE',
806 'ESCAPED',
807 'EVENTS',
808 'EXECUTE',
809 'EXISTS',
810 'EXIT',
811 'EXPANSION',
812 'EXPLAIN',
813 'EXTENDED',
814 'FALSE',
815 'FAST',
816 'FETCH',
817 'FIELDS',
818 'FILE',
819 'FIRST',
820 'FIXED',
821 'FLOAT',
822 'FLOAT4',
823 'FLOAT8',
824 'FLUSH',
825 'FOR',
826 'FORCE',
827 'FOREIGN',
828 'FOUND',
829 'FRAC_SECOND',
830 'FROM',
831 'FULL',
832 'FULLTEXT',
833 'FUNCTION',
834 'GEOMETRY',
835 'GEOMETRYCOLLECTION',
836 'GET_FORMAT',
837 'GLOBAL',
838 'GOTO',
839 'GRANT',
840 'GRANTS',
841 'GROUP',
842 'HANDLER',
843 'HASH',
844 'HAVING',
845 'HELP',
846 'HIGH_PRIORITY',
847 'HOSTS',
848 'HOUR',
849 'HOUR_MICROSECOND',
850 'HOUR_MINUTE',
851 'HOUR_SECOND',
852 'IDENTIFIED',
853 'IF',
854 'IGNORE',
855 'IMPORT',
856 'IN',
857 'INDEX',
858 'INDEXES',
859 'INFILE',
860 'INNER',
861 'INNOBASE',
862 'INNODB',
863 'INOUT',
864 'INSENSITIVE',
865 'INSERT',
866 'INSERT_METHOD',
867 'INT',
868 'INT1',
869 'INT2',
870 'INT3',
871 'INT4',
872 'INT8',
873 'INTEGER',
874 'INTERVAL',
875 'INTO',
876 'INVOKER',
877 'IO_THREAD',
878 'IS',
879 'ISOLATION',
880 'ISSUER',
881 'ITERATE',
882 'JOIN',
883 'KEY',
884 'KEYS',
885 'KILL',
886 'LABEL',
887 'LANGUAGE',
888 'LAST',
889 'LEADING',
890 'LEAVE',
891 'LEAVES',
892 'LEFT',
893 'LIKE',
894 'LIMIT',
895 'LINEAR', // 5.1
896 'LINES',
897 'LINESTRING',
898 'LOAD',
899 'LOCAL',
900 'LOCALTIME',
901 'LOCALTIMESTAMP',
902 'LOCK',
903 'LOCKS',
904 'LOGS',
905 'LONG',
906 'LONGBLOB',
907 'LONGTEXT',
908 'LOOP',
909 'LOW_PRIORITY',
910 'MASTER',
911 'MASTER_CONNECT_RETRY',
912 'MASTER_HOST',
913 'MASTER_LOG_FILE',
914 'MASTER_LOG_POS',
915 'MASTER_PASSWORD',
916 'MASTER_PORT',
917 'MASTER_SERVER_ID',
918 'MASTER_SSL',
919 'MASTER_SSL_CA',
920 'MASTER_SSL_CAPATH',
921 'MASTER_SSL_CERT',
922 'MASTER_SSL_CIPHER',
923 'MASTER_SSL_KEY',
924 'MASTER_USER',
925 'MATCH',
926 'MAX_CONNECTIONS_PER_HOUR',
927 'MAX_QUERIES_PER_HOUR',
928 'MAX_ROWS',
929 'MAX_UPDATES_PER_HOUR',
930 'MAX_USER_CONNECTIONS',
931 'MEDIUM',
932 'MEDIUMBLOB',
933 'MEDIUMINT',
934 'MEDIUMTEXT',
935 'MERGE',
936 'MICROSECOND',
937 'MIDDLEINT',
938 'MIGRATE',
939 'MINUTE',
940 'MINUTE_MICROSECOND',
941 'MINUTE_SECOND',
942 'MIN_ROWS',
943 'MOD',
944 'MODE',
945 'MODIFIES',
946 'MODIFY',
947 'MONTH',
948 'MULTILINESTRING',
949 'MULTIPOINT',
950 'MULTIPOLYGON',
951 'MUTEX',
952 'NAME',
953 'NAMES',
954 'NATIONAL',
955 'NATURAL',
956 'NCHAR',
957 'NDB',
958 'NDBCLUSTER',
959 'NEW',
960 'NEXT',
961 'NO',
962 'NONE',
963 'NOT',
964 'NO_WRITE_TO_BINLOG',
965 'NULL',
966 'NUMERIC',
967 'NVARCHAR',
968 'OFFSET',
969 'OLD_PASSWORD',
970 'ON',
971 'ONE',
972 'ONE_SHOT',
973 'OPEN',
974 'OPTIMIZE',
975 'OPTION',
976 'OPTIONALLY',
977 'OR',
978 'ORDER',
979 'OUT',
980 'OUTER',
981 'OUTFILE',
982 'PACK_KEYS',
983 'PARTIAL',
984 'PASSWORD',
985 'PHASE',
986 'POINT',
987 'POLYGON',
988 'PRECISION',
989 'PREPARE',
990 'PREV',
991 'PRIMARY',
992 'PRIVILEGES',
993 'PROCEDURE',
994 'PROCESSLIST',
995 'PURGE',
996 'QUARTER',
997 'QUERY',
998 'QUICK',
999 'RAID0',
1000 'RAID_CHUNKS',
1001 'RAID_CHUNKSIZE',
1002 'RAID_TYPE',
1003 'RANGE', // 5.1
1004 'READ',
1005 'READS',
1006 'READ_ONLY', // 5.1
1007 'READ_WRITE', // 5.1
1008 'REAL',
1009 'RECOVER',
1010 'REDUNDANT',
1011 'REFERENCES',
1012 'REGEXP',
1013 'RELAY_LOG_FILE',
1014 'RELAY_LOG_POS',
1015 'RELAY_THREAD',
1016 'RELEASE',
1017 'RELOAD',
1018 'RENAME',
1019 'REPAIR',
1020 'REPEAT',
1021 'REPEATABLE',
1022 'REPLACE',
1023 'REPLICATION',
1024 'REQUIRE',
1025 'RESET',
1026 'RESTORE',
1027 'RESTRICT',
1028 'RESUME',
1029 'RETURN',
1030 'RETURNS',
1031 'REVOKE',
1032 'RIGHT',
1033 'RLIKE',
1034 'ROLLBACK',
1035 'ROLLUP',
1036 'ROUTINE',
1037 'ROW',
1038 'ROWS',
1039 'ROW_FORMAT',
1040 'RTREE',
1041 'SAVEPOINT',
1042 'SCHEMA',
1043 'SCHEMAS',
1044 'SECOND',
1045 'SECOND_MICROSECOND',
1046 'SECURITY',
1047 'SELECT',
1048 'SENSITIVE',
1049 'SEPARATOR',
1050 'SERIAL',
1051 'SERIALIZABLE',
1052 'SESSION',
1053 'SET',
1054 'SHARE',
1055 'SHOW',
1056 'SHUTDOWN',
1057 'SIGNED',
1058 'SIMPLE',
1059 'SLAVE',
1060 'SMALLINT',
1061 'SNAPSHOT',
1062 'SOME',
1063 'SONAME',
1064 'SOUNDS',
1065 'SPATIAL',
1066 'SPECIFIC',
1067 'SQL',
1068 'SQLEXCEPTION',
1069 'SQLSTATE',
1070 'SQLWARNING',
1071 'SQL_BIG_RESULT',
1072 'SQL_BUFFER_RESULT',
1073 'SQL_CACHE',
1074 'SQL_CALC_FOUND_ROWS',
1075 'SQL_NO_CACHE',
1076 'SQL_SMALL_RESULT',
1077 'SQL_THREAD',
1078 'SQL_TSI_DAY',
1079 'SQL_TSI_FRAC_SECOND',
1080 'SQL_TSI_HOUR',
1081 'SQL_TSI_MINUTE',
1082 'SQL_TSI_MONTH',
1083 'SQL_TSI_QUARTER',
1084 'SQL_TSI_SECOND',
1085 'SQL_TSI_WEEK',
1086 'SQL_TSI_YEAR',
1087 'SSL',
1088 'START',
1089 'STARTING',
1090 'STATUS',
1091 'STOP',
1092 'STORAGE',
1093 'STRAIGHT_JOIN',
1094 'STRING',
1095 'STRIPED',
1096 'SUBJECT',
1097 'SUPER',
1098 'SUSPEND',
1099 'TABLE',
1100 'TABLES',
1101 'TABLESPACE',
1102 'TEMPORARY',
1103 'TEMPTABLE',
1104 'TERMINATED',
1105 'TEXT',
1106 'THEN',
1107 'TIME',
1108 'TIMESTAMP',
1109 'TIMESTAMPADD',
1110 'TIMESTAMPDIFF',
1111 'TINYBLOB',
1112 'TINYINT',
1113 'TINYTEXT',
1114 'TO',
1115 'TRAILING',
1116 'TRANSACTION',
1117 'TRIGGER',
1118 'TRIGGERS',
1119 'TRUE',
1120 'TRUNCATE',
1121 'TYPE',
1122 'TYPES',
1123 'UNCOMMITTED',
1124 'UNDEFINED',
1125 'UNDO',
1126 'UNICODE',
1127 'UNION',
1128 'UNIQUE',
1129 'UNKNOWN',
1130 'UNLOCK',
1131 'UNSIGNED',
1132 'UNTIL',
1133 'UPDATE',
1134 'USAGE',
1135 'USE',
1136 'USER',
1137 'USER_RESOURCES',
1138 'USE_FRM',
1139 'USING',
1140 'UTC_DATE',
1141 'UTC_TIME',
1142 'UTC_TIMESTAMP',
1143 'VALUE',
1144 'VALUES',
1145 'VARBINARY',
1146 'VARCHAR',
1147 'VARCHARACTER',
1148 'VARIABLES',
1149 'VARYING',
1150 'VIEW',
1151 'WARNINGS',
1152 'WEEK',
1153 'WHEN',
1154 'WHERE',
1155 'WHILE',
1156 'WITH',
1157 'WORK',
1158 'WRITE',
1159 'X509',
1160 'XA',
1161 'XOR',
1162 'YEAR',
1163 'YEAR_MONTH',
1164 'ZEROFILL'
1168 * the MySQL column/data types
1170 * @see http://dev.mysql.com/doc/refman/5.1/en/data-types.html
1171 * @see http://dev.mysql.com/doc/refman/5.1/en/mysql-spatial-datatypes.html
1173 * @global array MySQL column types
1175 $PMA_SQPdata_column_type = array (
1176 'BIGINT',
1177 'BINARY',
1178 'BIT',
1179 'BLOB',
1180 'BOOL',
1181 'BOOLEAN', // numeric-type-overview.html
1182 'CHAR',
1183 'CHARACTER',
1184 'DATE',
1185 'DATETIME',
1186 'DEC',
1187 'DECIMAL',
1188 'DOUBLE',
1189 'ENUM',
1190 'FLOAT',
1191 'FLOAT4',
1192 'FLOAT8',
1193 'GEOMETRY', // spatial
1194 'GEOMETRYCOLLECTION', // spatial
1195 'INT',
1196 'INT1',
1197 'INT2',
1198 'INT3',
1199 'INT4',
1200 'INT8',
1201 'INTEGER',
1202 'LINESTRING', // spatial
1203 'LONG',
1204 'LONGBLOB',
1205 'LONGTEXT',
1206 'MEDIUMBLOB',
1207 'MEDIUMINT',
1208 'MEDIUMTEXT',
1209 'MIDDLEINT',
1210 'MULTILINESTRING', // spatial
1211 'MULTIPOINT', // spatial
1212 'MULTIPOLYGON', // spatial
1213 'NCHAR',
1214 'NUMERIC',
1215 'POINT', // spatial
1216 'POLYGON', // spatial
1217 'REAL',
1218 'SERIAL', // alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
1219 'SET',
1220 'SMALLINT',
1221 'TEXT',
1222 'TIME',
1223 'TIMESTAMP',
1224 'TINYBLOB',
1225 'TINYINT',
1226 'TINYTEXT',
1227 'VARBINARY',
1228 'VARCHAR',
1229 'YEAR'
1233 * Documentation links for operators.
1235 $PMA_SQPdata_operators_docs = array(
1236 '!=' => array('link' => 'comparison-operators','anchor' => 'operator_not-equal'),
1237 '<>' => array('link' => 'comparison-operators','anchor' => 'operator_not-equal'),
1238 '!' => array('link' => 'logical-operators','anchor' => 'operator_not'),
1239 '||' => array('link' => 'logical-operators','anchor' => 'operator_or'),
1240 '+' => array('link' => 'arithmetic-functions','anchor' => 'operator_plus'),
1241 '>>' => array('link' => 'bit-functions','anchor' => 'operator_right-shift'),
1242 '-' => array('link' => 'arithmetic-functions','anchor' => 'operator_minus'),
1243 '*' => array('link' => 'arithmetic-functions','anchor' => 'operator_times'),
1244 '&&' => array('link' => 'logical-operators','anchor' => 'operator_and'),
1245 '&' => array('link' => 'bit-functions','anchor' => 'operator_bitwise-and'),
1246 '~' => array('link' => 'bit-functions','anchor' => 'operator_bitwise-invert'),
1247 '|' => array('link' => 'bit-functions','anchor' => 'operator_bitwise-or'),
1248 '^' => array('link' => 'bit-functions','anchor' => 'operator_bitwise-xor'),
1249 '=' => array('link' => 'assignment-operators','anchor' => 'operator_assign-equal'),
1250 ':=' => array('link' => 'assignment-operators','anchor' => 'operator_assign-value'),
1251 '/' => array('link' => 'arithmetic-functions','anchor' => 'operator_divide'),
1252 '<=>' => array('link' => 'comparison-operators','anchor' => 'operator_equal-to'),
1253 '=' => array('link' => 'comparison-operators','anchor' => 'operator_equal'),
1254 '>=' => array('link' => 'comparison-operators','anchor' => 'operator_greater-than-or-equal'),
1255 '>' => array('link' => 'comparison-operators','anchor' => 'operator_greater-than'),
1256 '<<' => array('link' => 'bit-functions','anchor' => 'operator_left-shift'),
1257 '<=' => array('link' => 'comparison-operators','anchor' => 'operator_less-than-or-equal'),
1258 '<' => array('link' => 'comparison-operators','anchor' => 'operator_less-than'),
1259 '%' => array('link' => 'arithmetic-functions','anchor' => 'operator_mod')
1263 * Documentation links for functions.
1265 $PMA_SQPdata_functions_docs = array(
1266 'ABS' => array('link' => 'mathematical-functions','anchor' => 'function_abs'),
1267 'ACOS' => array('link' => 'mathematical-functions','anchor' => 'function_acos'),
1268 'ADDDATE' => array('link' => 'date-and-time-functions','anchor' => 'function_adddate'),
1269 'ADDTIME' => array('link' => 'date-and-time-functions','anchor' => 'function_addtime'),
1270 'AES_DECRYPT' => array('link' => 'encryption-functions','anchor' => 'function_aes_decrypt'),
1271 'AES_ENCRYPT' => array('link' => 'encryption-functions','anchor' => 'function_aes_encrypt'),
1272 'AND' => array('link' => 'logical-operators','anchor' => 'operator_and'),
1273 'ASCII' => array('link' => 'string-functions','anchor' => 'function_ascii'),
1274 'ASIN' => array('link' => 'mathematical-functions','anchor' => 'function_asin'),
1275 'ATAN2' => array('link' => 'mathematical-functions','anchor' => 'function_atan2'),
1276 'ATAN' => array('link' => 'mathematical-functions','anchor' => 'function_atan2'),
1277 'ATAN' => array('link' => 'mathematical-functions','anchor' => 'function_atan'),
1278 'AVG' => array('link' => 'group-by-functions','anchor' => 'function_avg'),
1279 'BENCHMARK' => array('link' => 'information-functions','anchor' => 'function_benchmark'),
1280 'BIN' => array('link' => 'string-functions','anchor' => 'function_bin'),
1281 'BINARY' => array('link' => 'cast-functions','anchor' => 'operator_binary'),
1282 'BIT_AND' => array('link' => 'group-by-functions','anchor' => 'function_bit_and'),
1283 'BIT_COUNT' => array('link' => 'bit-functions','anchor' => 'function_bit_count'),
1284 'BIT_LENGTH' => array('link' => 'string-functions','anchor' => 'function_bit_length'),
1285 'BIT_OR' => array('link' => 'group-by-functions','anchor' => 'function_bit_or'),
1286 'BIT_XOR' => array('link' => 'group-by-functions','anchor' => 'function_bit_xor'),
1287 'CASE' => array('link' => 'control-flow-functions','anchor' => 'operator_case'),
1288 'CAST' => array('link' => 'cast-functions','anchor' => 'function_cast'),
1289 'CEIL' => array('link' => 'mathematical-functions','anchor' => 'function_ceil'),
1290 'CEILING' => array('link' => 'mathematical-functions','anchor' => 'function_ceiling'),
1291 'CHAR_LENGTH' => array('link' => 'string-functions','anchor' => 'function_char_length'),
1292 'CHAR' => array('link' => 'string-functions','anchor' => 'function_char'),
1293 'CHARACTER_LENGTH' => array('link' => 'string-functions','anchor' => 'function_character_length'),
1294 'CHARSET' => array('link' => 'information-functions','anchor' => 'function_charset'),
1295 'COALESCE' => array('link' => 'comparison-operators','anchor' => 'function_coalesce'),
1296 'COERCIBILITY' => array('link' => 'information-functions','anchor' => 'function_coercibility'),
1297 'COLLATION' => array('link' => 'information-functions','anchor' => 'function_collation'),
1298 'COMPRESS' => array('link' => 'encryption-functions','anchor' => 'function_compress'),
1299 'CONCAT_WS' => array('link' => 'string-functions','anchor' => 'function_concat_ws'),
1300 'CONCAT' => array('link' => 'string-functions','anchor' => 'function_concat'),
1301 'CONNECTION_ID' => array('link' => 'information-functions','anchor' => 'function_connection_id'),
1302 'CONV' => array('link' => 'mathematical-functions','anchor' => 'function_conv'),
1303 'CONVERT_TZ' => array('link' => 'date-and-time-functions','anchor' => 'function_convert_tz'),
1304 'Convert' => array('link' => 'cast-functions','anchor' => 'function_convert'),
1305 'COS' => array('link' => 'mathematical-functions','anchor' => 'function_cos'),
1306 'COT' => array('link' => 'mathematical-functions','anchor' => 'function_cot'),
1307 'COUNT' => array('link' => 'group-by-functions','anchor' => 'function_count'),
1308 'CRC32' => array('link' => 'mathematical-functions','anchor' => 'function_crc32'),
1309 'CURDATE' => array('link' => 'date-and-time-functions','anchor' => 'function_curdate'),
1310 'CURRENT_DATE' => array('link' => 'date-and-time-functions','anchor' => 'function_current_date'),
1311 'CURRENT_TIME' => array('link' => 'date-and-time-functions','anchor' => 'function_current_time'),
1312 'CURRENT_TIMESTAMP' => array('link' => 'date-and-time-functions','anchor' => 'function_current_timestamp'),
1313 'CURRENT_USER' => array('link' => 'information-functions','anchor' => 'function_current_user'),
1314 'CURTIME' => array('link' => 'date-and-time-functions','anchor' => 'function_curtime'),
1315 'DATABASE' => array('link' => 'information-functions','anchor' => 'function_database'),
1316 'DATE_ADD' => array('link' => 'date-and-time-functions','anchor' => 'function_date_add'),
1317 'DATE_FORMAT' => array('link' => 'date-and-time-functions','anchor' => 'function_date_format'),
1318 'DATE_SUB' => array('link' => 'date-and-time-functions','anchor' => 'function_date_sub'),
1319 'DATE' => array('link' => 'date-and-time-functions','anchor' => 'function_date'),
1320 'DATEDIFF' => array('link' => 'date-and-time-functions','anchor' => 'function_datediff'),
1321 'DAY' => array('link' => 'date-and-time-functions','anchor' => 'function_day'),
1322 'DAYNAME' => array('link' => 'date-and-time-functions','anchor' => 'function_dayname'),
1323 'DAYOFMONTH' => array('link' => 'date-and-time-functions','anchor' => 'function_dayofmonth'),
1324 'DAYOFWEEK' => array('link' => 'date-and-time-functions','anchor' => 'function_dayofweek'),
1325 'DAYOFYEAR' => array('link' => 'date-and-time-functions','anchor' => 'function_dayofyear'),
1326 'DECLARE' => array('link' => 'declare', 'anchor' => 'declare'),
1327 'DECODE' => array('link' => 'encryption-functions','anchor' => 'function_decode'),
1328 'DEFAULT' => array('link' => 'miscellaneous-functions','anchor' => 'function_default'),
1329 'DEGREES' => array('link' => 'mathematical-functions','anchor' => 'function_degrees'),
1330 'DES_DECRYPT' => array('link' => 'encryption-functions','anchor' => 'function_des_decrypt'),
1331 'DES_ENCRYPT' => array('link' => 'encryption-functions','anchor' => 'function_des_encrypt'),
1332 'DIV' => array('link' => 'arithmetic-functions','anchor' => 'operator_div'),
1333 'ELT' => array('link' => 'string-functions','anchor' => 'function_elt'),
1334 'ENCODE' => array('link' => 'encryption-functions','anchor' => 'function_encode'),
1335 'ENCRYPT' => array('link' => 'encryption-functions','anchor' => 'function_encrypt'),
1336 'EXP' => array('link' => 'mathematical-functions','anchor' => 'function_exp'),
1337 'EXPORT_SET' => array('link' => 'string-functions','anchor' => 'function_export_set'),
1338 'EXTRACT' => array('link' => 'date-and-time-functions','anchor' => 'function_extract'),
1339 'ExtractValue' => array('link' => 'xml-functions','anchor' => 'function_extractvalue'),
1340 'FIELD' => array('link' => 'string-functions','anchor' => 'function_field'),
1341 'FIND_IN_SET' => array('link' => 'string-functions','anchor' => 'function_find_in_set'),
1342 'FLOOR' => array('link' => 'mathematical-functions','anchor' => 'function_floor'),
1343 'FORMAT' => array('link' => 'string-functions','anchor' => 'function_format'),
1344 'FOUND_ROWS' => array('link' => 'information-functions','anchor' => 'function_found_rows'),
1345 'FROM_DAYS' => array('link' => 'date-and-time-functions','anchor' => 'function_from_days'),
1346 'FROM_UNIXTIME' => array('link' => 'date-and-time-functions','anchor' => 'function_from_unixtime'),
1347 'GET_FORMAT' => array('link' => 'date-and-time-functions','anchor' => 'function_get_format'),
1348 'GET_LOCK' => array('link' => 'miscellaneous-functions','anchor' => 'function_get_lock'),
1349 'GREATEST' => array('link' => 'comparison-operators','anchor' => 'function_greatest'),
1350 'GROUP_CONCAT' => array('link' => 'group-by-functions','anchor' => 'function_group_concat'),
1351 'HEX' => array('link' => 'string-functions','anchor' => 'function_hex'),
1352 'HOUR' => array('link' => 'date-and-time-functions','anchor' => 'function_hour'),
1353 'IF' => array('link' => 'control-flow-functions','anchor' => 'function_if'),
1354 'IFNULL' => array('link' => 'control-flow-functions','anchor' => 'function_ifnull'),
1355 'IN' => array('link' => 'comparison-operators','anchor' => 'function_in'),
1356 'INET_ATON' => array('link' => 'miscellaneous-functions','anchor' => 'function_inet_aton'),
1357 'INET_NTOA' => array('link' => 'miscellaneous-functions','anchor' => 'function_inet_ntoa'),
1358 'INSERT' => array('link' => 'string-functions','anchor' => 'function_insert'),
1359 'INSTR' => array('link' => 'string-functions','anchor' => 'function_instr'),
1360 'INTERVAL' => array('link' => 'comparison-operators','anchor' => 'function_interval'),
1361 'IS_FREE_LOCK' => array('link' => 'miscellaneous-functions','anchor' => 'function_is_free_lock'),
1362 'IS_USED_LOCK' => array('link' => 'miscellaneous-functions','anchor' => 'function_is_used_lock'),
1363 'IS' => array('link' => 'comparison-operators','anchor' => 'operator_is'),
1364 'ISNULL' => array('link' => 'comparison-operators','anchor' => 'function_isnull'),
1365 'LAST_DAY' => array('link' => 'date-and-time-functions','anchor' => 'function_last_day'),
1366 'LAST_INSERT_ID' => array('link' => 'information-functions','anchor' => 'function_last_insert_id'),
1367 'LCASE' => array('link' => 'string-functions','anchor' => 'function_lcase'),
1368 'LEAST' => array('link' => 'comparison-operators','anchor' => 'function_least'),
1369 'LEFT' => array('link' => 'string-functions','anchor' => 'function_left'),
1370 'LENGTH' => array('link' => 'string-functions','anchor' => 'function_length'),
1371 'LIKE' => array('link' => 'string-comparison-functions','anchor' => 'operator_like'),
1372 'LN' => array('link' => 'mathematical-functions','anchor' => 'function_ln'),
1373 'LOAD_FILE' => array('link' => 'string-functions','anchor' => 'function_load_file'),
1374 'LOCALTIME' => array('link' => 'date-and-time-functions','anchor' => 'function_localtime'),
1375 'LOCALTIMESTAMP' => array('link' => 'date-and-time-functions','anchor' => 'function_localtimestamp'),
1376 'LOCATE' => array('link' => 'string-functions','anchor' => 'function_locate'),
1377 'LOG10' => array('link' => 'mathematical-functions','anchor' => 'function_log10'),
1378 'LOG2' => array('link' => 'mathematical-functions','anchor' => 'function_log2'),
1379 'LOG' => array('link' => 'mathematical-functions','anchor' => 'function_log'),
1380 'LOWER' => array('link' => 'string-functions','anchor' => 'function_lower'),
1381 'LPAD' => array('link' => 'string-functions','anchor' => 'function_lpad'),
1382 'LTRIM' => array('link' => 'string-functions','anchor' => 'function_ltrim'),
1383 'MAKE_SET' => array('link' => 'string-functions','anchor' => 'function_make_set'),
1384 'MAKEDATE' => array('link' => 'date-and-time-functions','anchor' => 'function_makedate'),
1385 'MAKETIME' => array('link' => 'date-and-time-functions','anchor' => 'function_maketime'),
1386 'MASTER_POS_WAIT' => array('link' => 'miscellaneous-functions','anchor' => 'function_master_pos_wait'),
1387 'MATCH' => array('link' => 'fulltext-search','anchor' => 'function_match'),
1388 'MAX' => array('link' => 'group-by-functions','anchor' => 'function_max'),
1389 'MD5' => array('link' => 'encryption-functions','anchor' => 'function_md5'),
1390 'MICROSECOND' => array('link' => 'date-and-time-functions','anchor' => 'function_microsecond'),
1391 'MID' => array('link' => 'string-functions','anchor' => 'function_mid'),
1392 'MIN' => array('link' => 'group-by-functions','anchor' => 'function_min'),
1393 'MINUTE' => array('link' => 'date-and-time-functions','anchor' => 'function_minute'),
1394 'MOD' => array('link' => 'mathematical-functions','anchor' => 'function_mod'),
1395 'MONTH' => array('link' => 'date-and-time-functions','anchor' => 'function_month'),
1396 'MONTHNAME' => array('link' => 'date-and-time-functions','anchor' => 'function_monthname'),
1397 'NAME_CONST' => array('link' => 'miscellaneous-functions','anchor' => 'function_name_const'),
1398 'NOT' => array('link' => 'logical-operators','anchor' => 'operator_not'),
1399 'NOW' => array('link' => 'date-and-time-functions','anchor' => 'function_now'),
1400 'NULLIF' => array('link' => 'control-flow-functions','anchor' => 'function_nullif'),
1401 'OCT' => array('link' => 'mathematical-functions','anchor' => 'function_oct'),
1402 'OCTET_LENGTH' => array('link' => 'string-functions','anchor' => 'function_octet_length'),
1403 'OLD_PASSWORD' => array('link' => 'encryption-functions','anchor' => 'function_old_password'),
1404 'OR' => array('link' => 'logical-operators','anchor' => 'operator_or'),
1405 'ORD' => array('link' => 'string-functions','anchor' => 'function_ord'),
1406 'PASSWORD' => array('link' => 'encryption-functions','anchor' => 'function_password'),
1407 'PERIOD_ADD' => array('link' => 'date-and-time-functions','anchor' => 'function_period_add'),
1408 'PERIOD_DIFF' => array('link' => 'date-and-time-functions','anchor' => 'function_period_diff'),
1409 'PI' => array('link' => 'mathematical-functions','anchor' => 'function_pi'),
1410 'POSITION' => array('link' => 'string-functions','anchor' => 'function_position'),
1411 'POW' => array('link' => 'mathematical-functions','anchor' => 'function_pow'),
1412 'POWER' => array('link' => 'mathematical-functions','anchor' => 'function_power'),
1413 'QUARTER' => array('link' => 'date-and-time-functions','anchor' => 'function_quarter'),
1414 'QUOTE' => array('link' => 'string-functions','anchor' => 'function_quote'),
1415 'RADIANS' => array('link' => 'mathematical-functions','anchor' => 'function_radians'),
1416 'RAND' => array('link' => 'mathematical-functions','anchor' => 'function_rand'),
1417 'REGEXP' => array('link' => 'regexp','anchor' => 'operator_regexp'),
1418 'RELEASE_LOCK' => array('link' => 'miscellaneous-functions','anchor' => 'function_release_lock'),
1419 'REPEAT' => array('link' => 'string-functions','anchor' => 'function_repeat'),
1420 'REPLACE' => array('link' => 'string-functions','anchor' => 'function_replace'),
1421 'REVERSE' => array('link' => 'string-functions','anchor' => 'function_reverse'),
1422 'RIGHT' => array('link' => 'string-functions','anchor' => 'function_right'),
1423 'RLIKE' => array('link' => 'regexp','anchor' => 'operator_rlike'),
1424 'ROUND' => array('link' => 'mathematical-functions','anchor' => 'function_round'),
1425 'ROW_COUNT' => array('link' => 'information-functions','anchor' => 'function_row_count'),
1426 'RPAD' => array('link' => 'string-functions','anchor' => 'function_rpad'),
1427 'RTRIM' => array('link' => 'string-functions','anchor' => 'function_rtrim'),
1428 'SCHEMA' => array('link' => 'information-functions','anchor' => 'function_schema'),
1429 'SEC_TO_TIME' => array('link' => 'date-and-time-functions','anchor' => 'function_sec_to_time'),
1430 'SECOND' => array('link' => 'date-and-time-functions','anchor' => 'function_second'),
1431 'SESSION_USER' => array('link' => 'information-functions','anchor' => 'function_session_user'),
1432 'SHA' => array('link' => 'encryption-functions','anchor' => 'function_sha1'),
1433 'SHA1' => array('link' => 'encryption-functions','anchor' => 'function_sha1'),
1434 'SIGN' => array('link' => 'mathematical-functions','anchor' => 'function_sign'),
1435 'SIN' => array('link' => 'mathematical-functions','anchor' => 'function_sin'),
1436 'SLEEP' => array('link' => 'miscellaneous-functions','anchor' => 'function_sleep'),
1437 'SOUNDEX' => array('link' => 'string-functions','anchor' => 'function_soundex'),
1438 'SPACE' => array('link' => 'string-functions','anchor' => 'function_space'),
1439 'SQRT' => array('link' => 'mathematical-functions','anchor' => 'function_sqrt'),
1440 'STD' => array('link' => 'group-by-functions','anchor' => 'function_std'),
1441 'STDDEV_POP' => array('link' => 'group-by-functions','anchor' => 'function_stddev_pop'),
1442 'STDDEV_SAMP' => array('link' => 'group-by-functions','anchor' => 'function_stddev_samp'),
1443 'STDDEV' => array('link' => 'group-by-functions','anchor' => 'function_stddev'),
1444 'STR_TO_DATE' => array('link' => 'date-and-time-functions','anchor' => 'function_str_to_date'),
1445 'STRCMP' => array('link' => 'string-comparison-functions','anchor' => 'function_strcmp'),
1446 'SUBDATE' => array('link' => 'date-and-time-functions','anchor' => 'function_subdate'),
1447 'SUBSTR' => array('link' => 'string-functions','anchor' => 'function_substr'),
1448 'SUBSTRING_INDEX' => array('link' => 'string-functions','anchor' => 'function_substring_index'),
1449 'SUBSTRING' => array('link' => 'string-functions','anchor' => 'function_substring'),
1450 'SUBTIME' => array('link' => 'date-and-time-functions','anchor' => 'function_subtime'),
1451 'SUM' => array('link' => 'group-by-functions','anchor' => 'function_sum'),
1452 'SYSDATE' => array('link' => 'date-and-time-functions','anchor' => 'function_sysdate'),
1453 'SYSTEM_USER' => array('link' => 'information-functions','anchor' => 'function_system_user'),
1454 'TAN' => array('link' => 'mathematical-functions','anchor' => 'function_tan'),
1455 'TIME_FORMAT' => array('link' => 'date-and-time-functions','anchor' => 'function_time_format'),
1456 'TIME_TO_SEC' => array('link' => 'date-and-time-functions','anchor' => 'function_time_to_sec'),
1457 'TIME' => array('link' => 'date-and-time-functions','anchor' => 'function_time'),
1458 'TIMEDIFF' => array('link' => 'date-and-time-functions','anchor' => 'function_timediff'),
1459 'TIMESTAMP' => array('link' => 'date-and-time-functions','anchor' => 'function_timestamp'),
1460 'TIMESTAMPADD' => array('link' => 'date-and-time-functions','anchor' => 'function_timestampadd'),
1461 'TIMESTAMPDIFF' => array('link' => 'date-and-time-functions','anchor' => 'function_timestampdiff'),
1462 'TO_DAYS' => array('link' => 'date-and-time-functions','anchor' => 'function_to_days'),
1463 'TRIM' => array('link' => 'string-functions','anchor' => 'function_trim'),
1464 'TRUNCATE' => array('link' => 'mathematical-functions','anchor' => 'function_truncate'),
1465 'UCASE' => array('link' => 'string-functions','anchor' => 'function_ucase'),
1466 'UNCOMPRESS' => array('link' => 'encryption-functions','anchor' => 'function_uncompress'),
1467 'UNCOMPRESSED_LENGTH' => array('link' => 'encryption-functions','anchor' => 'function_uncompressed_length'),
1468 'UNHEX' => array('link' => 'string-functions','anchor' => 'function_unhex'),
1469 'UNIX_TIMESTAMP' => array('link' => 'date-and-time-functions','anchor' => 'function_unix_timestamp'),
1470 'UpdateXML' => array('link' => 'xml-functions','anchor' => 'function_updatexml'),
1471 'UPPER' => array('link' => 'string-functions','anchor' => 'function_upper'),
1472 'USER' => array('link' => 'information-functions','anchor' => 'function_user'),
1473 'UTC_DATE' => array('link' => 'date-and-time-functions','anchor' => 'function_utc_date'),
1474 'UTC_TIME' => array('link' => 'date-and-time-functions','anchor' => 'function_utc_time'),
1475 'UTC_TIMESTAMP' => array('link' => 'date-and-time-functions','anchor' => 'function_utc_timestamp'),
1476 'UUID_SHORT' => array('link' => 'miscellaneous-functions','anchor' => 'function_uuid_short'),
1477 'UUID' => array('link' => 'miscellaneous-functions','anchor' => 'function_uuid'),
1478 'VALUES' => array('link' => 'miscellaneous-functions','anchor' => 'function_values'),
1479 'VAR_POP' => array('link' => 'group-by-functions','anchor' => 'function_var_pop'),
1480 'VAR_SAMP' => array('link' => 'group-by-functions','anchor' => 'function_var_samp'),
1481 'VARIANCE' => array('link' => 'group-by-functions','anchor' => 'function_variance'),
1482 'VERSION' => array('link' => 'information-functions','anchor' => 'function_version'),
1483 'WEEK' => array('link' => 'date-and-time-functions','anchor' => 'function_week'),
1484 'WEEKDAY' => array('link' => 'date-and-time-functions','anchor' => 'function_weekday'),
1485 'WEEKOFYEAR' => array('link' => 'date-and-time-functions','anchor' => 'function_weekofyear'),
1486 'XOR' => array('link' => 'logical-operators','anchor' => 'operator_xor'),
1487 'YEAR' => array('link' => 'date-and-time-functions','anchor' => 'function_year'),
1488 'YEARWEEK' => array('link' => 'date-and-time-functions','anchor' => 'function_yearweek'),
1489 'SOUNDS_LIKE' => array('link' => 'string-functions','anchor' => 'operator_sounds-like'),
1490 'IS_NOT_NULL' => array('link' => 'comparison-operators','anchor' => 'operator_is-not-null'),
1491 'IS_NOT' => array('link' => 'comparison-operators','anchor' => 'operator_is-not'),
1492 'IS_NULL' => array('link' => 'comparison-operators','anchor' => 'operator_is-null'),
1493 'NOT_LIKE' => array('link' => 'string-comparison-functions','anchor' => 'operator_not-like'),
1494 'NOT_REGEXP' => array('link' => 'regexp','anchor' => 'operator_not-regexp'),
1495 'COUNT_DISTINCT' => array('link' => 'group-by-functions','anchor' => 'function_count-distinct'),
1496 'NOT_IN' => array('link' => 'comparison-operators','anchor' => 'function_not-in')