File Manager

Editing File: /usr/share/phpmyadmin/js/doclinks.js

/**
 * Definition of links to MySQL documentation.
 */

// eslint-disable-next-line no-unused-vars
var mysqlDocKeyword = {
    /* Multi word */
    'CHARACTER SET': ['charset'],
    'SHOW AUTHORS': ['show-authors'],
    'SHOW BINARY LOGS': ['show-binary-logs'],
    'SHOW BINLOG EVENTS': ['show-binlog-events'],
    'SHOW CHARACTER SET': ['show-character-set'],
    'SHOW COLLATION': ['show-collation'],
    'SHOW COLUMNS': ['show-columns'],
    'SHOW CONTRIBUTORS': ['show-contributors'],
    'SHOW CREATE DATABASE': ['show-create-database'],
    'SHOW CREATE EVENT': ['show-create-event'],
    'SHOW CREATE FUNCTION': ['show-create-function'],
    'SHOW CREATE PROCEDURE': ['show-create-procedure'],
    'SHOW CREATE TABLE': ['show-create-table'],
    'SHOW CREATE TRIGGER': ['show-create-trigger'],
    'SHOW CREATE VIEW': ['show-create-view'],
    'SHOW DATABASES': ['show-databases'],
    'SHOW ENGINE': ['show-engine'],
    'SHOW ENGINES': ['show-engines'],
    'SHOW ERRORS': ['show-errors'],
    'SHOW EVENTS': ['show-events'],
    'SHOW FUNCTION CODE': ['show-function-code'],
    'SHOW FUNCTION STATUS': ['show-function-status'],
    'SHOW GRANTS': ['show-grants'],
    'SHOW INDEX': ['show-index'],
    'SHOW MASTER STATUS': ['show-master-status'],
    'SHOW OPEN TABLES': ['show-open-tables'],
    'SHOW PLUGINS': ['show-plugins'],
    'SHOW PRIVILEGES': ['show-privileges'],
    'SHOW PROCEDURE CODE': ['show-procedure-code'],
    'SHOW PROCEDURE STATUS': ['show-procedure-status'],
    'SHOW PROCESSLIST': ['show-processlist'],
    'SHOW PROFILE': ['show-profile'],
    'SHOW PROFILES': ['show-profiles'],
    'SHOW RELAYLOG EVENTS': ['show-relaylog-events'],
    'SHOW SLAVE HOSTS': ['show-slave-hosts'],
    'SHOW SLAVE STATUS': ['show-slave-status'],
    'SHOW STATUS': ['show-status'],
    'SHOW TABLE STATUS': ['show-table-status'],
    'SHOW TABLES': ['show-tables'],
    'SHOW TRIGGERS': ['show-triggers'],
    'SHOW VARIABLES': ['show-variables'],
    'SHOW WARNINGS': ['show-warnings'],
    'LOAD DATA INFILE': ['load-data'],
    'LOAD XML': ['load-xml'],
    'LOCK TABLES': ['lock-tables'],
    'UNLOCK TABLES': ['lock-tables'],
    'ALTER DATABASE': ['alter-database'],
    'ALTER EVENT': ['alter-event'],
    'ALTER LOGFILE GROUP': ['alter-logfile-group'],
    'ALTER FUNCTION': ['alter-function'],
    'ALTER PROCEDURE': ['alter-procedure'],
    'ALTER SERVER': ['alter-server'],
    'ALTER TABLE': ['alter-table'],
    'ALTER TABLESPACE': ['alter-tablespace'],
    'ALTER VIEW': ['alter-view'],
    'CREATE DATABASE': ['create-database'],
    'CREATE EVENT': ['create-event'],
    'CREATE FUNCTION': ['create-function'],
    'CREATE INDEX': ['create-index'],
    'CREATE LOGFILE GROUP': ['create-logfile-group'],
    'CREATE PROCEDURE': ['create-procedure'],
    'CREATE SERVER': ['create-server'],
    'CREATE TABLE': ['create-table'],
    'CREATE TABLESPACE': ['create-tablespace'],
    'CREATE TRIGGER': ['create-trigger'],
    'CREATE VIEW': ['create-view'],
    'DROP DATABASE': ['drop-database'],
    'DROP EVENT': ['drop-event'],
    'DROP FUNCTION': ['drop-function'],
    'DROP INDEX': ['drop-index'],
    'DROP LOGFILE GROUP': ['drop-logfile-group'],
    'DROP PROCEDURE': ['drop-procedure'],
    'DROP SERVER': ['drop-server'],
    'DROP TABLE': ['drop-table'],
    'DROP TABLESPACE': ['drop-tablespace'],
    'DROP TRIGGER': ['drop-trigger'],
    'DROP VIEW': ['drop-view'],
    'RENAME TABLE': ['rename-table'],
    'TRUNCATE TABLE': ['truncate-table'],

/* Statements */
    'SELECT': ['select'],
    'SET': ['set'],
    'EXPLAIN': ['explain'],
    'DESCRIBE': ['describe'],
    'DELETE': ['delete'],
    'SHOW': ['show'],
    'UPDATE': ['update'],
    'INSERT': ['insert'],
    'REPLACE': ['replace'],
    'CALL': ['call'],
    'DO': ['do'],
    'HANDLER': ['handler'],
    'COLLATE': ['charset-collations'],

/* Functions */
    'ABS': ['mathematical-functions', 'function_abs'],
    'ACOS': ['mathematical-functions', 'function_acos'],
    'ADDDATE': ['date-and-time-functions', 'function_adddate'],
    'ADDTIME': ['date-and-time-functions', 'function_addtime'],
    'AES_DECRYPT': ['encryption-functions', 'function_aes_decrypt'],
    'AES_ENCRYPT': ['encryption-functions', 'function_aes_encrypt'],
    'AND': ['logical-operators', 'operator_and'],
    'ASCII': ['string-functions', 'function_ascii'],
    'ASIN': ['mathematical-functions', 'function_asin'],
    'ATAN2': ['mathematical-functions', 'function_atan2'],
    'ATAN': ['mathematical-functions', 'function_atan'],
    'AVG': ['group-by-functions', 'function_avg'],
    'BENCHMARK': ['information-functions', 'function_benchmark'],
    'BIN': ['string-functions', 'function_bin'],
    'BINARY': ['cast-functions', 'operator_binary'],
    'BIT_AND': ['group-by-functions', 'function_bit_and'],
    'BIT_COUNT': ['bit-functions', 'function_bit_count'],
    'BIT_LENGTH': ['string-functions', 'function_bit_length'],
    'BIT_OR': ['group-by-functions', 'function_bit_or'],
    'BIT_XOR': ['group-by-functions', 'function_bit_xor'],
    'CASE': ['control-flow-functions', 'operator_case'],
    'CAST': ['cast-functions', 'function_cast'],
    'CEIL': ['mathematical-functions', 'function_ceil'],
    'CEILING': ['mathematical-functions', 'function_ceiling'],
    'CHAR_LENGTH': ['string-functions', 'function_char_length'],
    'CHAR': ['string-functions', 'function_char'],
    'CHARACTER_LENGTH': ['string-functions', 'function_character_length'],
    'CHARSET': ['information-functions', 'function_charset'],
    'COALESCE': ['comparison-operators', 'function_coalesce'],
    'COERCIBILITY': ['information-functions', 'function_coercibility'],
    'COLLATION': ['information-functions', 'function_collation'],
    'COMPRESS': ['encryption-functions', 'function_compress'],
    'CONCAT_WS': ['string-functions', 'function_concat_ws'],
    'CONCAT': ['string-functions', 'function_concat'],
    'CONNECTION_ID': ['information-functions', 'function_connection_id'],
    'CONV': ['mathematical-functions', 'function_conv'],
    'CONVERT_TZ': ['date-and-time-functions', 'function_convert_tz'],
    'Convert': ['cast-functions', 'function_convert'],
    'COS': ['mathematical-functions', 'function_cos'],
    'COT': ['mathematical-functions', 'function_cot'],
    'COUNT': ['group-by-functions', 'function_count'],
    'CRC32': ['mathematical-functions', 'function_crc32'],
    'CURDATE': ['date-and-time-functions', 'function_curdate'],
    'CURRENT_DATE': ['date-and-time-functions', 'function_current_date'],
    'CURRENT_TIME': ['date-and-time-functions', 'function_current_time'],
    'CURRENT_TIMESTAMP': ['date-and-time-functions', 'function_current_timestamp'],
    'CURRENT_USER': ['information-functions', 'function_current_user'],
    'CURTIME': ['date-and-time-functions', 'function_curtime'],
    'DATABASE': ['information-functions', 'function_database'],
    'DATE_ADD': ['date-and-time-functions', 'function_date_add'],
    'DATE_FORMAT': ['date-and-time-functions', 'function_date_format'],
    'DATE_SUB': ['date-and-time-functions', 'function_date_sub'],
    'DATE': ['date-and-time-functions', 'function_date'],
    'DATEDIFF': ['date-and-time-functions', 'function_datediff'],
    'DAY': ['date-and-time-functions', 'function_day'],
    'DAYNAME': ['date-and-time-functions', 'function_dayname'],
    'DAYOFMONTH': ['date-and-time-functions', 'function_dayofmonth'],
    'DAYOFWEEK': ['date-and-time-functions', 'function_dayofweek'],
    'DAYOFYEAR': ['date-and-time-functions', 'function_dayofyear'],
    'DECLARE': ['declare', 'declare'],
    'DECODE': ['encryption-functions', 'function_decode'],
    'DEFAULT': ['miscellaneous-functions', 'function_default'],
    'DEGREES': ['mathematical-functions', 'function_degrees'],
    'DES_DECRYPT': ['encryption-functions', 'function_des_decrypt'],
    'DES_ENCRYPT': ['encryption-functions', 'function_des_encrypt'],
    'DIV': ['arithmetic-functions', 'operator_div'],
    'ELT': ['string-functions', 'function_elt'],
    'ENCODE': ['encryption-functions', 'function_encode'],
    'ENCRYPT': ['encryption-functions', 'function_encrypt'],
    'EXP': ['mathematical-functions', 'function_exp'],
    'EXPORT_SET': ['string-functions', 'function_export_set'],
    'EXTRACT': ['date-and-time-functions', 'function_extract'],
    'ExtractValue': ['xml-functions', 'function_extractvalue'],
    'FIELD': ['string-functions', 'function_field'],
    'FIND_IN_SET': ['string-functions', 'function_find_in_set'],
    'FLOOR': ['mathematical-functions', 'function_floor'],
    'FORMAT': ['string-functions', 'function_format'],
    'FOUND_ROWS': ['information-functions', 'function_found_rows'],
    'FROM_DAYS': ['date-and-time-functions', 'function_from_days'],
    'FROM_UNIXTIME': ['date-and-time-functions', 'function_from_unixtime'],
    'GET_FORMAT': ['date-and-time-functions', 'function_get_format'],
    'GET_LOCK': ['miscellaneous-functions', 'function_get_lock'],
    'GREATEST': ['comparison-operators', 'function_greatest'],
    'GROUP_CONCAT': ['group-by-functions', 'function_group_concat'],
    'HEX': ['string-functions', 'function_hex'],
    'HOUR': ['date-and-time-functions', 'function_hour'],
    'IF': ['control-flow-functions', 'function_if'],
    'IFNULL': ['control-flow-functions', 'function_ifnull'],
    'IN': ['comparison-operators', 'function_in'],
    'INET_ATON': ['miscellaneous-functions', 'function_inet_aton'],
    'INET_NTOA': ['miscellaneous-functions', 'function_inet_ntoa'],
    'INSTR': ['string-functions', 'function_instr'],
    'INTERVAL': ['comparison-operators', 'function_interval'],
    'IS_FREE_LOCK': ['miscellaneous-functions', 'function_is_free_lock'],
    'IS_USED_LOCK': ['miscellaneous-functions', 'function_is_used_lock'],
    'IS': ['comparison-operators', 'operator_is'],
    'ISNULL': ['comparison-operators', 'function_isnull'],
    'LAST_DAY': ['date-and-time-functions', 'function_last_day'],
    'LAST_INSERT_ID': ['information-functions', 'function_last_insert_id'],
    'LCASE': ['string-functions', 'function_lcase'],
    'LEAST': ['comparison-operators', 'function_least'],
    'LEFT': ['string-functions', 'function_left'],
    'LENGTH': ['string-functions', 'function_length'],
    'LIKE': ['string-comparison-functions', 'operator_like'],
    'LN': ['mathematical-functions', 'function_ln'],
    'LOAD_FILE': ['string-functions', 'function_load_file'],
    'LOCALTIME': ['date-and-time-functions', 'function_localtime'],
    'LOCALTIMESTAMP': ['date-and-time-functions', 'function_localtimestamp'],
    'LOCATE': ['string-functions', 'function_locate'],
    'LOG10': ['mathematical-functions', 'function_log10'],
    'LOG2': ['mathematical-functions', 'function_log2'],
    'LOG': ['mathematical-functions', 'function_log'],
    'LOWER': ['string-functions', 'function_lower'],
    'LPAD': ['string-functions', 'function_lpad'],
    'LTRIM': ['string-functions', 'function_ltrim'],
    'MAKE_SET': ['string-functions', 'function_make_set'],
    'MAKEDATE': ['date-and-time-functions', 'function_makedate'],
    'MAKETIME': ['date-and-time-functions', 'function_maketime'],
    'MASTER_POS_WAIT': ['miscellaneous-functions', 'function_master_pos_wait'],
    'MATCH': ['fulltext-search', 'function_match'],
    'MAX': ['group-by-functions', 'function_max'],
    'MD5': ['encryption-functions', 'function_md5'],
    'MICROSECOND': ['date-and-time-functions', 'function_microsecond'],
    'MID': ['string-functions', 'function_mid'],
    'MIN': ['group-by-functions', 'function_min'],
    'MINUTE': ['date-and-time-functions', 'function_minute'],
    'MOD': ['mathematical-functions', 'function_mod'],
    'MONTH': ['date-and-time-functions', 'function_month'],
    'MONTHNAME': ['date-and-time-functions', 'function_monthname'],
    'NAME_CONST': ['miscellaneous-functions', 'function_name_const'],
    'NOT': ['logical-operators', 'operator_not'],
    'NOW': ['date-and-time-functions', 'function_now'],
    'NULLIF': ['control-flow-functions', 'function_nullif'],
    'OCT': ['mathematical-functions', 'function_oct'],
    'OCTET_LENGTH': ['string-functions', 'function_octet_length'],
    'OLD_PASSWORD': ['encryption-functions', 'function_old_password'],
    'OR': ['logical-operators', 'operator_or'],
    'ORD': ['string-functions', 'function_ord'],
    'PASSWORD': ['encryption-functions', 'function_password'],
    'PERIOD_ADD': ['date-and-time-functions', 'function_period_add'],
    'PERIOD_DIFF': ['date-and-time-functions', 'function_period_diff'],
    'PI': ['mathematical-functions', 'function_pi'],
    'POSITION': ['string-functions', 'function_position'],
    'POW': ['mathematical-functions', 'function_pow'],
    'POWER': ['mathematical-functions', 'function_power'],
    'QUARTER': ['date-and-time-functions', 'function_quarter'],
    'QUOTE': ['string-functions', 'function_quote'],
    'RADIANS': ['mathematical-functions', 'function_radians'],
    'RAND': ['mathematical-functions', 'function_rand'],
    'REGEXP': ['regexp', 'operator_regexp'],
    'RELEASE_LOCK': ['miscellaneous-functions', 'function_release_lock'],
    'REPEAT': ['string-functions', 'function_repeat'],
    'REVERSE': ['string-functions', 'function_reverse'],
    'RIGHT': ['string-functions', 'function_right'],
    'RLIKE': ['regexp', 'operator_rlike'],
    'ROUND': ['mathematical-functions', 'function_round'],
    'ROW_COUNT': ['information-functions', 'function_row_count'],
    'RPAD': ['string-functions', 'function_rpad'],
    'RTRIM': ['string-functions', 'function_rtrim'],
    'SCHEMA': ['information-functions', 'function_schema'],
    'SEC_TO_TIME': ['date-and-time-functions', 'function_sec_to_time'],
    'SECOND': ['date-and-time-functions', 'function_second'],
    'SESSION_USER': ['information-functions', 'function_session_user'],
    'SHA': ['encryption-functions', 'function_sha1'],
    'SHA1': ['encryption-functions', 'function_sha1'],
    'SIGN': ['mathematical-functions', 'function_sign'],
    'SIN': ['mathematical-functions', 'function_sin'],
    'SLEEP': ['miscellaneous-functions', 'function_sleep'],
    'SOUNDEX': ['string-functions', 'function_soundex'],
    'SPACE': ['string-functions', 'function_space'],
    'SQRT': ['mathematical-functions', 'function_sqrt'],
    'STD': ['group-by-functions', 'function_std'],
    'STDDEV_POP': ['group-by-functions', 'function_stddev_pop'],
    'STDDEV_SAMP': ['group-by-functions', 'function_stddev_samp'],
    'STDDEV': ['group-by-functions', 'function_stddev'],
    'STR_TO_DATE': ['date-and-time-functions', 'function_str_to_date'],
    'STRCMP': ['string-comparison-functions', 'function_strcmp'],
    'SUBDATE': ['date-and-time-functions', 'function_subdate'],
    'SUBSTR': ['string-functions', 'function_substr'],
    'SUBSTRING_INDEX': ['string-functions', 'function_substring_index'],
    'SUBSTRING': ['string-functions', 'function_substring'],
    'SUBTIME': ['date-and-time-functions', 'function_subtime'],
    'SUM': ['group-by-functions', 'function_sum'],
    'SYSDATE': ['date-and-time-functions', 'function_sysdate'],
    'SYSTEM_USER': ['information-functions', 'function_system_user'],
    'TAN': ['mathematical-functions', 'function_tan'],
    'TIME_FORMAT': ['date-and-time-functions', 'function_time_format'],
    'TIME_TO_SEC': ['date-and-time-functions', 'function_time_to_sec'],
    'TIME': ['date-and-time-functions', 'function_time'],
    'TIMEDIFF': ['date-and-time-functions', 'function_timediff'],
    'TIMESTAMP': ['date-and-time-functions', 'function_timestamp'],
    'TIMESTAMPADD': ['date-and-time-functions', 'function_timestampadd'],
    'TIMESTAMPDIFF': ['date-and-time-functions', 'function_timestampdiff'],
    'TO_DAYS': ['date-and-time-functions', 'function_to_days'],
    'TRIM': ['string-functions', 'function_trim'],
    'TRUNCATE': ['mathematical-functions', 'function_truncate'],
    'UCASE': ['string-functions', 'function_ucase'],
    'UNCOMPRESS': ['encryption-functions', 'function_uncompress'],
    'UNCOMPRESSED_LENGTH': ['encryption-functions', 'function_uncompressed_length'],
    'UNHEX': ['string-functions', 'function_unhex'],
    'UNIX_TIMESTAMP': ['date-and-time-functions', 'function_unix_timestamp'],
    'UpdateXML': ['xml-functions', 'function_updatexml'],
    'UPPER': ['string-functions', 'function_upper'],
    'USER': ['information-functions', 'function_user'],
    'UTC_DATE': ['date-and-time-functions', 'function_utc_date'],
    'UTC_TIME': ['date-and-time-functions', 'function_utc_time'],
    'UTC_TIMESTAMP': ['date-and-time-functions', 'function_utc_timestamp'],
    'UUID_SHORT': ['miscellaneous-functions', 'function_uuid_short'],
    'UUID': ['miscellaneous-functions', 'function_uuid'],
    'VALUES': ['miscellaneous-functions', 'function_values'],
    'VAR_POP': ['group-by-functions', 'function_var_pop'],
    'VAR_SAMP': ['group-by-functions', 'function_var_samp'],
    'VARIANCE': ['group-by-functions', 'function_variance'],
    'VERSION': ['information-functions', 'function_version'],
    'WEEK': ['date-and-time-functions', 'function_week'],
    'WEEKDAY': ['date-and-time-functions', 'function_weekday'],
    'WEEKOFYEAR': ['date-and-time-functions', 'function_weekofyear'],
    'XOR': ['logical-operators', 'operator_xor'],
    'YEAR': ['date-and-time-functions', 'function_year'],
    'YEARWEEK': ['date-and-time-functions', 'function_yearweek'],
    'SOUNDS_LIKE': ['string-functions', 'operator_sounds-like'],
    'IS_NOT_NULL': ['comparison-operators', 'operator_is-not-null'],
    'IS_NOT': ['comparison-operators', 'operator_is-not'],
    'IS_NULL': ['comparison-operators', 'operator_is-null'],
    'NOT_LIKE': ['string-comparison-functions', 'operator_not-like'],
    'NOT_REGEXP': ['regexp', 'operator_not-regexp'],
    'COUNT_DISTINCT': ['group-by-functions', 'function_count-distinct'],
    'NOT_IN': ['comparison-operators', 'function_not-in']
};

