5 <title>SQL Mode for CodeMirror</title>
6 <link rel="stylesheet" href="../../lib/codemirror.css" />
7 <script src="../../lib/codemirror.js"></script>
8 <script src="sql.js"></script>
11 border-top: 1px solid black;
12 border-bottom: 1px solid black;
15 <link rel="stylesheet" href="../../doc/docs.css">
17 var init = function() {
18 var mime = 'text/x-mariadb';
21 if (window.location.href.indexOf('mime=') > -1) {
22 mime = window.location.href.substr(window.location.href.indexOf('mime=') + 5);
25 window.editor = CodeMirror.fromTextArea(document.getElementById('code'), {
36 <body onload="init();">
37 <h1>SQL Mode for CodeMirror</h1>
39 <textarea id="code" name="code">-- SQL Mode for CodeMirror
40 SELECT SQL_NO_CACHE DISTINCT
41 @var1 AS `val1`, @'val2', @global.'sql_mode',
42 1.1 AS `float_val`, .14 AS `another_float`, 0.09e3 AS `int_with_esp`,
43 0xFA5 AS `hex`, x'fa5' AS `hex2`, 0b101 AS `bin`, b'101' AS `bin2`,
44 DATE '1994-01-01' AS `sql_date`, { T "1994-01-01" } AS `odbc_date`,
45 'my string', _utf8'your string', N'her string',
48 -- space needed after '--'
55 <p><strong>MIME types defined:</strong>
56 <code><a href="?mime=text/x-sql">text/x-sql</a></code>,
57 <code><a href="?mime=text/x-mysql">text/x-mysql</a></code>,
58 <code><a href="?mime=text/x-mariadb">text/x-mariadb</a></code>,
59 <code><a href="?mime=text/x-cassandra">text/x-cassandra</a></code>,
60 <code><a href="?mime=text/x-plsql">text/x-plsql</a></code>.
63 <strong>Tests:</strong>
64 <a href="../../test/index.html#sql_*">normal</a>,
65 <a href="../../test/index.html#verbose,sql_*">verbose</a>.