codemirror mysql_CodeMirror 实现 sql web eidtor

web sql editor

-- 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()

})

};