3149
MySQLWARNINGCriticalDeprecationHIGH confidence
Deprecated syntax used (note level)
Production Risk
Low — informational; behavior unchanged until removal.
What this means
A deprecated syntax or feature was used and a note-level warning is emitted. This is a softer deprecation notice indicating the feature will eventually be removed.
Why it happens
- 1Using SQL syntax that is deprecated but still functional in MySQL 8.0.
How to reproduce
trigger — this will error
trigger — this will error
-- Example: deprecated SQL mode usage
expected output
Warning (Code 3149): Deprecated syntax note.
Fix
Update to the recommended syntax
Update to the recommended syntax
-- Consult MySQL 8.0 release notes for replacement syntax
Why this works
Removes the deprecation warning.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3149 ER_WARN_DEPRECATED_SYNTAX_EMIT_NOTE
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev