MySQL warns that the SQL mode you are trying to set is deprecated and scheduled for removal in a future version.
ER_WARN_DEPRECATED_SQLMODE (MySQL 3090) appears when you activate a deprecated SQL mode. Remove the obsolete mode from sql_mode or migrate your code to modern modes to clear the warning.
ER_WARN_DEPRECATED_SQLMODE
MySQL raises ER_WARN_DEPRECATED_SQLMODE when you attempt to enable a SQL mode that MySQL developers have marked for removal. The server still runs the statement but issues a warning to encourage early migration.
The warning was introduced in MySQL 5.7.6 and continues in 8.x. Ignoring it can leave applications unprepared for future upgrades where the mode will disappear entirely.
The message appears during SET sql_mode commands, server startup with a deprecated mode in my.cnf, or session changes via client libraries. The server parses the mode list, flags any obsolete entries, and pushes the warning to the client.
Because it is a warning, the SQL statement usually succeeds, but strict modes may escalate it if you promote warnings to errors.
Continuing to rely on deprecated modes can break applications after upgrading to a newer MySQL version that removes the setting. Addressing the warning protects future compatibility and simplifies migration testing.
An old global sql_mode value contains a mode that has since been deprecated.
Connection helpers or ORM libraries run SET sql_mode including obsolete values.
Developers reuse sample code listing modes that are no longer recommended.
Warns that a particular SQL syntax element is deprecated. Similar remediation: rewrite code.
Raised when an invalid or misspelled mode is supplied. Unlike 3090, the statement fails.
Appears when referencing a configuration variable that no longer exists.
No, the query executes unless you have sql_mode=STRICT or treat warnings as errors.
The list changes by version. In MySQL 8.0, ONLY_FULL_GROUP_BY is mandatory and cannot be disabled, so attempts to unset it trigger 3090.
Suppressing is discouraged. Instead, remove the deprecated mode. For temporary silence, use SHOW COUNT(*) WARNINGS to ignore it, but plan a proper fix.
Galaxy highlights server warnings inline, making it easy to spot 3090, and lets you edit sql_mode snippets quickly in a shared, version-controlled environment.
.avif)
.avif){kind=logo}
