MySQL INSERT INTO syntax

RIGHT is a mySQL reserved word. It will work only when wrapped in backticks.

When you're not using reserved words, it will work without the backticks, as well.

The second way will never work because quotes are used to quote strings, but never database, table or column identifiers.