Because I routinely work with a number of different databases, I make a point of switching MySQL to ANSI mode to bring some consistency into my code. This way I can use double quotes for column names and || for concatenation, which is normal for most databases (MSSQL, it appears doesn’t use ||).
Apart from compatibility, is there a benefit in not switching to ANSI mode in MySQL?