mr_ped Messages: 825 Registered: November 2005 Location: Czech Republic - Praha
Experienced Contributor
With MySQL it's `column-name` (grave accent/backtick), and it's required not only for reserved words but also for names including minus and other ascii characters (not sure which of them are allowed, I always use only alphanumeric chars for names, but have seen names like "prefix-name" in project of my friend).
Logging with quotes doesn't bother me at all, I'm used to read "sanitized" SQL anyway.
Edit: just to be complete, values in MySQL are put into ordinary apostrophe, like 'this'.
Now I see you can also use "ANSI_QUOTE" switch with MySQL to make it work with ordinary "quotes".