Project

General

Profile

Statistics
| Revision:

root / trunk / scripts / codemirror / mode / mysql / index.html @ 221

History | View | Annotate | Download (1.11 KB)

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
16
SELECT  UNIQUE `var1` as `variable`,
17
        MAX(`var5`) as `max`,
18
        MIN(`var5`) as `min`,
19
        STDEV(`var5`) as `dev`
20
FROM `table`
21

    
22
LEFT JOIN `table2` ON `var2` = `variable`
23

    
24
ORDER BY `var3` DESC
25
GROUP BY `groupvar`
26

    
27
LIMIT 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>