In MySQL, column names are escaped using the back tick like `miles/hour` but double quotes can be used, "miles/hour" when ANSI mode is enabled. This is important because regular SQL does not support back ticks and PostgresSQL only supports double quotes.
So, when setting up your database to be ported into any language, make sure to enable ANSI mode in MySQL and use double quotes around any column names with special characters.
So, when setting up your database to be ported into any language, make sure to enable ANSI mode in MySQL and use double quotes around any column names with special characters.
