basis/xmode/modes/mysql.xml

   1 <?xml version="1.0"?>
   2
   3 <!DOCTYPE MODE SYSTEM "xmode.dtd">
   4
   5 <MODE>
   6         <PROPS>
   7                 <PROPERTY NAME="commentStart" VALUE="/*" />
   8                 <PROPERTY NAME="commentEnd" VALUE="*/" />
   9                 <PROPERTY NAME="lineComment" VALUE="--" />
  10         </PROPS>
  11         <RULES IGNORE_CASE="TRUE" HIGHLIGHT_DIGITS="TRUE">
  12                 <SPAN TYPE="COMMENT1">
  13                         <BEGIN>/*</BEGIN>
  14                         <END>*/</END>
  15                 </SPAN>
  16                 <SPAN TYPE="LITERAL1" ESCAPE="\">
  17                         <BEGIN>"</BEGIN>
  18                         <END>"</END>
  19                 </SPAN>
  20                 <SPAN TYPE="LITERAL1" ESCAPE="\">
  21                         <BEGIN>'</BEGIN>
  22                         <END>'</END>
  23                 </SPAN>
  24
  25                 <EOL_SPAN TYPE="COMMENT2">--</EOL_SPAN>
  26                 <EOL_SPAN TYPE="COMMENT2">#</EOL_SPAN>
  27
  28                 <KEYWORDS>
  29
  30                         <KEYWORD1>ADD</KEYWORD1>
  31                         <KEYWORD1>ALL</KEYWORD1>
  32                         <KEYWORD1>ALTER</KEYWORD1>
  33                         <KEYWORD1>ANALYZE</KEYWORD1>
  34                         <KEYWORD1>AND</KEYWORD1>
  35                         <KEYWORD1>AS</KEYWORD1>
  36                         <KEYWORD1>ASC</KEYWORD1>
  37                         <KEYWORD1>ASENSITIVE</KEYWORD1>
  38                         <KEYWORD1>BEFORE</KEYWORD1>
  39                         <KEYWORD1>BETWEEN</KEYWORD1>
  40                         <KEYWORD1>BIGINT</KEYWORD1>
  41                         <KEYWORD1>BINARY</KEYWORD1>
  42                         <KEYWORD1>BLOB</KEYWORD1>
  43                         <KEYWORD1>BOTH</KEYWORD1>
  44                         <KEYWORD1>BY</KEYWORD1>
  45                         <KEYWORD1>CALL</KEYWORD1>
  46                         <KEYWORD1>CASCADE</KEYWORD1>
  47                         <KEYWORD1>CASE</KEYWORD1>
  48                         <KEYWORD1>CHANGE</KEYWORD1>
  49                         <KEYWORD1>CHAR</KEYWORD1>
  50                         <KEYWORD1>CHARACTER</KEYWORD1>
  51                         <KEYWORD1>CHECK</KEYWORD1>
  52                         <KEYWORD1>COLLATE</KEYWORD1>
  53                         <KEYWORD1>COLUMN</KEYWORD1>
  54                         <KEYWORD1>CONDITION</KEYWORD1>
  55                         <KEYWORD1>CONNECTION</KEYWORD1>
  56                         <KEYWORD1>CONSTRAINT</KEYWORD1>
  57                         <KEYWORD1>CONTINUE</KEYWORD1>
  58                         <KEYWORD1>CONVERT</KEYWORD1>
  59                         <KEYWORD1>CREATE</KEYWORD1>
  60                         <KEYWORD1>CROSS</KEYWORD1>
  61                         <KEYWORD1>CURRENT_DATE</KEYWORD1>
  62                         <KEYWORD1>CURRENT_TIME</KEYWORD1>
  63                         <KEYWORD1>CURRENT_TIMESTAMP</KEYWORD1>
  64                         <KEYWORD1>CURRENT_USER</KEYWORD1>
  65                         <KEYWORD1>CURSOR</KEYWORD1>
  66                         <KEYWORD1>DATABASE</KEYWORD1>
  67                         <KEYWORD1>DATABASES</KEYWORD1>
  68                         <KEYWORD1>DAY_HOUR</KEYWORD1>
  69                         <KEYWORD1>DAY_MICROSECOND</KEYWORD1>
  70                         <KEYWORD1>DAY_MINUTE</KEYWORD1>
  71                         <KEYWORD1>DAY_SECOND</KEYWORD1>
  72                         <KEYWORD1>DEC</KEYWORD1>
  73                         <KEYWORD1>DECIMAL</KEYWORD1>
  74                         <KEYWORD1>DECLARE</KEYWORD1>
  75                         <KEYWORD1>DEFAULT</KEYWORD1>
  76                         <KEYWORD1>DELAYED</KEYWORD1>
  77                         <KEYWORD1>DELETE</KEYWORD1>
  78                         <KEYWORD1>DESC</KEYWORD1>
  79                         <KEYWORD1>DESCRIBE</KEYWORD1>
  80                         <KEYWORD1>DETERMINISTIC</KEYWORD1>
  81                         <KEYWORD1>DISTINCT</KEYWORD1>
  82                         <KEYWORD1>DISTINCTROW</KEYWORD1>
  83                         <KEYWORD1>DIV</KEYWORD1>
  84                         <KEYWORD1>DOUBLE</KEYWORD1>
  85                         <KEYWORD1>DROP</KEYWORD1>
  86                         <KEYWORD1>DUAL</KEYWORD1>
  87                         <KEYWORD1>EACH</KEYWORD1>
  88                         <KEYWORD1>ELSE</KEYWORD1>
  89                         <KEYWORD1>ELSEIF</KEYWORD1>
  90                         <KEYWORD1>ENCLOSED</KEYWORD1>
  91                         <KEYWORD1>ESCAPED</KEYWORD1>
  92                         <KEYWORD1>EXISTS</KEYWORD1>
  93                         <KEYWORD1>EXIT</KEYWORD1>
  94                         <KEYWORD1>EXPLAIN</KEYWORD1>
  95                         <KEYWORD1>FALSE</KEYWORD1>
  96                         <KEYWORD1>FETCH</KEYWORD1>
  97                         <KEYWORD1>FLOAT</KEYWORD1>
  98                         <KEYWORD1>FOR</KEYWORD1>
  99                         <KEYWORD1>FORCE</KEYWORD1>
 100                         <KEYWORD1>FOREIGN</KEYWORD1>
 101                         <KEYWORD1>FROM</KEYWORD1>
 102                         <KEYWORD1>FULLTEXT</KEYWORD1>
 103                         <KEYWORD1>GOTO</KEYWORD1>
 104                         <KEYWORD1>GRANT</KEYWORD1>
 105                         <KEYWORD1>GROUP</KEYWORD1>
 106                         <KEYWORD1>HAVING</KEYWORD1>
 107                         <KEYWORD1>HIGH_PRIORITY</KEYWORD1>
 108                         <KEYWORD1>HOUR_MICROSECOND</KEYWORD1>
 109                         <KEYWORD1>HOUR_MINUTE</KEYWORD1>
 110                         <KEYWORD1>HOUR_SECOND</KEYWORD1>
 111                         <KEYWORD1>IF</KEYWORD1>
 112                         <KEYWORD1>IGNORE</KEYWORD1>
 113                         <KEYWORD1>IN</KEYWORD1>
 114                         <KEYWORD1>INDEX</KEYWORD1>
 115                         <KEYWORD1>INFILE</KEYWORD1>
 116                         <KEYWORD1>INNER</KEYWORD1>
 117                         <KEYWORD1>INOUT</KEYWORD1>
 118                         <KEYWORD1>INSENSITIVE</KEYWORD1>
 119                         <KEYWORD1>INSERT</KEYWORD1>
 120                         <KEYWORD1>INT</KEYWORD1>
 121                         <KEYWORD1>INTEGER</KEYWORD1>
 122                         <KEYWORD1>INTERVAL</KEYWORD1>
 123                         <KEYWORD1>INTO</KEYWORD1>
 124                         <KEYWORD1>IS</KEYWORD1>
 125                         <KEYWORD1>ITERATE</KEYWORD1>
 126                         <KEYWORD1>JOIN</KEYWORD1>
 127                         <KEYWORD1>KEY</KEYWORD1>
 128                         <KEYWORD1>KEYS</KEYWORD1>
 129                         <KEYWORD1>KILL</KEYWORD1>
 130                         <KEYWORD1>LEADING</KEYWORD1>
 131                         <KEYWORD1>LEAVE</KEYWORD1>
 132                         <KEYWORD1>LEFT</KEYWORD1>
 133                         <KEYWORD1>LIKE</KEYWORD1>
 134                         <KEYWORD1>LIMIT</KEYWORD1>
 135                         <KEYWORD1>LINES</KEYWORD1>
 136                         <KEYWORD1>LOAD</KEYWORD1>
 137                         <KEYWORD1>LOCALTIME</KEYWORD1>
 138                         <KEYWORD1>LOCALTIMESTAMP</KEYWORD1>
 139                         <KEYWORD1>LOCK</KEYWORD1>
 140                         <KEYWORD1>LONG</KEYWORD1>
 141                         <KEYWORD1>LONGBLOB</KEYWORD1>
 142                         <KEYWORD1>LONGTEXT</KEYWORD1>
 143                         <KEYWORD1>LOOP</KEYWORD1>
 144                         <KEYWORD1>LOW_PRIORITY</KEYWORD1>
 145                         <KEYWORD1>MATCH</KEYWORD1>
 146                         <KEYWORD1>MEDIUMBLOB</KEYWORD1>
 147                         <KEYWORD1>MEDIUMINT</KEYWORD1>
 148                         <KEYWORD1>MEDIUMTEXT</KEYWORD1>
 149                         <KEYWORD1>MIDDLEINT</KEYWORD1>
 150                         <KEYWORD1>MINUTE_MICROSECOND</KEYWORD1>
 151                         <KEYWORD1>MINUTE_SECOND</KEYWORD1>
 152                         <KEYWORD1>MOD</KEYWORD1>
 153                         <KEYWORD1>MODIFIES</KEYWORD1>
 154                         <KEYWORD1>NATURAL</KEYWORD1>
 155                         <KEYWORD1>NOT</KEYWORD1>
 156                         <KEYWORD1>NO_WRITE_TO_BINLOG</KEYWORD1>
 157                         <KEYWORD1>NULL</KEYWORD1>
 158                         <KEYWORD1>NUMERIC</KEYWORD1>
 159                         <KEYWORD1>ON</KEYWORD1>
 160                         <KEYWORD1>OPTIMIZE</KEYWORD1>
 161                         <KEYWORD1>OPTION</KEYWORD1>
 162                         <KEYWORD1>OPTIONALLY</KEYWORD1>
 163                         <KEYWORD1>OR</KEYWORD1>
 164                         <KEYWORD1>ORDER</KEYWORD1>
 165                         <KEYWORD1>OUT</KEYWORD1>
 166                         <KEYWORD1>OUTER</KEYWORD1>
 167                         <KEYWORD1>OUTFILE</KEYWORD1>
 168                         <KEYWORD1>PRECISION</KEYWORD1>
 169                         <KEYWORD1>PRIMARY</KEYWORD1>
 170                         <KEYWORD1>PROCEDURE</KEYWORD1>
 171                         <KEYWORD1>PURGE</KEYWORD1>
 172                         <KEYWORD1>READ</KEYWORD1>
 173                         <KEYWORD1>READS</KEYWORD1>
 174                         <KEYWORD1>REAL</KEYWORD1>
 175                         <KEYWORD1>REFERENCES</KEYWORD1>
 176                         <KEYWORD1>REGEXP</KEYWORD1>
 177                         <KEYWORD1>RENAME</KEYWORD1>
 178                         <KEYWORD1>REPEAT</KEYWORD1>
 179                         <KEYWORD1>REPLACE</KEYWORD1>
 180                         <KEYWORD1>REQUIRE</KEYWORD1>
 181                         <KEYWORD1>RESTRICT</KEYWORD1>
 182                         <KEYWORD1>RETURN</KEYWORD1>
 183                         <KEYWORD1>REVOKE</KEYWORD1>
 184                         <KEYWORD1>RIGHT</KEYWORD1>
 185                         <KEYWORD1>RLIKE</KEYWORD1>
 186                         <KEYWORD1>SCHEMA</KEYWORD1>
 187                         <KEYWORD1>SCHEMAS</KEYWORD1>
 188                         <KEYWORD1>SECOND_MICROSECOND</KEYWORD1>
 189                         <KEYWORD1>SELECT</KEYWORD1>
 190                         <KEYWORD1>SENSITIVE</KEYWORD1>
 191                         <KEYWORD1>SEPARATOR</KEYWORD1>
 192                         <KEYWORD1>SET</KEYWORD1>
 193                         <KEYWORD1>SHOW</KEYWORD1>
 194                         <KEYWORD1>SMALLINT</KEYWORD1>
 195                         <KEYWORD1>SONAME</KEYWORD1>
 196                         <KEYWORD1>SPATIAL</KEYWORD1>
 197                         <KEYWORD1>SPECIFIC</KEYWORD1>
 198                         <KEYWORD1>SQL</KEYWORD1>
 199                         <KEYWORD1>SQLEXCEPTION</KEYWORD1>
 200                         <KEYWORD1>SQLSTATE</KEYWORD1>
 201                         <KEYWORD1>SQLWARNING</KEYWORD1>
 202                         <KEYWORD1>SQL_BIG_RESULT</KEYWORD1>
 203                         <KEYWORD1>SQL_CALC_FOUND_ROWS</KEYWORD1>
 204                         <KEYWORD1>SQL_SMALL_RESULT</KEYWORD1>
 205                         <KEYWORD1>SSL</KEYWORD1>
 206                         <KEYWORD1>STARTING</KEYWORD1>
 207                         <KEYWORD1>STRAIGHT_JOIN</KEYWORD1>
 208                         <KEYWORD1>TABLE</KEYWORD1>
 209                         <KEYWORD1>TERMINATED</KEYWORD1>
 210                         <KEYWORD1>THEN</KEYWORD1>
 211                         <KEYWORD1>TINYBLOB</KEYWORD1>
 212                         <KEYWORD1>TINYINT</KEYWORD1>
 213                         <KEYWORD1>TINYTEXT</KEYWORD1>
 214                         <KEYWORD1>TO</KEYWORD1>
 215                         <KEYWORD1>TRAILING</KEYWORD1>
 216                         <KEYWORD1>TRIGGER</KEYWORD1>
 217                         <KEYWORD1>TRUE</KEYWORD1>
 218                         <KEYWORD1>UNDO</KEYWORD1>
 219                         <KEYWORD1>UNION</KEYWORD1>
 220                         <KEYWORD1>UNIQUE</KEYWORD1>
 221                         <KEYWORD1>UNLOCK</KEYWORD1>
 222                         <KEYWORD1>UNSIGNED</KEYWORD1>
 223                         <KEYWORD1>UPDATE</KEYWORD1>
 224                         <KEYWORD1>USAGE</KEYWORD1>
 225                         <KEYWORD1>USE</KEYWORD1>
 226                         <KEYWORD1>USING</KEYWORD1>
 227                         <KEYWORD1>UTC_DATE</KEYWORD1>
 228                         <KEYWORD1>UTC_TIME</KEYWORD1>
 229                         <KEYWORD1>UTC_TIMESTAMP</KEYWORD1>
 230                         <KEYWORD1>VALUES</KEYWORD1>
 231                         <KEYWORD1>VARBINARY</KEYWORD1>
 232                         <KEYWORD1>VARCHAR</KEYWORD1>
 233                         <KEYWORD1>VARCHARACTER</KEYWORD1>
 234                         <KEYWORD1>VARYING</KEYWORD1>
 235                         <KEYWORD1>WHEN</KEYWORD1>
 236                         <KEYWORD1>WHERE</KEYWORD1>
 237                         <KEYWORD1>WHILE</KEYWORD1>
 238                         <KEYWORD1>WITH</KEYWORD1>
 239                         <KEYWORD1>WRITE</KEYWORD1>
 240                         <KEYWORD1>XOR</KEYWORD1>
 241                         <KEYWORD1>YEAR_MONTH</KEYWORD1>
 242                         <KEYWORD1>ZEROFILL</KEYWORD1>
 243
 244                 </KEYWORDS>
 245         </RULES>
 246 </MODE>
 247