Tag Info

New answers tagged


By default MSSQL puts the columns and table names in quotes, for MySQL we need to add ANSI_QUOTES to sql-mode. It can be set in my.ini or my.cnf depending on your Operating System. For Windows server 2012 MySQL 5.6, for example, you can find it in C:\ProgramData\MySQL\MySQL Server 5.6. In my.ini, you need to find #sql-mode and update it, adding ...

Top 50 recent answers are included