geshi/mysql.php
<?php
/*************************************************************************************
* mysql.php
* ---------
* Author: Marjolein Katsma (marjolein.is.back@gmail.com)
* Copyright: (c) 2008 Marjolein Katsma (http://blog.marjoleinkatsma.com/)
* Release Version: 1.0.8.3
* Date Started: 2008-12-12
*
* MySQL language file for GeSHi.
*
* Based on original MySQL language file by Carl Fürstenberg (2004); brought
* up-to-date for current MySQL versions, and with more classes for different
* types of keywords; several minor errors were corrected as well.
*
* Some "classes" have two groups here: this is to allow for the fact that some
* keywords in MySQL have a double function: many of those are either a function
* (must be immediately followed by an opening bracket) or some other keyword:
* so they can be distinguished by the presence (or not) of that opening bracket.
* (An immediately following opening bracket is a default rule for functions in
* MySQL, though this may be overridden; because it's only a default, we use a
* regex lookahead only where necessary to distinguish homonyms, not generally
* to match any function.)
* Other keywords with double usage cannot be distinguished and are classified
* in the "Mix" category.
*
*************************************************************************************
*
* This file is part of GeSHi.
*
* GeSHi is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* GeSHi is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with GeSHi; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*
************************************************************************************/
$language_data = array (
'LANG_NAME' => 'MySQL',
//'COMMENT_SINGLE' => array(1 =>'--', 2 => '#'), // '--' MUST be folowed by whitespace,not necessarily a space
'COMMENT_SINGLE' => array(
1 =>'-- ',
2 => '#'
),
'COMMENT_REGEXP' => array(
1 => "/(?:--\s).*?$/", // double dash followed by any whitespace
),
'COMMENT_MULTI' => array('/*' => '*/'),
'CASE_KEYWORDS' => GESHI_CAPS_NO_CHANGE, // @@@ would be nice if this could be defined per group!
'QUOTEMARKS' => array("'", '"', '`'),
'ESCAPE_CHAR' => '\\', // by default only, can be specified
'ESCAPE_REGEXP' => array(
1 => "/[_%]/", // search wildcards
),
'NUMBERS' =>
GESHI_NUMBER_INT_BASIC |
GESHI_NUMBER_OCT_PREFIX |
GESHI_NUMBER_HEX_PREFIX |
GESHI_NUMBER_FLT_NONSCI |
GESHI_NUMBER_FLT_SCI_SHORT |
GESHI_NUMBER_FLT_SCI_ZERO,
'KEYWORDS' => array(
1 => array(
// Mix: statement keywords and keywords that don't fit in any other
// category, or have multiple usage/meanings
'ACTION','ADD','AFTER','ALGORITHM','ALL','ALTER','ANALYZE','ANY',
'ASC','AS','BDB','BEGIN','BERKELEYDB','BINARY','BTREE','CALL',
'CASCADED','CASCADE','CHAIN','CHECK','COLUMNS','COLUMN','COMMENT',
'COMMIT','COMMITTED','CONSTRAINT','CONTAINS SQL','CONSISTENT',
'CONVERT','CREATE','CROSS','DATA','DATABASES',
'DECLARE','DEFINER','DELAYED','DELETE','DESCRIBE','DESC',
'DETERMINISTIC','DISABLE','DISCARD','DISTINCTROW','DISTINCT','DO',
'DROP','DUMPFILE','DUPLICATE KEY','ENABLE','ENCLOSED BY','ENGINE',
'ERRORS','ESCAPED BY','EXISTS','EXPLAIN','EXTENDED','FIELDS',
'FIRST','FOR EACH ROW','FORCE','FOREIGN KEY','FROM','FULL',
'FUNCTION','GLOBAL','GRANT','GROUP BY','HANDLER','HASH','HAVING',
'HELP','HIGH_PRIORITY','IF NOT EXISTS','IGNORE','IMPORT','INDEX',
'INFILE','INNER','INNODB','INOUT','INTO','INVOKER',
'ISOLATION LEVEL','JOIN','KEYS','KEY','KILL','LANGUAGE SQL','LAST',
'LIMIT','LINES','LOAD','LOCAL','LOCK','LOW_PRIORITY',
'MASTER_SERVER_ID','MATCH','MERGE','MIDDLEINT','MODIFIES SQL DATA',
'MODIFY','MRG_MYISAM','NATURAL','NEXT','NO SQL','NO','ON',
'OPTIMIZE','OPTIONALLY','OPTION','ORDER BY','OUTER','OUTFILE','OUT',
'PARTIAL','PREV','PRIMARY KEY','PRIVILEGES','PROCEDURE','PURGE',
'QUICK','READS SQL DATA','READ','REFERENCES','RELEASE','RENAME',
'REPEATABLE','REQUIRE','RESTRICT','RETURNS','REVOKE',
'ROLLBACK','ROUTINE','RTREE','SAVEPOINT','SELECT',
'SERIALIZABLE','SESSION','SET','SHARE MODE','SHOW','SIMPLE',
'SNAPSHOT','SOME','SONAME','SQL SECURITY','SQL_BIG_RESULT',
'SQL_BUFFER_RESULT','SQL_CACHE','SQL_CALC_FOUND_ROWS',
'SQL_NO_CACHE','SQL_SMALL_RESULT','SSL','START','STARTING BY',
'STATUS','STRAIGHT_JOIN','STRIPED','TABLESPACE','TABLES','TABLE',
'TEMPORARY','TEMPTABLE','TERMINATED BY','TO','TRANSACTIONS',
'TRANSACTION','TRIGGER','TYPES','TYPE','UNCOMMITTED','UNDEFINED',
'UNION','UNLOCK_TABLES','UPDATE','USAGE','USE','USER_RESOURCES',
'USING','VALUES','VALUE','VIEW','WARNINGS','WHERE','WITH ROLLUP',
'WITH','WORK','WRITE',
),
2 => array( //No ( must follow
// Mix: statement keywords distinguished from functions by the same name
"CURRENT_USER", "DATABASE", "IN", "INSERT", "DEFAULT", "REPLACE", "SCHEMA", "TRUNCATE"
),
3 => array(
// Values (Constants)
'FALSE','NULL','TRUE',
),
4 => array(
// Column Data Types
'BIGINT','BIT','BLOB','BOOLEAN','BOOL','CHARACTER VARYING',
'CHAR VARYING','DATETIME','DECIMAL','DEC','DOUBLE PRECISION',
'DOUBLE','ENUM','FIXED','FLOAT','GEOMETRYCOLLECTION','GEOMETRY',
'INTEGER','INT','LINESTRING','LONGBLOB','LONGTEXT','MEDIUMBLOB',
'MEDIUMINT','MEDIUMTEXT','MULTIPOINT','MULTILINESTRING',
'MULTIPOLYGON','NATIONAL CHARACTER','NATIONAL CHARACTER VARYING',
'NATIONAL CHAR VARYING','NATIONAL VARCHAR','NCHAR VARCHAR','NCHAR',
'NUMERIC','POINT','POLYGON','REAL','SERIAL',
'SMALLINT','TEXT','TIMESTAMP','TINYBLOB','TINYINT',
'TINYTEXT','VARBINARY','VARCHARACTER','VARCHAR',
),
5 => array( //No ( must follow
// Column data types distinguished from functions by the same name
"CHAR", "DATE", "TIME"
),
6 => array(
// Table, Column & Index Attributes
'AUTO_INCREMENT','AVG_ROW_LENGTH','BOTH','CHECKSUM','CONNECTION',
'DATA DIRECTORY','DEFAULT NULL','DELAY_KEY_WRITE','FULLTEXT',
'INDEX DIRECTORY','INSERT_METHOD','LEADING','MAX_ROWS','MIN_ROWS',
'NOT NULL','PACK_KEYS','ROW_FORMAT','SERIAL DEFAULT VALUE','SIGNED',
'SPATIAL','TRAILING','UNIQUE','UNSIGNED','ZEROFILL'
),
7 => array( //No ( must follow
// Column attribute distinguished from function by the same name
"CHARSET"
),
8 => array(
// Date and Time Unit Specifiers
'DAY_HOUR','DAY_MICROSECOND','DAY_MINUTE','DAY_SECOND',
'HOUR_MICROSECOND','HOUR_MINUTE','HOUR_SECOND',
'MINUTE_MICROSECOND','MINUTE_SECOND',
'SECOND_MICROSECOND','YEAR_MONTH'
),
9 => array( //No ( must follow
// Date-time unit specifiers distinguished from functions by the same name
"DAY", "HOUR", "MICROSECOND", "MINUTE", "MONTH", "QUARTER", "SECOND", "WEEK", "YEAR"
),
10 => array(
// Operators (see also Symbols)
'AND','BETWEEN','CHARACTER SET','COLLATE','DIV','IS NOT NULL',
'IS NOT','IS NULL','IS','LIKE','NOT','OFFSET','OR','REGEXP','RLIKE',
'SOUNDS LIKE','XOR'
),
11 => array( //No ( must follow
// Operator distinghuished from function by the same name
"INTERVAL"
),
12 => array(
// Control Flow (functions)
'CASE','ELSE','END','IFNULL','IF','NULLIF','THEN','WHEN',
),
13 => array(
// String Functions
'ASCII','BIN','BIT_LENGTH','CHAR_LENGTH','CHARACTER_LENGTH',
'CONCAT_WS','CONCAT','ELT','EXPORT_SET','FIELD',
'FIND_IN_SET','FORMAT','HEX','INSTR','LCASE','LEFT','LENGTH',
'LOAD_FILE','LOCATE','LOWER','LPAD','LTRIM','MAKE_SET','MID',
'OCTET_LENGTH','ORD','POSITION','QUOTE','REPEAT','REVERSE',
'RIGHT','RPAD','RTRIM','SOUNDEX','SPACE','STRCMP','SUBSTRING_INDEX',
'SUBSTRING','TRIM','UCASE','UNHEX','UPPER',
),
14 => array( //A ( must follow
// String functions distinguished from other keywords by the same name
"INSERT", "REPLACE", "CHAR"
),
15 => array(
// Numeric Functions
'ABS','ACOS','ASIN','ATAN2','ATAN','CEILING','CEIL',
'CONV','COS','COT','CRC32','DEGREES','EXP','FLOOR','LN','LOG10',
'LOG2','LOG','MOD','OCT','PI','POWER','POW','RADIANS','RAND',
'ROUND','SIGN','SIN','SQRT','TAN',
),
16 => array( //A ( must follow
// Numeric function distinguished from other keyword by the same name
"TRUNCATE"
),
17 => array(
// Date and Time Functions
'ADDDATE','ADDTIME','CONVERT_TZ','CURDATE','CURRENT_DATE',
'CURRENT_TIME','CURRENT_TIMESTAMP','CURTIME','DATE_ADD',
'DATE_FORMAT','DATE_SUB','DATEDIFF','DAYNAME','DAYOFMONTH',
'DAYOFWEEK','DAYOFYEAR','EXTRACT','FROM_DAYS','FROM_UNIXTIME',
'GET_FORMAT','LAST_DAY','LOCALTIME','LOCALTIMESTAMP','MAKEDATE',
'MAKETIME','MONTHNAME','NOW','PERIOD_ADD',
'PERIOD_DIFF','SEC_TO_TIME','STR_TO_DATE','SUBDATE','SUBTIME',
'SYSDATE','TIME_FORMAT','TIME_TO_SEC',
'TIMESTAMPADD','TIMESTAMPDIFF','TO_DAYS',
'UNIX_TIMESTAMP','UTC_DATE','UTC_TIME','UTC_TIMESTAMP','WEEKDAY',
'WEEKOFYEAR','YEARWEEK',
),
18 => array( //A ( must follow
// Date-time functions distinguished from other keywords by the same name
"DATE", "DAY", "HOUR", "MICROSECOND", "MINUTE", "MONTH", "QUARTER",
"SECOND", "TIME", "WEEK", "YEAR"
),
19 => array(
// Comparison Functions
'COALESCE','GREATEST','ISNULL','LEAST',
),
20 => array( //A ( must follow
// Comparison functions distinguished from other keywords by the same name
"IN", "INTERVAL"
),
21 => array(
// Encryption and Compression Functions
'AES_DECRYPT','AES_ENCRYPT','COMPRESS','DECODE','DES_DECRYPT',
'DES_ENCRYPT','ENCODE','ENCRYPT','MD5','OLD_PASSWORD','PASSWORD',
'SHA1','SHA','UNCOMPRESS','UNCOMPRESSED_LENGTH',
),
22 => array(
// GROUP BY (aggregate) Functions
'AVG','BIT_AND','BIT_OR','BIT_XOR','COUNT','GROUP_CONCAT',
'MAX','MIN','STDDEV_POP','STDDEV_SAMP','STDDEV','STD','SUM',
'VAR_POP','VAR_SAMP','VARIANCE',
),
23 => array(
// Information Functions
'BENCHMARK','COERCIBILITY','COLLATION','CONNECTION_ID',
'FOUND_ROWS','LAST_INSERT_ID','ROW_COUNT',
'SESSION_USER','SYSTEM_USER','USER','VERSION',
),
24 => array( //A ( must follow
// Information functions distinguished from other keywords by the same name
"CURRENT_USER", "DATABASE", "SCHEMA", "CHARSET"
),
25 => array(
// Miscellaneous Functions
'ExtractValue','BIT_COUNT','GET_LOCK','INET_ATON','INET_NTOA',
'IS_FREE_LOCK','IS_USED_LOCK','MASTER_POS_WAIT','NAME_CONST',
'RELEASE_LOCK','SLEEP','UpdateXML','UUID',
),
26 => array( //A ( must follow
// Miscellaneous function distinguished from other keyword by the same name
"DEFAULT"
),
27 => array(
// Geometry Functions
'Area','AsBinary','AsText','AsWKB','AsWKT','Boundary','Buffer',
'Centroid','Contains','ConvexHull','Crosses',
'Difference','Dimension','Disjoint','Distance',
'EndPoint','Envelope','Equals','ExteriorRing',
'GLength','GeomCollFromText','GeomCollFromWKB','GeomFromText',
'GeomFromWKB','GeometryCollectionFromText',
'GeometryCollectionFromWKB','GeometryFromText','GeometryFromWKB',
'GeometryN','GeometryType',
'InteriorRingN','Intersection','Intersects','IsClosed','IsEmpty',
'IsRing','IsSimple',
'LineFromText','LineFromWKB','LineStringFromText',
'LineStringFromWKB',
'MBRContains','MBRDisjoint','MBREqual','MBRIntersects',
'MBROverlaps','MBRTouches','MBRWithin','MLineFromText',
'MLineFromWKB','MPointFromText','MPointFromWKB','MPolyFromText',
'MPolyFromWKB','MultiLineStringFromText','MultiLineStringFromWKB',
'MultiPointFromText','MultiPointFromWKB','MultiPolygonFromText',
'MultiPolygonFromWKB',
'NumGeometries','NumInteriorRings','NumPoints',
'Overlaps',
'PointFromText','PointFromWKB','PointN','PointOnSurface',
'PolyFromText','PolyFromWKB','PolygonFromText','PolygonFromWKB',
'Related','SRID','StartPoint','SymDifference',
'Touches',
'Union',
'Within',
'X',
'Y',
),
),
'SYMBOLS' => array(
1 => array(
/* Operators */
'=', ':=', // assignment operators
'||', '&&', '!', // locical operators
'=', '<=>', '>=', '>', '<=', '<', '<>', '!=', // comparison operators
'|', '&', '^', '~', '<<', '>>', // bitwise operators
'-', '+', '*', '/', '%', // numerical operators
),
2 => array(
/* Other syntactical symbols */
'(', ')',
',', ';',
),
),
'CASE_SENSITIVE' => array(
GESHI_COMMENTS => false,
1 => false,
2 => false,
3 => false,
4 => false,
5 => false,
6 => false,
7 => false,
8 => false,
9 => false,
10 => false,
11 => false,
12 => false,
13 => false,
13 => false,
14 => false,
15 => false,
16 => false,
17 => false,
18 => false,
19 => false,
20 => false,
21 => false,
22 => false,
23 => false,
24 => false,
25 => false,
26 => false,
27 => false,
),
'STYLES' => array(
'KEYWORDS' => array(
1 => 'color: #990099; font-weight: bold;', // mix
2 => 'color: #990099; font-weight: bold;', // mix
3 => 'color: #9900FF; font-weight: bold;', // constants
4 => 'color: #999900; font-weight: bold;', // column data types
5 => 'color: #999900; font-weight: bold;', // column data types
6 => 'color: #FF9900; font-weight: bold;', // attributes
7 => 'color: #FF9900; font-weight: bold;', // attributes
8 => 'color: #9900FF; font-weight: bold;', // date-time units
9 => 'color: #9900FF; font-weight: bold;', // date-time units
10 => 'color: #CC0099; font-weight: bold;', // operators
11 => 'color: #CC0099; font-weight: bold;', // operators
12 => 'color: #009900;', // control flow (functions)
13 => 'color: #000099;', // string functions
14 => 'color: #000099;', // string functions
15 => 'color: #000099;', // numeric functions
16 => 'color: #000099;', // numeric functions
17 => 'color: #000099;', // date-time functions
18 => 'color: #000099;', // date-time functions
19 => 'color: #000099;', // comparison functions
20 => 'color: #000099;', // comparison functions
21 => 'color: #000099;', // encryption functions
22 => 'color: #000099;', // aggregate functions
23 => 'color: #000099;', // information functions
24 => 'color: #000099;', // information functions
25 => 'color: #000099;', // miscellaneous functions
26 => 'color: #000099;', // miscellaneous functions
27 => 'color: #00CC00;', // geometry functions
),
'COMMENTS' => array(
'MULTI' => 'color: #808000; font-style: italic;',
1 => 'color: #808080; font-style: italic;',
2 => 'color: #808080; font-style: italic;'
),
'ESCAPE_CHAR' => array(
0 => 'color: #004000; font-weight: bold;',
1 => 'color: #008080; font-weight: bold;' // search wildcards
),
'BRACKETS' => array(
0 => 'color: #FF00FF;'
),
'STRINGS' => array(
0 => 'color: #008000;'
),
'NUMBERS' => array(
0 => 'color: #008080;'
),
'METHODS' => array(
),
'SYMBOLS' => array(
1 => 'color: #CC0099;', // operators
2 => 'color: #000033;', // syntax
),
'SCRIPT' => array(
),
'REGEXPS' => array(
)
),
'URLS' => array(
1 => 'http://search.mysql.com/search?site=refman-51&q={FNAME}&lr=lang_en',
2 => 'http://search.mysql.com/search?site=refman-51&q={FNAME}&lr=lang_en',
3 => 'http://search.mysql.com/search?site=refman-51&q={FNAME}&lr=lang_en',
4 => 'http://search.mysql.com/search?site=refman-51&q={FNAME}&lr=lang_en',
5 => 'http://search.mysql.com/search?site=refman-51&q={FNAME}&lr=lang_en',
6 => 'http://search.mysql.com/search?site=refman-51&q={FNAME}&lr=lang_en',
7 => 'http://search.mysql.com/search?site=refman-51&q={FNAME}&lr=lang_en',
8 => 'http://search.mysql.com/search?site=refman-51&q={FNAME}&lr=lang_en',
9 => 'http://search.mysql.com/search?site=refman-51&q={FNAME}&lr=lang_en',
10 => 'http://dev.mysql.com/doc/refman/5.1/en/non-typed-operators.html',
11 => 'http://dev.mysql.com/doc/refman/5.1/en/non-typed-operators.html',
12 => 'http://dev.mysql.com/doc/refman/5.1/en/control-flow-functions.html',
13 => 'http://dev.mysql.com/doc/refman/5.1/en/string-functions.html',
14 => 'http://dev.mysql.com/doc/refman/5.1/en/string-functions.html',
15 => 'http://dev.mysql.com/doc/refman/5.1/en/numeric-functions.html',
16 => 'http://dev.mysql.com/doc/refman/5.1/en/numeric-functions.html',
17 => 'http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html',
18 => 'http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html',
19 => 'http://dev.mysql.com/doc/refman/5.1/en/comparison-operators.html',
20 => 'http://dev.mysql.com/doc/refman/5.1/en/comparison-operators.html',
21 => 'http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html',
22 => 'http://dev.mysql.com/doc/refman/5.1/en/group-by-functions-and-modifiers.html',
23 => 'http://dev.mysql.com/doc/refman/5.1/en/information-functions.html',
24 => 'http://dev.mysql.com/doc/refman/5.1/en/information-functions.html',
25 => 'http://dev.mysql.com/doc/refman/5.1/en/func-op-summary-ref.html',
26 => 'http://dev.mysql.com/doc/refman/5.1/en/func-op-summary-ref.html',
27 => 'http://dev.mysql.com/doc/refman/5.1/en/analysing-spatial-information.html',
),
'OOLANG' => false,
'OBJECT_SPLITTERS' => array(
),
'REGEXPS' => array(
),
'STRICT_MODE_APPLIES' => GESHI_NEVER,
'SCRIPT_DELIMITERS' => array(
),
'HIGHLIGHT_STRICT_BLOCK' => array(
),
'TAB_WIDTH' => 4,
'PARSER_CONTROL' => array(
'KEYWORDS' => array(
2 => array(
'DISALLOWED_AFTER' => '(?![\(\w])'
),
5 => array(
'DISALLOWED_AFTER' => '(?![\(\w])'
),
7 => array(
'DISALLOWED_AFTER' => '(?![\(\w])'
),
9 => array(
'DISALLOWED_AFTER' => '(?![\(\w])'
),
11 => array(
'DISALLOWED_AFTER' => '(?![\(\w])'
),
14 => array(
'DISALLOWED_AFTER' => '(?=\()'
),
16 => array(
'DISALLOWED_AFTER' => '(?=\()'
),
18 => array(
'DISALLOWED_AFTER' => '(?=\()'
),
20 => array(
'DISALLOWED_AFTER' => '(?=\()'
),
24 => array(
'DISALLOWED_AFTER' => '(?=\()'
),
26 => array(
'DISALLOWED_AFTER' => '(?=\()'
)
)
)
);
?>
mysql.php --------- Author: Marjolein Katsma (marjolein.is.back@gmail.com) Copyright: (c) 2008 Marjolein Katsma (http://blog.marjoleinkatsma.com/) Release Version: 1.0.8.3 Date Started: 2008-12-12
MySQL language file for GeSHi.
Based on original MySQL language file by Carl Fürstenberg (2004); brought up-to-date for current MySQL versions, and with more classes for different types of keywords; several minor errors were corrected as well.
Some "classes" have two groups here: this is to allow for the fact that some keywords in MySQL have a double function: many of those are either a function (must be immediately followed by an opening bracket) or some other keyword: so they can be distinguished by the presence (or not) of that opening bracket. (An immediately following opening bracket is a default rule for functions in MySQL, though this may be overridden; because it's only a default, we use a regex lookahead only where necessary to distinguish homonyms, not generally to match any function.) Other keywords with double usage cannot be distinguished and are classified in the "Mix" category.
This file is part of GeSHi.
GeSHi is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
GeSHi is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with GeSHi; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA