New reserved words

from the Artful MySQL Tips List


ADMINBUCKETSCLONECOMPONENT
CUME_DISTDENSE_RANKEMPTYEXCEPT
EXCLUDEFIRST_VALUEFOLLOWINGGROUPING
GROUPSHISTOGRAMHISTORYINVISIBLE
JSON_TABLELAGLAST_VALUELEAD
LOCKEDNESTEDNOWAITNTH_VALUE
NTILENULLSOFORDINALITY
OTHERSOVERPATHPERCENT_RANK
PERSISTPERSIST_ONLYPRECEDINGRANK
RECURSIVEREMOTERESOURCERESPECT
REUSEROLEROW_NUMBERSKIP
SRIDSYSTEMTHREAD_PRIORITYTIES
UNBOUNDEDVCPUVISIBLEWINDOW

There are now so many reserved words, and the list is growing so fast, it's becoming good policy to routinely enclose database identifier names in backticks. Ugh.

Last updated 3 Oct 2017


Return to the Artful MySQL Tips page