Resolved: Unrecognised Format -"Sales"
MySQL does not recognise the element of sql statement placed in quotation mark. When I tried to use quotation mark for the name of the database I keep getting an error code 1064. But when I removed it, it seems to work fine. Is this issue with my version of MySQL workbench or is the format no longer recognisable?
PS: I use version 8.0.30
Thanks for reaching out.
The names of databases and tables should not be in quotes. This is not a version-related issue. This is the syntax. For database and tables you should use backticks (````) or not use any symbols.
Hope this helps.