.CodeMirror { border-top: 1px solid black; border-bottom: 1px solid black; }
CodeMirror
Home Manual Code
Language modes SQL Mode for CodeMirror
SQL Mode for CodeMirror
-- 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;
MIME types defined: text/x-sql , text/x-mysql , text/x-mariadb , text/x-cassandra , text/x-plsql , text/x-mssql , text/x-hive , text/x-pgsql , text/x-gql , text/x-gpsql . text/x-esper .
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", "score", "birthDate"], countries: ["name", "population", "size"] }} }); };