"Johan De Meersman" <vegivamp@stripped> escreveu na mensagem
> On Thu, Feb 24, 2011 at 12:06 PM, Dave M G <dave@stripped> wrote:
>> Should I never use the word "group" for column names? Seems a little
>> silly. Is there a way to protect column names to that there is no
> As several people already pointed out, simply use backticks. Simple quotes
> have started to work in more and more places in newer versions of MySQL.
> However, it is considered bad form to name columns for reserved words -
> ones as obvious as "group" or "index". Bad form in the same way that you
> wouldn't name any variables "define" or "if" while programming; or in a
> similar way that you wouldn't put a box of TNT next to a burning candle -
> it's an accident waiting to happen.
> The escapes are there in case an upgrade creates new reserved words that
> you've already used in column names - "partition" comes to mind - but if
> are still in a phase where you can avoid using reserved words, please
> yourself and others a lot of trouble and do so; even if only because while
> you can fix your code, you can't fix someone else's - think management
> tools, backup scripts, whatever may touch the db in the future.
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel