Error selecting tables with a space in the name

If you have a table like MY TABLE

selecting SELECT TOP 1000 the command is

SELECT * FROM MYDB.MY TABLE LIMIT 1000;

and gives an error (Error: ER_PARSE_ERROR: You have an error in your SQL syntax;....)

The correct command should be

SELECT * FROM \`MYDB\`.\`MY TABLE\` LIMIT 1000;

but if you write this it gives Code language not supported or defined.