+<!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>