As of MySQL v8.0.2, 'rank' is now a reserved keyword and we use a field named rank in most tables. Therefore, the field must be delimited by quotes or ticks in order for the sql query to work. This primarily rears it's ugly head in the ORDER BY clauses.
dleffler
commented
2 years ago
As of MySQL v8.0.2, 'rank' is now a reserved keyword and we use a field named rank in most tables. Therefore, the field must be delimited by quotes or ticks in order for the sql query to work. This primarily rears it's ugly head in the ORDER BY clauses.