content_image/778763.jpg content_image/778768.jpg content_image/778769.jpg content_image/778776.jpg
<img src='content_image/778763.jpg'>

The maximum number of rows to return from SELECT  statements. For more information, see Using Safe- Updates Mode (--safe-updates). 

The default value for a new connection is the maximum number of rows that the server permits per table. Typical default values are (2$^{32}$) − 1 or (2$^{64}$) − 1. If you have changed the limit, the default value can be restored by assigning a value of DEFAULT . 

If a SELECT  has a LIMIT  clause, the LIMIT  takes precedence over the value of sql_select_limit . 

• sql_warnings 

<img src='content_image/778768.jpg'>

This variable controls whether single-row INSERT  statements produce an information string if warnings occur. The default is OFF . Set the value to ON  to produce an information string. 

• ssl_ca 

<img src='content_image/778769.jpg'>

The path name of the Certificate Authority (CA) certificate file in PEM format. The file contains a list of trusted SSL Certificate Authorities. 

As of MySQL 8.0.16, this variable is dynamic and can be modified at runtime to affect the TSL context the server uses for new connections. See Server-Side Runtime Configuration and Monitoring for Encrypted Connections. Prior to MySQL 8.0.16, this variable can be set only at server startup. 

• ssl_capath 

<img src='content_image/778776.jpg'>

