MAX_WARNINGS option

Function

Controls the maximum number of warnings allowed.

Allowed values

Any integer

Default

264 - 1

Scope

DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.

Description

This option can limit the number of warnings about rejected values, row mismatches, and so on during DDL commands. The default does not restrict the number you can receive.