Re: Table name problem

Those are back ticks. Single quotes won't do it.

Randy Clamons
Systems Programming
[email protected]


Tata Respecia wrote:
> use single quotes like this: 
> 
> Insert into `Book Record` (........
> 
> 
> 
> 
> --- Ata ur Rehman <[email protected]> wrote:
> 
>> Dear All
>>
>> I used a tool Access2MySQL to convert my database
>> from Access to MySQL. (I
>> am using version 4).  There was a table Book Record
>> in Access.  Access alow
>> spaces between table names.
>> When i use the command:
>> MySQL>show tables;
>> I found that table in the list as
>>
>> ...
>> ...
>> Book Record
>> ....
>> ....
>>
>> But when i want to use it for data entry as
>>
>> Insert into Book Record (........
>>
>> I found the error, table not exist..
>>
>>
>> What should i do?
>>
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> 

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]