Lines:
1 to 100 of 473
<?php /************************************************************************************* * mysql.php * --------- * Author: Marjolein Katsma (marjolein.is.back@gmail.com) * Copyright: (c) 2008 Marjolein Katsma (http://blog.marjoleinkatsma.com/) * Release Version: 1.0.9.0 * 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','CHANGE','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','PARTITION','PREV','PRIMARY KEY','PRIVILEGES','PROCEDURE', 'PURGE','QUICK','READS SQL DATA','READ','REFERENCES','RELEASE', 'RENAME','REORGANIZE','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',