-- 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;
window.onload = function() {
var mime = 'text/x-mysql';
window.editor = CodeMirror.fromTextArea(document.getElementById('code'), {
mode: mime,
theme:'monokai',
indentWithTabs: true,
smartIndent: true,
lineNumbers: true,
matchBrackets : true,
autofocus: true,
extraKeys: {"Tab": "autocomplete"},
hintOptions: {
completeSingle:false,
tables: {
users: ["name", "score", "birthDate"],
countries: ["name", "population", "size"]
}}
});
window.editor.on('keypress',function(){
window.editor.showHint()
})
};