index.html
68 lines
| 2.2 KiB
| text/html
|
HtmlLexer
| r4026 | <!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> | ||||
