SQL Mode for CodeMirror

1
-- SQL Mode for CodeMirror
2
SELECT SQL_NO_CACHE DISTINCT
3
        @var1 AS `val1`, @'val2', @global.'sql_mode',
4
        1.1 AS `float_val`, .14 AS `another_float`, 0.09e3 AS `int_with_esp`,
5
        0xFA5 AS `hex`, x'fa5' AS `hex2`, 0b101 AS `bin`, b'101' AS `bin2`,
6
        DATE '1994-01-01' AS `sql_date`, { T "1994-01-01" } AS `odbc_date`,
7
        'myString', UNKNOWN
8
    FROM DUAL
9
    -- space needed after '--'
10
    # 1 line comment
11
    /* multiline
12
    comment! */
13
    LIMIT 1 OFFSET 0;
14
 
 

MIME types defined: text/x-sql, text/x-mysql, text/x-mariadb, text/x-plsql.

Tests: normal, verbose.