[ Web Proxy ]
URL:
Viewing: https://docs.digitalocean.com/reference/doctl/reference/databases/sql-mode/set/ [Back]  [Original]
doctl databases sql-mode set | DigitalOcean Documentation

For AI agents: The documentation index is at https://docs.digitalocean.com/llms.txt. Markdown versions of pages use the same URL with index.html.md in place of the HTML page (for example, append index.html.md to the directory path instead of opening the HTML document).

doctl databases sql-mode set

Generated on 18 Aug 2026 from doctl version v1.167.0

Copy page as Markdown View page as Markdown

Usage 

doctl databases sql-mode set <database-cluster-id> <sql-mode-1> ... <sql-mode-n> [flags]

Aliases 

s

Description

This command configures the SQL modes for the specified MySQL database cluster. The SQL modes should be provided as a space separated list.

This command replaces the existing SQL mode configuration completely. Include all of the current values when adding a new one.

Example

The following example sets the SQL mode ALLOW_INVALID_DATES for an existing database cluster with the ID ca9f591d-f38h-5555-a0ef-1c02d1d1e35. The cluster already has the modes NO_ZERO_DATE, NO_ZERO_IN_DATE, STRICT_ALL_TABLES set, but they must be included in the command to avoid being overwritten by the additional mode:

doctl databases sql-mode set ca9f591d-f38h-5555-a0ef-1c02d1d1e35 NO_ZERO_DATE NO_ZERO_IN_DATE STRICT_ALL_TABLES ALLOW_INVALID_DATES

Flags

Option Description
--help, -h Help for this command
Command Description
doctl databases sql-mode Display commands to configure a MySQL database cluster's SQL modes

Global Flags

Option Description
--access-token, -t API V2 access token
--api-url, -u Override default API endpoint
--config, -c Specify a custom config file
Default:
    --context Specify a custom authentication context name
    --http-retry-max Set maximum number of retries for requests that fail with a 429 or 500-level error
    Default: 5
    --http-retry-wait-max Set the minimum number of seconds to wait before retrying a failed request
    Default: 30
    --http-retry-wait-min Set the maximum number of seconds to wait before retrying a failed request
    Default: 1
    --interactive Enable interactive behavior. Defaults to true if the terminal supports it (default false)
    Default: false
    --output, -o Desired output format [text|json]
    Default: text
    --trace Show a log of network activity while performing a command
    Default: false
    --verbose, -v Enable verbose output
    Default: false

    In this article...

    We can't find any results for your search.

    Try using different keywords or simplifying your search terms.

    Web Proxy Viewer  |  New URL  |  Original Page