Back to Opencart

CodeMirror

upload/assets/codemirror/mode/sql/index.html

4.1.0.3760 B
Original Source

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. text/x-sqlite. text/x-sparksql. text/x-trino.