aboutsummaryrefslogtreecommitdiff
path: root/imports/codemirror/mode/mysql/index.html
diff options
context:
space:
mode:
Diffstat (limited to 'imports/codemirror/mode/mysql/index.html')
-rw-r--r--imports/codemirror/mode/mysql/index.html41
1 files changed, 41 insertions, 0 deletions
diff --git a/imports/codemirror/mode/mysql/index.html b/imports/codemirror/mode/mysql/index.html
new file mode 100644
index 00000000..006918c0
--- /dev/null
+++ b/imports/codemirror/mode/mysql/index.html
@@ -0,0 +1,41 @@
1<!doctype html>
2<html>
3 <head>
4 <title>CodeMirror: MySQL mode</title>
5 <link rel="stylesheet" href="../../lib/codemirror.css">
6 <script src="../../lib/codemirror.js"></script>
7 <script src="mysql.js"></script>
8 <style>.CodeMirror {border-top: 1px solid black; border-bottom: 1px solid black;}</style>
9 <link rel="stylesheet" href="../../doc/docs.css">
10 </head>
11 <body>
12 <h1>CodeMirror: MySQL mode</h1>
13 <form><textarea id="code" name="code">
14-- Comment for the code
15-- MySQL Mode for CodeMirror2 by MySQLTools http://github.com/partydroid/MySQL-Tools
16SELECT UNIQUE `var1` as `variable`,
17 MAX(`var5`) as `max`,
18 MIN(`var5`) as `min`,
19 STDEV(`var5`) as `dev`
20FROM `table`
21
22LEFT JOIN `table2` ON `var2` = `variable`
23
24ORDER BY `var3` DESC
25GROUP BY `groupvar`
26
27LIMIT 0,30;
28
29</textarea></form>
30 <script>
31 var editor = CodeMirror.fromTextArea(document.getElementById("code"), {
32 mode: "text/x-mysql",
33 tabMode: "indent",
34 matchBrackets: true
35 });
36 </script>
37
38 <p><strong>MIME types defined:</strong> <code>text/x-mysql</code>.</p>
39
40 </body>
41</html>