GitHub Viewer
/* description: Parses SQL */
/* :tabSize=4:indentSize=4:noTabs=true: */
%lex
%options case-insensitive
%%
[/][*](.|\n)*?[*][/] /* skip comments */
[-][-]\s.*\n /* skip sql comments */
[#]\s.*\n /* skip sql comments */
\s+ /* skip whitespace */
[$][{](.+?)[}] return 'PLACE_HOLDER'
[`][a-zA-Z0-9_\u0080-\uFFFF]*[`] return 'IDENTIFIER'
[\w]+[\u0080-\uFFFF]+[0-9a-zA-Z_\u0080-\uFFFF]* return 'IDENTIFIER'
[\u0080-\uFFFF][0-9a-zA-Z_\u0080-\uFFFF]* return 'IDENTIFIER'
SELECT return 'SELECT'
ALL return 'ALL'
ANY return 'ANY'
DISTINCT return 'DISTINCT'
DISTINCTROW return 'DISTINCTROW'
HIGH_PRIORITY return 'HIGH_PRIORITY'
MAX_STATEMENT_TIME return 'MAX_STATEMENT_TIME'
STRAIGHT_JOIN return 'STRAIGHT_JOIN'
SQL_SMALL_RESULT return 'SQL_SMALL_RESULT'
SQL_BIG_RESULT return 'SQL_BIG_RESULT'
SQL_BUFFER_RESULT return 'SQL_BUFFER_RESULT'
SQL_CACHE return 'SQL_CACHE'
SQL_NO_CACHE return 'SQL_NO_CACHE'
SQL_CALC_FOUND_ROWS return 'SQL_CALC_FOUND_ROWS'
([a-zA-Z_\u4e00-\u9fa5][a-zA-Z0-9_\u4e00-\u9fa5]*\.){1,2}\* return 'SELECT_EXPR_STAR'
AS return 'AS'
TRUE return 'TRUE'
FALSE return 'FALSE'
NULL return 'NULL'
COLLATE return 'COLLATE'
BINARY return 'BINARY'
ROW return 'ROW'
EXISTS return 'EXISTS'
CASE return 'CASE'
WHEN return 'WHEN'
THEN return 'THEN'
ELSE return 'ELSE'
END return 'END'
DIV return 'DIV'
MOD return 'MOD'
NOT return 'NOT'
BETWEEN return 'BETWEEN'
IN return 'IN'
SOUNDS return 'SOUNDS'
LIKE return 'LIKE'
ESCAPE return 'ESCAPE'
REGEXP return 'REGEXP'
IS return 'IS'
UNKNOWN return 'UNKNOWN'
AND return 'AND'
OR return 'OR'
XOR return 'XOR'
FROM return 'FROM'
PARTITION return 'PARTITION'
USE return 'USE'
INDEX return 'INDEX'
KEY return 'KEY'
FOR return 'FOR'
JOIN return 'JOIN'
ORDER\s+BY return 'ORDER_BY'
GROUP\s+BY return 'GROUP_BY'
IGNORE return 'IGNORE'
FORCE return 'FORCE'
INNER return 'INNER'
CROSS return 'CROSS'
ON return 'ON'
USING return 'USING'
LEFT return 'LEFT'
RIGHT return 'RIGHT'
OUTER return 'OUTER'
NATURAL return 'NATURAL'
WHERE return 'WHERE'
ASC return 'ASC'
DESC return 'DESC'
WITH return 'WITH'
ROLLUP return 'ROLLUP'
HAVING return 'HAVING'
OFFSET return 'OFFSET'
PROCEDURE return 'PROCEDURE'
UPDATE return 'UPDATE'
LOCK return 'LOCK'
SHARE return 'SHARE'
MODE return 'MODE'
OJ return 'OJ'
LIMIT return 'LIMIT'
UNION return 'UNION'
"," return ','
"=" return '='
"(" return '('
")" return ')'
"~" return '~'
"!=" return '!='
"!" return '!'
"|" return '|'
"&" return '&'
"+" return '+'
"-" return '-'
"*" return '*'
"/" return '/'
"%" return '%'
"^" return '^'
">>" return '>>'
">=" return '>='
">" return '>'
"