12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667 |
- <!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="../../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`,
- 'myString', 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-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>
|