What's the difference between
SELECT * FROM `this`
and
SELECT * FROM this
?
views:
58answers:
1
+7
A:
The former is escaped, the latter isn't. Consider:
SELECT * FROM `FROM`
On systems where the the backtick is an escape, that would select from a table called FROM (whereas without the backticks, it's a syntax error). Some systems use square brackets instead, e.g., SELECT * FROM [FROM].
T.J. Crowder
2010-02-13 13:21:01
so basically, you should never have a field called FROM but only `FROM`, is that right?
sombe
2010-02-13 13:22:38
@Gal: Right. And it'll depend on your platform whether you use backticks for that or some other notation (I've just updated the answer with a bit more detail).
T.J. Crowder
2010-02-13 13:23:34
@James Curran: Thanks, I *just* saw that and went to edit, and you'd beaten me to it!
T.J. Crowder
2010-02-13 13:25:11