A prototype of a MySQL editor with syntax highlighting, autocomplete, and a sortable, searchable table with file exports; powered by CodeMirror and DataTables.

There are tags with a CodeMirror only editor version, and a CodeMirror and DataTables combo version with CSV, clipboard, and Excel exports.

• CodeMirror: https://github.com/chancyk/mysql_editor/tree/editor-only
• CodeMirror & DataTable: https://github.com/chancyk/mysql_editor/tree/editor-datatable

The DataTable version is setup with a mock fake_post function that can be replaced with the jQuery's $.post, and pointed at a server-side route, which upon response will dynamically create the DataTable.

The SQL dialect can be change by altering the CodeMirror mode option to be one of the following MIME types, as specified by the sql plugin:

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