Enable SQL_AUTO_IS_NULL

Auto_Is_Null

Key Name	Default Value	Required
Auto_Is_Null	Clear (0)0	No

Description

This option specifies whether the connector modifies the sql_auto_is_null setting in the server. For more information, see "Server System Variables" in the MySQL Reference Manual: https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_sql_auto_is_null.

• Enabled (1)1: The connector does not modify the sql_auto_is_null setting in the server, and supports sql_auto_is_null=1 if it is specified in the server.
• Disabled (0)0: The connector sets the sql_auto_is_null server system variable to 0, and does not support the retrieval of AUTO_INCREMENT values using IS NULL queries.

Related topics

• Using a Connection String
• Configuring Cursor and Result Options
• Creating a Data Source Name
• Configuring a DSN-less Connection
• Cursor and Result Configuration Options