MAX_WARNINGS option

Function

Controls the maximum number of warnings allowed.

Allowed values

Any integer

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.

Default

264 - 1

Description

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