4.2.5 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.