Re: Table name problem

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]