U++ forum: Welcome to the forum

Re: How should we deal with SQL column names in conflict with SQL standard keywords [message #35296 is a reply to message #35280]

Mon, 30 January 2012 08:52

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".

http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

[Updated on: Mon, 30 January 2012 08:59]

Report message to a moderator