How important are backtics (`)

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jonah
Forum Commoner
Posts: 31
Joined: Fri Jun 20, 2003 12:23 am

How important are backtics (`)

Post by jonah »

While playing around with and getting used to phpMyAdmin, I notice
that example query coding always places backticks (`column`) around
column names. In addition, much of the code advice in this forum
includes examples utilizing the same syntax.

I have never needed to use these in my code and was wondering what
specific benefit is derived from their use?

Are there situations where their use is absolutely necessary or are they
used simply to clarify or highlight code so that it is more readable?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

backticks are required if you have a field name that conflicts with a keyword
Post Reply