Documentation Home
MySQL Shell for VS Code


Pre-General Availability: 2023-01-18

4.2.6 Configure Advanced Settings

SQL Mode

Optionally overrides the default SQL_MODE used by the server. SQL Mode values are:

  • ALLOW_INVALID_DATES

  • ANSI_QUOTES

  • ERROR_FOR_DIVISION_BY_ZERO

  • HIGH_NOT_PRECEDENCE

  • IGNORE_SPACE

  • NO_AUTO_VALUE_ON_ZERO

  • NO_UNSIGNED_SUBTRACTION

  • NO_ZERO_DATE

  • NO_ZERO_IN_DATE

  • ONLY_FULL_GROUP_BY

  • PAD_CHAR_TO_FULL_LENGTH

  • PIPES_AS_CONCAT

  • REAL_AS_FLOAT

Timeout

Maximum time in seconds to wait before the connection is aborted.

Other Options for Connection: Key/value pair for:

  • Option

  • Value

    Click + to add a new property entry or - to remove a property entry.