JGCSCS
4
MySQL (fast)
*.sql
JGsoft
support@editpadpro.com
http://www.editpadpro.com
http://www.mysql.org
TRUE
#

1
Fast MySQL syntax coloring.  Ignores multi-line comments, and doesn't allow strings to span across lines.  Use this scheme when working with large SQL files (such as those created by mysqldump) for a dramatic increase in performance.  This scheme only parses the visible portion of the file.
2
-- MySQL
select count(*) from sometable where somefield = 'test';
0
TRUE
9
Keyword

\b(?:ADD|AFTER|ALL|ALTER|AND|AUTO_INCREMENT|AVG_ROW_LENGTH|BETWEEN|BIGINT|BINARY|BLOB|BY|CHANGE|CHAR|CHECK(?:SUM)?|COLUMNS|COMMENT|CONSTRAINT|CREATE|CURRENT_DATE|CURRENT_TIME(?:STAMP)?|DATA(?:BASES?)?|DATE(?:TIME)?|DECIMAL|DEFAULT|DELAY_KEY_WRITE|DELETE|DESC(?:RIBE)?|DOUBLE|DROP|ENUM|EXPLAIN|FIELDS|FIRST|FLOAT|FLUSH|FOREIGN|FROM|FUNCTION|GRANTS?|GROUP|HAVING|IN(?:DEX)?|INSERT(?:_ID)?|INT(?:EGER|O)?|IS|KEY|KILL|LAST_INSERT_ID|LIKE|LOAD|LOCK|LONGBLOB|LONGTEXT|MAX_ROWS|MEDIUMBLOB|MEDIUMINT|MEDIUMTEXT|MIN_ROWS|MODIFY|NOT|NULL|ON|OPTIMIZE|OPTION|OR(?:DER)?|PACK_KEYS|PASSWORD|PRIMARY|PROCESSLIST|REFERENCES|REGEXP|RENAME|REPLACE|REVOKE|RLIKE|SELECT|SET|SHOW|SMALLINT|STATUS|TABLES?|TEMPORARY|TEXT|TIME(?:STAMP)?|TINYBLOB|TINYINT|TINYTEXT|TO|TYPE|UNIQUE|UNLOCK|UNSIGNED|UPDATE|USE|VALUES|VARCHAR|WHERE|WITH|YEAR)\b
TRUE
FALSE
7
0


0
FALSE
Functions

\b(?:ABS|ACOS|ADDDATE|ASCII|ASIN|ATAN2?|AVG|BENCHMARK|BIN|BIT_AND|BIT_COUNT|BIT_OR|CEILING|CHAR_LENGTH|CHARACTER_LENGTH|COALESCE|CONCAT|CONV|COS|COT|COUNT|CURDATE|CURTIME|DATABASE|DATE_ADD|DATE_FORMAT|DATE_SUB|DAYNAME|DAYOFMONTH|DAYOFWEEK|DAYOFYEAR|DECODE|DEGREES|ELT|ENCODE|ENCRYPT|EXP(?:ORT_SET)?|EXTRACT|FIELD|FIND_IN_SET|FLOOR|FORMAT|FROM_DAYS|FROM_UNIXTIME|GET_LOCK|GREATEST|HEX|HOUR|IF(?:NULL)?|INSTR|INTERVAL|ISNULL|LAST_INSERT_ID|LCASE|LEAST|LEFT|LENGTH|LOAD_FILE|LOCATE|LOG(?:10)?|LOWER|LPAD|LTRIM|MAKE_SET|MAX|MD5|MID|MIN(?:UTE)?|MOD|MONTH(?:NAME)?|NOW|OCT(?:ET_LENGTH)?|PASSWORD|PERIOD_ADD|PERIOD_DIFF|PI|POSITION|POW(?:ER)?|QUARTER|RADIANS|RAND|RELEASE_LOCK|REPEAT|REPLACE|REVERSE|RIGHT|ROUND|RPAD|RTRIM|SEC_TO_TIME|SECOND|SESSION_USER|SIGN|SIN|SOUNDEX|SPACE|SQRT|STD(?:DEV)?|STRCMP|SUBDATE|SUBSTRING(?:_INDEX)?|SUM|SYSDATE|SYSTEM_USER|TAN|TIME_FORMAT|TIME_TO_SEC|TO_DAYS|TRIM|TRUNCATE|UCASE|UNIX_TIMESTAMP|UPPER|USER|VERSION|WEEK(?:DAY)?|YEAR)\b
TRUE
FALSE
8
0


0
FALSE
Integer or float

\b[0-9]++(\.[0-9]++)?([eE][-+]?+[0-9]++)?\b
FALSE
FALSE
10
0


0
FALSE
Single-line comment

--(?: .*+|$)
FALSE
FALSE
5
0


0
TRUE
Single-line comment

#.*+
FALSE
FALSE
5
0


0
TRUE
Single-quoted string

'[^'\\\r\n]*+(?:\\(?:.|$)[^'\\\r\n]*+)*+'?
FALSE
FALSE
9
0


0
FALSE
Double-quoted string

"[^"\\\r\n]*+(?:\\(?:.|$)[^"\\\r\n]*+)*+"?
FALSE
FALSE
9
0


2
FALSE
Brackets

[()]++
FALSE
FALSE
17
0


0
FALSE
Operator

[-+*/=<>]++
FALSE
FALSE
13
0


0
FALSE
5
(
)
TRUE
3
[
]
TRUE
3
{
}
TRUE
3
"
"
FALSE
2
'
'
FALSE
2
0