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;

​