// eslint-disable-next-line no-unused-vars
var mysqlDocBuiltin = {
    'TINYINT': ['numeric-types'],
    'SMALLINT': ['numeric-types'],
    'MEDIUMINT': ['numeric-types'],
    'INT': ['numeric-types'],
    'BIGINT': ['numeric-types'],
    'DECIMAL': ['numeric-types'],
    'FLOAT': ['numeric-types'],
    'DOUBLE': ['numeric-types'],
    'REAL': ['numeric-types'],
    'BIT': ['numeric-types'],
    'BOOLEAN': ['numeric-types'],
    'SERIAL': ['numeric-types'],
    'DATE': ['date-and-time-types'],
    'DATETIME': ['date-and-time-types'],
    'TIMESTAMP': ['date-and-time-types'],
    'TIME': ['date-and-time-types'],
    'YEAR': ['date-and-time-types'],
    'CHAR': ['string-types'],
    'VARCHAR': ['string-types'],
    'TINYTEXT': ['string-types'],
    'TEXT': ['string-types'],
    'MEDIUMTEXT': ['string-types'],
    'LONGTEXT': ['string-types'],
    'BINARY': ['string-types'],
    'VARBINARY': ['string-types'],
    'TINYBLOB': ['string-types'],
    'MEDIUMBLOB': ['string-types'],
    'BLOB': ['string-types'],
    'LONGBLOB': ['string-types'],
    'ENUM': ['string-types'],
    'SET': ['string-types']
};

Back to Directory File Manager