Re: Table name problem

There an approach of '_' between the words also
Chuck

Tata Respecia <[email protected]> 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/win32?unsub=crmabbott@
omcast.net 
>
>.


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