syntax_files/sql.micro

   1 syntax "SQL" "\.sql$" "sqliterc$"
   2
   3 color cyan (i) "\b(ALL|ASC|AS|ALTER|AND|ADD|AUTO_INCREMENT)\b"
   4 color cyan (i) "\b(BETWEEN|BINARY|BOTH|BY|BOOLEAN)\b"
   5 color cyan (i) "\b(CHANGE|CHECK|COLUMNS|COLUMN|CROSS|CREATE)\b"
   6 color cyan (i) "\b(DATABASES|DATABASE|DATA|DELAYED|DESCRIBE|DESC|DISTINCT|DELETE|DROP|DEFAULT)\b"
   7 color cyan (i) "\b(ENCLOSED|ESCAPED|EXISTS|EXPLAIN)\b"
   8 color cyan (i) "\b(FIELDS|FIELD|FLUSH|FOR|FOREIGN|FUNCTION|FROM)\b"
   9 color cyan (i) "\b(GROUP|GRANT|HAVING)\b"
  10 color cyan (i) "\b(IGNORE|INDEX|INFILE|INSERT|INNER|INTO|IDENTIFIED|IN|IS|IF)\b"
  11 color cyan (i) "\b(JOIN|KEYS|KILL|KEY)\b"
  12 color cyan (i) "\b(LEADING|LIKE|LIMIT|LINES|LOAD|LOCAL|LOCK|LOW_PRIORITY|LEFT|LANGUAGE)\b"
  13 color cyan (i) "\b(MODIFY|NATURAL|NOT|NULL|NEXTVAL)\b"
  14 color cyan (i) "\b(OPTIMIZE|OPTION|OPTIONALLY|ORDER|OUTFILE|OR|OUTER|ON)\b"
  15 color cyan (i) "\b(PROCEDURE|PROCEDURAL|PRIMARY)\b"
  16 color cyan (i) "\b(READ|REFERENCES|REGEXP|RENAME|REPLACE|RETURN|REVOKE|RLIKE|RIGHT)\b"
  17 color cyan (i) "\b(SHOW|SONAME|STATUS|STRAIGHT_JOIN|SELECT|SETVAL|SET)\b"
  18 color cyan (i) "\b(TABLES|TERMINATED|TO|TRAILING|TRUNCATE|TABLE|TEMPORARY|TRIGGER|TRUSTED)\b"
  19 color cyan (i) "\b(UNIQUE|UNLOCK|USE|USING|UPDATE|VALUES|VARIABLES|VIEW)\b"
  20 color cyan (i) "\b(WITH|WRITE|WHERE|ZEROFILL|TYPE|XOR)\b"
  21 color green     "\b(VARCHAR|TINYINT|TEXT|DATE|SMALLINT|MEDIUMINT|INT|INTEGER|BIGINT|FLOAT|DOUBLE|DECIMAL|DATETIME|TIMESTAMP|TIME|YEAR|UNSIGNED|CHAR|TINYBLOB|TINYTEXT|BLOB|MEDIUMBLOB|MEDIUMTEXT|LONGBLOB|LONGTEXT|ENUM|BOOL|BINARY|VARBINARY)\b"
  22
  23 # SQLite meta commands
  24 color cyan (i) "\.\b(databases|dump|echo|exit|explain|header(s)?|help)\b"
  25 color cyan (i) "\.\b(import|indices|mode|nullvalue|output|prompt|quit|read)\b"
  26 color cyan (i) "\.\b(schema|separator|show|tables|timeout|width)\b"
  27 color brightcyan  "\b(ON|OFF)\b"
  28
  29 color blue   "\b([0-9]+)\b"
  30 color yellow ""(\\.|[^"])*"|'(\\.|[^'])*'"
  31 color yellow   "`(\\.|[^\\`])*`"
  32 color brightblack  "\-\-.*$"
  33 color ,green "[[:space:]]+$"
  34 color ,red "    + +| +  +"