runtime/syntax/sql.micro

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