3221
MariaDBWARNINGCriticalDeprecated FeaturesHIGH confidence

Deprecated syntax warning with version information

Production Risk

Low — warning only; feature still works currently.

Why it happens
  1. 1Using a syntax or feature deprecated in the current MySQL version.
  2. 2Feature will be removed in a future MySQL version.
How to reproduce
trigger — this will error
trigger — this will error
-- Example: using deprecated SQL modes or constructs.

expected output

Warning 3221: Deprecated syntax used; will be removed in a future release.

Fix

Update to the recommended syntax

Update to the recommended syntax
-- Consult the MySQL release notes for the recommended replacement.

Why this works

Migrate away from deprecated syntax before the next major version.

What not to do

Sources
Official documentation ↗

MySQL 8.0 — 3221 ER_WARN_DEPRECATED_SYNTAX_WITH_VER3

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MariaDB errors