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