MySQL Import error variable ' sql_notes ' can ' t be set to the value of ' NULL '

Error message:

An error occurred executing the SQL statement:

/*!40111 SET [Email protected]_sql_notes */

Error message: Variable ' sql_notes ' can ' t is set to the value of ' NULL '

Check:

The error message is that sql_notes cannot be set to a null value, and the login check is as follows

Mysql> SELECT @ @sql_notes;

+-------------+

| @ @sql_notes |

+-------------+

| 1 |

+-------------+

1 row in Set (0.00 sec)

Explain:

Sql_notes = {0 | 1}

When set to 1 o'clock (by default), alerts at the "attention" level are recorded. When set to 0 o'clock, the "note" warning is suppressed. The mysqldump contains output, which is used to set this variable to 0, so that no warning is generated when the dump file is re-loaded for events that do not affect the integrity of the reload operation

Solve:

mysql> SET @ @sql_notes = 0;

Query OK, 0 rows Affected (0.00 sec)

Mysql> SELECT @ @sql_notes;

+-------------+

| @ @sql_notes |

+-------------+

| 0 |

+-------------+

1 row in Set (0.00 sec)

MySQL Import error variable ' sql_notes ' can ' t be set to the value of ' NULL '