1287
MySQLwarningsyntaxhigh confidence
Deprecated syntax will be removed in a future release
Production Risk
Low now, but high risk at the next major upgrade if not addressed.
What this means
A syntax or feature was used that is deprecated and scheduled for removal in a future MySQL version.
Why it happens
- 1Using old syntax like STRAIGHT_JOIN in contexts that changed
- 2Using features flagged for removal such as SET NAMES DEFAULT
How to reproduce
trigger — this will error
trigger — this will error
-- Varies by context; e.g. using deprecated character set aliases.
expected output
Warning 1287: syntax is deprecated and will be removed in a future release
Fix
Migrate to the recommended replacement
Why this works
Review the MySQL 8.0 migration guide for the specific deprecation.
What not to do
✕
Version notes
Sources
Official documentation ↗
MySQL 8.0 — 1287 ER_WARN_DEPRECATED_SYNTAX
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev