index.html
41 lines
| 1.1 KiB
| text/html
|
HtmlLexer
Matthias BUSSONNIER
|
r8053 | <!doctype html> | ||
<html> | ||||
<head> | ||||
<title>CodeMirror: MySQL mode</title> | ||||
<link rel="stylesheet" href="../../lib/codemirror.css"> | ||||
<script src="../../lib/codemirror.js"></script> | ||||
<script src="mysql.js"></script> | ||||
<style>.CodeMirror {border-top: 1px solid black; border-bottom: 1px solid black;}</style> | ||||
<link rel="stylesheet" href="../../doc/docs.css"> | ||||
</head> | ||||
<body> | ||||
<h1>CodeMirror: MySQL mode</h1> | ||||
<form><textarea id="code" name="code"> | ||||
-- Comment for the code | ||||
-- MySQL Mode for CodeMirror2 by MySQLTools http://github.com/partydroid/MySQL-Tools | ||||
SELECT UNIQUE `var1` as `variable`, | ||||
MAX(`var5`) as `max`, | ||||
MIN(`var5`) as `min`, | ||||
STDEV(`var5`) as `dev` | ||||
FROM `table` | ||||
LEFT JOIN `table2` ON `var2` = `variable` | ||||
ORDER BY `var3` DESC | ||||
GROUP BY `groupvar` | ||||
LIMIT 0,30; | ||||
</textarea></form> | ||||
<script> | ||||
var editor = CodeMirror.fromTextArea(document.getElementById("code"), { | ||||
mode: "text/x-mysql", | ||||
tabMode: "indent", | ||||
matchBrackets: true | ||||
}); | ||||
</script> | ||||
<p><strong>MIME types defined:</strong> <code>text/x-mysql</code>.</p> | ||||
</body> | ||||
</html> | ||||