Thread: INSERT problem
View Single Post

  #9 (permalink)  
Old 01-29-2007
Jerry Stuckle
 
Posts: n/a
Default Re: INSERT problem

Jerry Stuckle wrote:
> Carl Pearson wrote:
>> So far as surrounding table names in the insert statement with quotes,
>> I couldn't find it in the manual, and it bombed when I tried it. Am
>> curious where you got this info.
>>

>
> It requires back ticks. Check the manual. It's there, very
> prominently. And has been since at least version 3.x.
>


Allow me to clarify this. If you're going to enclose table and/or
column names, they must be back ticks. And back ticks are required if
you're using MySQL reserved words as column or table names.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Reply With Quote