RE: Table name problem

Can I suggest using the '_' for example
Book_Record

Because spaces in Access are treated internally a little
Different.  Look at the queries in SQL mode and you'll see 
what I mean.  The easiest way is use the '_' rather than a 
a space.


-- 
Chuck
 
>SELECT * FROM users WHERE clue = TRUE;
0 rows returned
 
Ahhh they are clueless!

-----Original Message-----
From: Randy Clamons [mailto:[email protected]] 
Sent: Thursday, October 05, 2006 2:04 PM
To: [email protected]
Subject: 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]


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