Edit File by line

<!doctype html>

[0] Fix | Delete

[1] Fix | Delete

<title>CodeMirror: SQL Mode for CodeMirror</title>

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

[5] Fix | Delete

[6] Fix | Delete

[7] Fix | Delete

[8] Fix | Delete

[9] Fix | Delete

[10] Fix | Delete

[11] Fix | Delete

<style>

[12] Fix | Delete

.CodeMirror {

[13] Fix | Delete

border-top: 1px solid black;

[14] Fix | Delete

border-bottom: 1px solid black;

[15] Fix | Delete

}

[16] Fix | Delete

</style>

[17] Fix | Delete

[18] Fix | Delete

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

[19] Fix | Delete

[20] Fix | Delete

<ul>

[21] Fix | Delete

[22] Fix | Delete

<li><a href="../../doc/manual.html">Manual</a>

[23] Fix | Delete

[24] Fix | Delete

</ul>

[25] Fix | Delete

<ul>

[26] Fix | Delete

<li><a href="../index.html">Language modes</a>

[27] Fix | Delete

<li><a class=active href="#">SQL Mode for CodeMirror</a>

[28] Fix | Delete

</ul>

[29] Fix | Delete

</div>

[30] Fix | Delete

[31] Fix | Delete

[32] Fix | Delete

<h2>SQL Mode for CodeMirror</h2>

[33] Fix | Delete

<form>

[34] Fix | Delete

<textarea id="code" name="code">-- SQL Mode for CodeMirror

[35] Fix | Delete

SELECT SQL_NO_CACHE DISTINCT

[36] Fix | Delete

@var1 AS `val1`, @'val2', @global.'sql_mode',

[37] Fix | Delete

1.1 AS `float_val`, .14 AS `another_float`, 0.09e3 AS `int_with_esp`,

[38] Fix | Delete

0xFA5 AS `hex`, x'fa5' AS `hex2`, 0b101 AS `bin`, b'101' AS `bin2`,

[39] Fix | Delete

DATE '1994-01-01' AS `sql_date`, { T "1994-01-01" } AS `odbc_date`,

[40] Fix | Delete

'my string', _utf8'your string', N'her string',

[41] Fix | Delete

TRUE, FALSE, UNKNOWN

[42] Fix | Delete

FROM DUAL

[43] Fix | Delete

-- space needed after '--'

[44] Fix | Delete

# 1 line comment

[45] Fix | Delete

/* multiline

[46] Fix | Delete

comment! */

[47] Fix | Delete

LIMIT 1 OFFSET 0;

[48] Fix | Delete

</textarea>

[49] Fix | Delete

</form>

[50] Fix | Delete

<p><strong>MIME types defined:</strong>

[51] Fix | Delete

<code><a href="?mime=text/x-sql">text/x-sql</a></code>,

[52] Fix | Delete

<code><a href="?mime=text/x-mysql">text/x-mysql</a></code>,

[53] Fix | Delete

<code><a href="?mime=text/x-mariadb">text/x-mariadb</a></code>,

[54] Fix | Delete

<code><a href="?mime=text/x-cassandra">text/x-cassandra</a></code>,

[55] Fix | Delete

<code><a href="?mime=text/x-plsql">text/x-plsql</a></code>,

[56] Fix | Delete

<code><a href="?mime=text/x-mssql">text/x-mssql</a></code>,

[57] Fix | Delete

<code><a href="?mime=text/x-hive">text/x-hive</a></code>,

[58] Fix | Delete

<code><a href="?mime=text/x-pgsql">text/x-pgsql</a></code>,

[59] Fix | Delete

<code><a href="?mime=text/x-gql">text/x-gql</a></code>.

[60] Fix | Delete

</p>

[61] Fix | Delete

[62] Fix | Delete

window.onload = function() {

[63] Fix | Delete

var mime = 'text/x-mariadb';

[64] Fix | Delete

// get mime type

[65] Fix | Delete

if (window.location.href.indexOf('mime=') > -1) {

[66] Fix | Delete

mime = window.location.href.substr(window.location.href.indexOf('mime=') + 5);

[67] Fix | Delete

}

[68] Fix | Delete

window.editor = CodeMirror.fromTextArea(document.getElementById('code'), {

[69] Fix | Delete

mode: mime,

[70] Fix | Delete

indentWithTabs: true,

[71] Fix | Delete

smartIndent: true,

[72] Fix | Delete

lineNumbers: true,

[73] Fix | Delete

matchBrackets : true,

[74] Fix | Delete

autofocus: true,

[75] Fix | Delete

extraKeys: {"Ctrl-Space": "autocomplete"},

[76] Fix | Delete

hintOptions: {tables: {

[77] Fix | Delete

users: {name: null, score: null, birthDate: null},

[78] Fix | Delete

countries: {name: null, population: null, size: null}

[79] Fix | Delete

}}

[80] Fix | Delete

});

[81] Fix | Delete

};

[82] Fix | Delete

</script>

[83] Fix | Delete

[84] Fix | Delete

</article>

[85] Fix | Delete

[86] Fix | Delete