Pre-General Availability: 2024-10-04
The following settings apply to the MySQL Shell for VS Code extension and its editors.
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 ofWord 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
orbounded
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 to0
to disable auto adding aLIMIT
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.