Why am I getting error 1064 when creating a table?
When creating a table, you should not use single quotes (') to enclose table or column names, but instead use backticks (`) to enclose table and column names, when required.

See Schema Object Names in the MySQL documentation.

If ANSI_QUOTES mode is enabled, it is also permissible to quote identifiers within double quotation marks (").