sm
The subcommands of doctl databases sql-mode are used to view and configure a MySQL database cluster’s global SQL modes. Global SQL modes affect the SQL syntax MySQL supports and the data validation checks it performs.
| Option | Description |
|---|---|
--help
, -h
|
Help for this command |
| Command | Description |
|---|---|
| doctl databases | Display commands that manage databases |
| doctl databases sql-mode get | Get a MySQL database cluster's SQL modes |
| doctl databases sql-mode set | Set a MySQL database cluster's SQL modes |
| 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
|