|
|
<!doctype html>
|
|
|
<html>
|
|
|
<head>
|
|
|
<meta charset="utf-8">
|
|
|
<title>SQL Mode for CodeMirror</title>
|
|
|
<link rel="stylesheet" href="../../lib/codemirror.css" />
|
|
|
<script src="../../lib/codemirror.js"></script>
|
|
|
<script src="sql.js"></script>
|
|
|
<style>
|
|
|
.CodeMirror {
|
|
|
border-top: 1px solid black;
|
|
|
border-bottom: 1px solid black;
|
|
|
}
|
|
|
</style>
|
|
|
<link rel="stylesheet" href="../../doc/docs.css">
|
|
|
<script>
|
|
|
var init = function() {
|
|
|
var mime = 'text/x-mariadb';
|
|
|
|
|
|
// get mime type
|
|
|
if (window.location.href.indexOf('mime=') > -1) {
|
|
|
mime = window.location.href.substr(window.location.href.indexOf('mime=') + 5);
|
|
|
}
|
|
|
|
|
|
window.editor = CodeMirror.fromTextArea(document.getElementById('code'), {
|
|
|
mode: mime,
|
|
|
indentWithTabs: true,
|
|
|
smartIndent: true,
|
|
|
lineNumbers: true,
|
|
|
matchBrackets : true,
|
|
|
autofocus: true
|
|
|
});
|
|
|
};
|
|
|
</script>
|
|
|
</head>
|
|
|
<body onload="init();">
|
|
|
<h1>SQL Mode for CodeMirror</h1>
|
|
|
<form>
|
|
|
<textarea id="code" name="code">-- SQL Mode for CodeMirror
|
|
|
SELECT SQL_NO_CACHE DISTINCT
|
|
|
@var1 AS `val1`, @'val2', @global.'sql_mode',
|
|
|
1.1 AS `float_val`, .14 AS `another_float`, 0.09e3 AS `int_with_esp`,
|
|
|
0xFA5 AS `hex`, x'fa5' AS `hex2`, 0b101 AS `bin`, b'101' AS `bin2`,
|
|
|
DATE '1994-01-01' AS `sql_date`, { T "1994-01-01" } AS `odbc_date`,
|
|
|
'my string', _utf8'your string', N'her string',
|
|
|
TRUE, FALSE, UNKNOWN
|
|
|
FROM DUAL
|
|
|
-- space needed after '--'
|
|
|
# 1 line comment
|
|
|
/* multiline
|
|
|
comment! */
|
|
|
LIMIT 1 OFFSET 0;
|
|
|
</textarea>
|
|
|
</form>
|
|
|
<p><strong>MIME types defined:</strong>
|
|
|
<code><a href="?mime=text/x-sql">text/x-sql</a></code>,
|
|
|
<code><a href="?mime=text/x-mysql">text/x-mysql</a></code>,
|
|
|
<code><a href="?mime=text/x-mariadb">text/x-mariadb</a></code>,
|
|
|
<code><a href="?mime=text/x-cassandra">text/x-cassandra</a></code>,
|
|
|
<code><a href="?mime=text/x-plsql">text/x-plsql</a></code>.
|
|
|
</p>
|
|
|
<p>
|
|
|
<strong>Tests:</strong>
|
|
|
<a href="../../test/index.html#sql_*">normal</a>,
|
|
|
<a href="../../test/index.html#verbose,sql_*">verbose</a>.
|
|
|
</p>
|
|
|
</body>
|
|
|
</html>
|
|
|
|
