SQL
sql
string
"
\("\|\n\)
SQL comment
--
\n
jcomment
/\*
\*/
keywords
\b\(CREATE\|TABLE\|INDEX\|KEY\|INSERT\|UPDATE\|DELETE\|DROP\|SELECT\|FROM\|IN\|BETWEEN\|COUNT\|MIN\|MAX\|AVG\|DISTINCT\|create\|table\|index\|key\|insert\|update\|delete\|drop\|select\|from\|in\|between\|count\|min\|max\|avg\|distinct\|\)\b
datatypes
\b\(TINYINT\|SMALLINT\|MEDIUMINT\|INT\|BIGINT\|DATE\|TIME\|TIMESTAMP\|DATETIME\|FLOAT\|VARCHAR2\|DOUBLE\|DECIMAL\|ENUM\|CHAR\|VARCHAR\|TEXT\|BLOB\|tinyint\|smallint\|mediumint\|int\|bigint\|date\|time\|timestamp\|datetime\|float\|varchar2\|double\|decimal\|enum\|char\|varchar\|text\|blob\)\b
modifiers
\b\(UNSIGNED\|NOT\|NULL\|PRIMARY\|AUTO_INCREMENT\|unsigned\|not\|null\|primary\|auto_increment\)\b
operators
\b(<<\|>>\|<\|>\|!\|~\|||\|&&\)\b