| 1 |
lars |
1 |
<?xml version="1.0"?>
|
|
|
2 |
<!-- $Id: mysql.xml,v 1.1 2007/06/03 02:35:28 ssttoo Exp $ -->
|
|
|
3 |
|
|
|
4 |
<highlight lang="mysql" case="no">
|
|
|
5 |
|
|
|
6 |
<authors>
|
|
|
7 |
<author name="Andrey Demenev" email="demenev@gmail.com"/>
|
|
|
8 |
</authors>
|
|
|
9 |
|
|
|
10 |
|
|
|
11 |
<default innerClass="code" />
|
|
|
12 |
|
|
|
13 |
<region name="qidentifier" delimClass="quotes" innerClass="identifier"
|
|
|
14 |
start="`" end="`" />
|
|
|
15 |
|
|
|
16 |
<region name="mlcomment" delimClass="comment" innerClass="comment"
|
|
|
17 |
start="\/\*" end="\*\/" />
|
|
|
18 |
|
|
|
19 |
<block name="comment" match="(#|--\s).*" innerClass="comment" />
|
|
|
20 |
|
|
|
21 |
<block name="possiblefunction" match="[a-z_]\w*(?=\s*\()" innerClass="identifier" />
|
|
|
22 |
|
|
|
23 |
<block name="identifier" match="[a-z_]\w*" innerClass="identifier" />
|
|
|
24 |
|
|
|
25 |
<region name="strdouble" delimClass="quotes" innerClass="string"
|
|
|
26 |
start=""" end=""" >
|
|
|
27 |
</region>
|
|
|
28 |
|
|
|
29 |
<region name="brackets" delimClass="brackets" innerClass="code"
|
|
|
30 |
start="\(" end="\)" >
|
|
|
31 |
<contains all="yes"/>
|
|
|
32 |
</region>
|
|
|
33 |
|
|
|
34 |
<region name="strsingle" delimClass="quotes" innerClass="string"
|
|
|
35 |
start="'" end="'" />
|
|
|
36 |
|
|
|
37 |
<block name="escaped" match="\\." innerClass="special" contained="yes">
|
|
|
38 |
<onlyin region="strsingle"/>
|
|
|
39 |
<onlyin region="strdouble"/>
|
|
|
40 |
</block>
|
|
|
41 |
|
|
|
42 |
<block name="exponent"
|
|
|
43 |
match="((\d+|((\d*\.\d+)|(\d+\.\d*)))[eE][+-]?\d+)"
|
|
|
44 |
innerClass="number" />
|
|
|
45 |
|
|
|
46 |
<block name="float" match="(\d*\.\d+)|(\d+\.\d*)" innerClass="number"/>
|
|
|
47 |
|
|
|
48 |
<block name="integer" match="\d+l?|\b0l?\b" innerClass="number" />
|
|
|
49 |
|
|
|
50 |
<block name="hexinteger" match="0[xX][\da-f]+l?" innerClass="number" />
|
|
|
51 |
|
|
|
52 |
<keywords name="reserved" inherits="identifier" innerClass="reserved"
|
|
|
53 |
case="no">
|
|
|
54 |
<keyword match="action" />
|
|
|
55 |
<keyword match="add" />
|
|
|
56 |
<keyword match="aggregate" />
|
|
|
57 |
<keyword match="all" />
|
|
|
58 |
<keyword match="alter" />
|
|
|
59 |
<keyword match="after" />
|
|
|
60 |
<keyword match="and" />
|
|
|
61 |
<keyword match="as" />
|
|
|
62 |
<keyword match="asc" />
|
|
|
63 |
<keyword match="avg" />
|
|
|
64 |
<keyword match="avg_row_length" />
|
|
|
65 |
<keyword match="auto_increment" />
|
|
|
66 |
<keyword match="between" />
|
|
|
67 |
<keyword match="bigint" />
|
|
|
68 |
<keyword match="bit" />
|
|
|
69 |
|
|
|
70 |
<keyword match="binary" />
|
|
|
71 |
<keyword match="blob" />
|
|
|
72 |
<keyword match="bool" />
|
|
|
73 |
<keyword match="both" />
|
|
|
74 |
<keyword match="by" />
|
|
|
75 |
<keyword match="cascade" />
|
|
|
76 |
<keyword match="case" />
|
|
|
77 |
<keyword match="char" />
|
|
|
78 |
<keyword match="character" />
|
|
|
79 |
<keyword match="change" />
|
|
|
80 |
<keyword match="check" />
|
|
|
81 |
<keyword match="checksum" />
|
|
|
82 |
<keyword match="column" />
|
|
|
83 |
<keyword match="columns" />
|
|
|
84 |
<keyword match="comment" />
|
|
|
85 |
<keyword match="constraint" />
|
|
|
86 |
<keyword match="create" />
|
|
|
87 |
|
|
|
88 |
<keyword match="cross" />
|
|
|
89 |
<keyword match="current_date" />
|
|
|
90 |
<keyword match="current_time" />
|
|
|
91 |
<keyword match="current_timestamp" />
|
|
|
92 |
<keyword match="data" />
|
|
|
93 |
<keyword match="database" />
|
|
|
94 |
<keyword match="databases" />
|
|
|
95 |
<keyword match="date" />
|
|
|
96 |
<keyword match="datetime" />
|
|
|
97 |
<keyword match="day" />
|
|
|
98 |
<keyword match="day_hour" />
|
|
|
99 |
<keyword match="day_minute" />
|
|
|
100 |
<keyword match="day_second" />
|
|
|
101 |
<keyword match="dayofmonth" />
|
|
|
102 |
<keyword match="dayofweek" />
|
|
|
103 |
<keyword match="dayofyear" />
|
|
|
104 |
<keyword match="dec" />
|
|
|
105 |
|
|
|
106 |
<keyword match="decimal" />
|
|
|
107 |
<keyword match="default" />
|
|
|
108 |
<keyword match="delayed" />
|
|
|
109 |
<keyword match="delay_key_write" />
|
|
|
110 |
<keyword match="delete" />
|
|
|
111 |
<keyword match="desc" />
|
|
|
112 |
<keyword match="describe" />
|
|
|
113 |
<keyword match="distinct" />
|
|
|
114 |
<keyword match="distinctrow" />
|
|
|
115 |
<keyword match="double" />
|
|
|
116 |
<keyword match="drop" />
|
|
|
117 |
<keyword match="end" />
|
|
|
118 |
<keyword match="else" />
|
|
|
119 |
<keyword match="escape" />
|
|
|
120 |
<keyword match="escaped" />
|
|
|
121 |
<keyword match="enclosed" />
|
|
|
122 |
<keyword match="enum" />
|
|
|
123 |
|
|
|
124 |
<keyword match="explain" />
|
|
|
125 |
<keyword match="exists" />
|
|
|
126 |
<keyword match="fields" />
|
|
|
127 |
<keyword match="file" />
|
|
|
128 |
<keyword match="first" />
|
|
|
129 |
<keyword match="float" />
|
|
|
130 |
<keyword match="float4" />
|
|
|
131 |
<keyword match="float8" />
|
|
|
132 |
<keyword match="flush" />
|
|
|
133 |
<keyword match="foreign" />
|
|
|
134 |
<keyword match="from" />
|
|
|
135 |
<keyword match="for" />
|
|
|
136 |
<keyword match="full" />
|
|
|
137 |
<keyword match="function" />
|
|
|
138 |
<keyword match="global" />
|
|
|
139 |
<keyword match="grant" />
|
|
|
140 |
<keyword match="grants" />
|
|
|
141 |
|
|
|
142 |
<keyword match="group" />
|
|
|
143 |
<keyword match="having" />
|
|
|
144 |
<keyword match="heap" />
|
|
|
145 |
<keyword match="high_priority" />
|
|
|
146 |
<keyword match="hour" />
|
|
|
147 |
<keyword match="hour_minute" />
|
|
|
148 |
<keyword match="hour_second" />
|
|
|
149 |
<keyword match="hosts" />
|
|
|
150 |
<keyword match="identified" />
|
|
|
151 |
<keyword match="ignore" />
|
|
|
152 |
<keyword match="in" />
|
|
|
153 |
<keyword match="index" />
|
|
|
154 |
<keyword match="infile" />
|
|
|
155 |
<keyword match="inner" />
|
|
|
156 |
<keyword match="insert" />
|
|
|
157 |
<keyword match="insert_id" />
|
|
|
158 |
<keyword match="int" />
|
|
|
159 |
|
|
|
160 |
<keyword match="integer" />
|
|
|
161 |
<keyword match="interval" />
|
|
|
162 |
<keyword match="int1" />
|
|
|
163 |
<keyword match="int2" />
|
|
|
164 |
<keyword match="int3" />
|
|
|
165 |
<keyword match="int4" />
|
|
|
166 |
<keyword match="int8" />
|
|
|
167 |
<keyword match="into" />
|
|
|
168 |
<keyword match="if" />
|
|
|
169 |
<keyword match="is" />
|
|
|
170 |
<keyword match="isam" />
|
|
|
171 |
<keyword match="join" />
|
|
|
172 |
<keyword match="key" />
|
|
|
173 |
<keyword match="keys" />
|
|
|
174 |
<keyword match="kill" />
|
|
|
175 |
<keyword match="last_insert_id" />
|
|
|
176 |
<keyword match="leading" />
|
|
|
177 |
|
|
|
178 |
<keyword match="left" />
|
|
|
179 |
<keyword match="length" />
|
|
|
180 |
<keyword match="like" />
|
|
|
181 |
<keyword match="lines" />
|
|
|
182 |
<keyword match="limit" />
|
|
|
183 |
<keyword match="load" />
|
|
|
184 |
<keyword match="local" />
|
|
|
185 |
<keyword match="lock" />
|
|
|
186 |
<keyword match="logs" />
|
|
|
187 |
<keyword match="long" />
|
|
|
188 |
<keyword match="longblob" />
|
|
|
189 |
<keyword match="longtext" />
|
|
|
190 |
<keyword match="low_priority" />
|
|
|
191 |
<keyword match="max" />
|
|
|
192 |
<keyword match="max_rows" />
|
|
|
193 |
<keyword match="match" />
|
|
|
194 |
<keyword match="mediumblob" />
|
|
|
195 |
|
|
|
196 |
<keyword match="mediumtext" />
|
|
|
197 |
<keyword match="mediumint" />
|
|
|
198 |
<keyword match="middleint" />
|
|
|
199 |
<keyword match="min_rows" />
|
|
|
200 |
<keyword match="minute" />
|
|
|
201 |
<keyword match="minute_second" />
|
|
|
202 |
<keyword match="modify" />
|
|
|
203 |
<keyword match="month" />
|
|
|
204 |
<keyword match="monthname" />
|
|
|
205 |
<keyword match="myisam" />
|
|
|
206 |
<keyword match="natural" />
|
|
|
207 |
<keyword match="numeric" />
|
|
|
208 |
<keyword match="no" />
|
|
|
209 |
<keyword match="not" />
|
|
|
210 |
<keyword match="null" />
|
|
|
211 |
<keyword match="on" />
|
|
|
212 |
<keyword match="optimize" />
|
|
|
213 |
|
|
|
214 |
<keyword match="option" />
|
|
|
215 |
<keyword match="optionally" />
|
|
|
216 |
<keyword match="or" />
|
|
|
217 |
<keyword match="order" />
|
|
|
218 |
<keyword match="outer" />
|
|
|
219 |
<keyword match="outfile" />
|
|
|
220 |
<keyword match="pack_keys" />
|
|
|
221 |
<keyword match="partial" />
|
|
|
222 |
<keyword match="password" />
|
|
|
223 |
<keyword match="precision" />
|
|
|
224 |
<keyword match="primary" />
|
|
|
225 |
<keyword match="procedure" />
|
|
|
226 |
<keyword match="process" />
|
|
|
227 |
<keyword match="processlist" />
|
|
|
228 |
<keyword match="privileges" />
|
|
|
229 |
<keyword match="read" />
|
|
|
230 |
<keyword match="real" />
|
|
|
231 |
|
|
|
232 |
<keyword match="references" />
|
|
|
233 |
<keyword match="reload" />
|
|
|
234 |
<keyword match="regexp" />
|
|
|
235 |
<keyword match="rename" />
|
|
|
236 |
<keyword match="replace" />
|
|
|
237 |
<keyword match="restrict" />
|
|
|
238 |
<keyword match="returns" />
|
|
|
239 |
<keyword match="revoke" />
|
|
|
240 |
<keyword match="rlike" />
|
|
|
241 |
<keyword match="row" />
|
|
|
242 |
<keyword match="rows" />
|
|
|
243 |
<keyword match="second" />
|
|
|
244 |
<keyword match="select" />
|
|
|
245 |
<keyword match="set" />
|
|
|
246 |
<keyword match="show" />
|
|
|
247 |
<keyword match="shutdown" />
|
|
|
248 |
<keyword match="smallint" />
|
|
|
249 |
|
|
|
250 |
<keyword match="soname" />
|
|
|
251 |
<keyword match="sql_big_tables" />
|
|
|
252 |
<keyword match="sql_big_selects" />
|
|
|
253 |
<keyword match="sql_low_priority_updates" />
|
|
|
254 |
<keyword match="sql_log_off" />
|
|
|
255 |
<keyword match="sql_log_update" />
|
|
|
256 |
<keyword match="sql_select_limit" />
|
|
|
257 |
<keyword match="sql_small_result" />
|
|
|
258 |
<keyword match="sql_big_result" />
|
|
|
259 |
<keyword match="sql_warnings" />
|
|
|
260 |
<keyword match="straight_join" />
|
|
|
261 |
<keyword match="starting" />
|
|
|
262 |
<keyword match="status" />
|
|
|
263 |
<keyword match="string" />
|
|
|
264 |
<keyword match="table" />
|
|
|
265 |
<keyword match="tables" />
|
|
|
266 |
<keyword match="temporary" />
|
|
|
267 |
|
|
|
268 |
<keyword match="terminated" />
|
|
|
269 |
<keyword match="text" />
|
|
|
270 |
<keyword match="then" />
|
|
|
271 |
<keyword match="time" />
|
|
|
272 |
<keyword match="timestamp" />
|
|
|
273 |
<keyword match="tinyblob" />
|
|
|
274 |
<keyword match="tinytext" />
|
|
|
275 |
<keyword match="tinyint" />
|
|
|
276 |
<keyword match="trailing" />
|
|
|
277 |
<keyword match="to" />
|
|
|
278 |
<keyword match="type" />
|
|
|
279 |
<keyword match="use" />
|
|
|
280 |
<keyword match="using" />
|
|
|
281 |
<keyword match="unique" />
|
|
|
282 |
<keyword match="unlock" />
|
|
|
283 |
<keyword match="unsigned" />
|
|
|
284 |
<keyword match="update" />
|
|
|
285 |
|
|
|
286 |
<keyword match="usage" />
|
|
|
287 |
<keyword match="values" />
|
|
|
288 |
<keyword match="varchar" />
|
|
|
289 |
<keyword match="variables" />
|
|
|
290 |
<keyword match="varying" />
|
|
|
291 |
<keyword match="varbinary" />
|
|
|
292 |
<keyword match="with" />
|
|
|
293 |
<keyword match="write" />
|
|
|
294 |
<keyword match="when" />
|
|
|
295 |
<keyword match="where" />
|
|
|
296 |
<keyword match="year" />
|
|
|
297 |
<keyword match="year_month" />
|
|
|
298 |
<keyword match="zerofill" />
|
|
|
299 |
</keywords>
|
|
|
300 |
|
|
|
301 |
<keywords name="function" inherits="possiblefunction" innerClass="reserved"
|
|
|
302 |
case="no" otherwise="identifier">
|
|
|
303 |
<keyword match="ABS" />
|
|
|
304 |
<keyword match="ACOS" />
|
|
|
305 |
<keyword match="ADDDATE" />
|
|
|
306 |
<keyword match="ASCII" />
|
|
|
307 |
<keyword match="ASIN" />
|
|
|
308 |
<keyword match="ATAN" />
|
|
|
309 |
<keyword match="ATAN2" />
|
|
|
310 |
<keyword match="AVG" />
|
|
|
311 |
<keyword match="BENCHMARK" />
|
|
|
312 |
<keyword match="BIN" />
|
|
|
313 |
<keyword match="CEILING" />
|
|
|
314 |
<keyword match="CHAR" />
|
|
|
315 |
<keyword match="COALESCE" />
|
|
|
316 |
<keyword match="CONCAT" />
|
|
|
317 |
<keyword match="CONV" />
|
|
|
318 |
<keyword match="COS" />
|
|
|
319 |
<keyword match="COT" />
|
|
|
320 |
<keyword match="COUNT" />
|
|
|
321 |
<keyword match="CURDATE" />
|
|
|
322 |
<keyword match="CURTIME" />
|
|
|
323 |
<keyword match="DATABASE" />
|
|
|
324 |
<keyword match="DAYNAME" />
|
|
|
325 |
<keyword match="DAYOFMONTH" />
|
|
|
326 |
<keyword match="DAYOFWEEK" />
|
|
|
327 |
<keyword match="DAYOFYEAR" />
|
|
|
328 |
<keyword match="DECODE" />
|
|
|
329 |
<keyword match="DEGREES" />
|
|
|
330 |
<keyword match="ELT" />
|
|
|
331 |
|
|
|
332 |
<keyword match="ENCODE" />
|
|
|
333 |
<keyword match="ENCRYPT" />
|
|
|
334 |
<keyword match="EXP" />
|
|
|
335 |
<keyword match="EXTRACT" />
|
|
|
336 |
|
|
|
337 |
<keyword match="EXTRACT" />
|
|
|
338 |
<keyword match="FIELD" />
|
|
|
339 |
<keyword match="FLOOR" />
|
|
|
340 |
<keyword match="FORMAT" />
|
|
|
341 |
<keyword match="GREATEST" />
|
|
|
342 |
<keyword match="HEX" />
|
|
|
343 |
<keyword match="HOUR" />
|
|
|
344 |
<keyword match="IF" />
|
|
|
345 |
<keyword match="IFNULL" />
|
|
|
346 |
<keyword match="INSERT" />
|
|
|
347 |
<keyword match="INSTR" />
|
|
|
348 |
<keyword match="INTERVAL" />
|
|
|
349 |
|
|
|
350 |
<keyword match="ISNULL" />
|
|
|
351 |
<keyword match="LCASE" />
|
|
|
352 |
<keyword match="LEAST" />
|
|
|
353 |
<keyword match="LEFT" />
|
|
|
354 |
<keyword match="LENGTH" />
|
|
|
355 |
<keyword match="LOCATE" />
|
|
|
356 |
|
|
|
357 |
<keyword match="LOCATE" />
|
|
|
358 |
<keyword match="LOG" />
|
|
|
359 |
<keyword match="LOG10" />
|
|
|
360 |
<keyword match="LOWER" />
|
|
|
361 |
<keyword match="LPAD" />
|
|
|
362 |
<keyword match="LTRIM" />
|
|
|
363 |
<keyword match="MAX" />
|
|
|
364 |
<keyword match="MD5" />
|
|
|
365 |
<keyword match="MID" />
|
|
|
366 |
<keyword match="MIN" />
|
|
|
367 |
|
|
|
368 |
<keyword match="MINUTE" />
|
|
|
369 |
<keyword match="MOD" />
|
|
|
370 |
<keyword match="MONTH" />
|
|
|
371 |
<keyword match="MONTHNAME" />
|
|
|
372 |
<keyword match="NOW" />
|
|
|
373 |
<keyword match="NULLIF" />
|
|
|
374 |
<keyword match="OCT" />
|
|
|
375 |
<keyword match="ORD" />
|
|
|
376 |
<keyword match="PASSWORD" />
|
|
|
377 |
<keyword match="PI" />
|
|
|
378 |
<keyword match="POSITION" />
|
|
|
379 |
|
|
|
380 |
<keyword match="POW" />
|
|
|
381 |
<keyword match="POWER" />
|
|
|
382 |
<keyword match="prepare" />
|
|
|
383 |
<keyword match="QUARTER" />
|
|
|
384 |
<keyword match="RADIANS" />
|
|
|
385 |
<keyword match="RAND" />
|
|
|
386 |
<keyword match="REPEAT" />
|
|
|
387 |
<keyword match="REPLACE" />
|
|
|
388 |
<keyword match="REVERSE" />
|
|
|
389 |
<keyword match="RIGHT" />
|
|
|
390 |
<keyword match="ROUND" />
|
|
|
391 |
|
|
|
392 |
<keyword match="ROUND" />
|
|
|
393 |
<keyword match="RPAD" />
|
|
|
394 |
|
|
|
395 |
<keyword match="RTRIM" />
|
|
|
396 |
<keyword match="SECOND" />
|
|
|
397 |
<keyword match="SIGN" />
|
|
|
398 |
<keyword match="SIN" />
|
|
|
399 |
<keyword match="SOUNDEX" />
|
|
|
400 |
<keyword match="SPACE" />
|
|
|
401 |
<keyword match="SQRT" />
|
|
|
402 |
<keyword match="STD" />
|
|
|
403 |
<keyword match="STDDEV" />
|
|
|
404 |
<keyword match="STRCMP" />
|
|
|
405 |
<keyword match="SUBDATE" />
|
|
|
406 |
<keyword match="SUBSTRING" />
|
|
|
407 |
|
|
|
408 |
<keyword match="SUBSTRING" />
|
|
|
409 |
<keyword match="SUM" />
|
|
|
410 |
<keyword match="SYSDATE" />
|
|
|
411 |
<keyword match="TAN" />
|
|
|
412 |
|
|
|
413 |
<keyword match="TRIM" />
|
|
|
414 |
<keyword match="TRUNCATE" />
|
|
|
415 |
<keyword match="UCASE" />
|
|
|
416 |
<keyword match="UPPER" />
|
|
|
417 |
<keyword match="USER" />
|
|
|
418 |
<keyword match="VERSION" />
|
|
|
419 |
<keyword match="WEEK" />
|
|
|
420 |
<keyword match="WEEKDAY" />
|
|
|
421 |
<keyword match="YEAR" />
|
|
|
422 |
</keywords>
|
|
|
423 |
|
|
|
424 |
</highlight>
|