libraries/sqlparser.data.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * SQL Parser Matching Data
   5  *
   6  * Copyright 2002 Robin Johnson <robbat2@users.sourceforge.net>
   7  * http://www.orbis-terrarum.net/?l=people.robbat2
   8  *
   9  * This data is used by the SQL Parser to recognize keywords
  10  *
  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.
  13  *
  14  * It's easier to use only uppercase for proper sorting. In case of
  15  * doubt, use the test case to verify.
  16  *
  17  * @package PhpMyAdmin
  18  */
  19 if (! defined('PHPMYADMIN')) {
  20     exit;
  21 }
  22
  23 if (! isset($GLOBALS['sql_delimiter'])) {
  24         $GLOBALS['sql_delimiter'] = ';';
  25 }
  26
  27 /**
  28  * @global array MySQL function names
  29  */
  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'
 329 );
 330
 331 /**
 332  * @global array MySQL attributes
 333  */
 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'
 365 );
 366
 367 /**
 368  * words that are reserved by MySQL and may not be used as identifiers without quotes
 369  *
 370  * @see http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html
 371  *
 372  * @global array MySQL reserved words
 373  */
 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'
 674 );
 675
 676 /**
 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
 679  *
 680  * @global array MySQL forbidden words
 681  */
 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'
1165 );
1166
1167 /**
1168  * the MySQL column/data types
1169  *
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
1172  *
1173  * @global array MySQL column types
1174  */
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'
1230 );
1231
1232 /**
1233  * Documentation links for operators.
1234  */
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')
1260 );
1261
1262 /**
1263  * Documentation links for functions.
1264  */
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')
1497 );
1498
1499 ?>