2.3.3 Settings for the Extension and All Editors

The following settings apply to the MySQL Shell for VS Code extension and its editors.

Note

Settings for MySQL Shell for VS Code are categorized under the name of the MySQL Shell GUI (Msg) repository.

Msg › Debug Log: Level

Set a different verbosity level for the communication log between the extension and the MySQL Shell. To see this log, open the OUTPUT channel MySQL Shell for VS Code. The choice of verbosity level are as follows:

• NONE: Switch logging off.

• ERROR: Log errors only.

• WARNING: Log errors and warnings.

• INFO (default): Log errors, warnings, and other normal information.

• DEBUG: Log for problem analysis, which prints additional information.

• DEBUG2: Not currently used.

• DEBUG3: Use for problem analysis. Everything is printed to the logs, which may include security information such as passwords, connection tokens and so on. However, all security-relevant information is replaced with asterisk character (***). This setting level produces a large amount of output.

Msg › Editor: Db Version

The default version to be used for MySQL language support, if no version of MySQL Server is available. Otherwise, the current version is shown.

Msg › Editor: Default Db Connection

Specify the name (title) of a DB connection to be used when running embedded SQL from a standard text editor and no connection is open yet. Leave empty to select a connection.

Msg › Editor: Show Hidden

When set to true, normally invisible characters, such as spaces or tabs, are displayed.

Msg › Editor: Show Minimap

Determines if code editors should show a minimap, instead of the plain scrollbar, for better navigation.

Msg › Editor: Sql Mode

The default SQL mode to be used for MySQL language support, if the mode information is not available. Default SQL mode value is:

ONLY_FULL_GROUP_BY STRICT_TRANS_TABLES NO_ZERO_IN_DATE NO_ZERO_DATE ERROR_FOR_DIVISION_BY_ZERO NO_ENGINE_SUBSTITUTION

For additional valid values, see sql_mode.

Msg › Editor: Stop On Errors

Set to true, for the execution of scripts to stop if an error occurs. Otherwise, the script execution continues with the next statement.

Msg › Editor › Theming: Decoration Set

Select one of the sets to be used to mark code block and results in mixed language editors. The following options are available:

• standard (default): Includes only a solid marker for editor rows.

• alternative: Uses a hatch pattern with different colors to mark Editor contents and result areas.

Msg › Editor: Word Wrap

To determines how long lines should be wrapped automatically by the editor. The following options are available:

• off (default): Lines are not wrapped.

• on: Lines are wrapped at the width of the viewport.

• wordWrapColumn: Lines are wrapped at the Word Wrap Column.

• bounded: Lines are wrapped at the minimum of the viewport width of Word Wrap Column.

Msg › Editor: Word Wrap Column

Integer value to control the column of the editor to wrap long lines when the editor is using wordWrapColumn or bounded word wrapping. The default value is 120.

Msg › Sql: Limit Row Count

Integer value used to determine the size of one page in a result set, but has no effect if a top-level LIMIT clause is specified in the query. Set to 0 to disable auto adding a LIMIT clause and return all records as single page. The default value is 1000.

Msg › Sql: Row Packet Size

Integer value used to determine the number of result records that are returned as a single response from the backend. The default value is 1000.

Msg › Startup: Show Db Connection Tab

Open the DB Connections Overview Editor when selecting the MySQL Shell for VS Code extension icon in the Activity Bar for the first time after VS Code startup.

Msg › Tab Position: New Connection

Where to place the new tab when opening a database connection. The following placement options are available:

• Active (default): In the currently active Editor group.

• Beside Right: In the editor group beside the active one.

• Beside Bottom: In the editor group beneath the active one.

Msg › Tab Position: New Connection With Embedded Sql

Where to place the new tab when opening a MySQL Shell console. The following placement options are available:

• Active: In the currently active editor group.

• Beside Right: In the editor group beside the active one.

• Beside Bottom (default): In the editor group beneath the active one.