<!doctype html>

<title>CodeMirror: SQL Mode for CodeMirror</title> <meta charset=“utf-8”/> <link rel=stylesheet href=“../../doc/docs.css”>

<link rel=“stylesheet” href=“../../lib/codemirror.css” /> <script src=“../../lib/codemirror.js”></script> <script src=“sql.js”></script> <link rel=“stylesheet” href=“../../addon/hint/show-hint.css” /> <script src=“../../addon/hint/show-hint.js”></script> <script src=“../../addon/hint/sql-hint.js”></script> <style> .CodeMirror {

border-top: 1px solid black;
border-bottom: 1px solid black;

}

</style>

<div id=nav>

<a href="http://codemirror.net"><h1>CodeMirror</h1><img id=logo src="../../doc/logo.png"></a>

<ul>
  <li><a href="../../index.html">Home</a>
  <li><a href="../../doc/manual.html">Manual</a>
  <li><a href="https://github.com/codemirror/codemirror">Code</a>
</ul>
<ul>
  <li><a href="../index.html">Language modes</a>
  <li><a class=active href="#">SQL Mode for CodeMirror</a>
</ul>

</div>

<article> <h2>SQL Mode for CodeMirror</h2> <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>,
    <code><a href="?mime=text/x-mssql">text/x-mssql</a></code>,
    <code><a href="?mime=text/x-hive">text/x-hive</a></code>.
</p>

<script> window.onload = 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,
  extraKeys: {"Ctrl-Space": "autocomplete"},
  hintOptions: {tables: {
    users: {name: null, score: null, birthDate: null},
    countries: {name: null, population: null, size: null}
  }}
});

}; </script>

</article>