Error in syntax due to different server version

[Ryan Lee]

Hi everyone, I am new to coding and all, is currently dipping my toes in SQL. I created this SQL code but it seems like my syntax is incorrect. Can anybody tell me what is wrong with it?

CREATE TABLE ‘exchange‘ (
-> ‘id‘ int NOT NULL AUTO_INCREMENT,
-> ‘abbrev‘ varchar(32) NOT NULL,
-> ‘name‘ varchar(255) NOT NULL,
-> ‘city‘ varchar(255) NULL,
-> ‘country‘ varchar(255) NULL,
-> ‘currency‘ varchar(64) NULL,
-> ‘timezone_offset‘ time NULL,
-> ‘created_date‘ datetime NOT NULL,
-> ‘last_updated_date‘ datetime NOT NULL,
-> PRIMARY KEY (‘id‘)
-> ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

The error message was:

"Error 1064 (42000) You have an error in your syntax; check the manual that corresponds to your MySQL server version for the right version to use near ''exchange (
'id' int NOT NULL AUTO_INCREMENT,
'abbrev' varchar(32) NOT NULL,
'n' at line 1

Any help is greatly appreciated!