Re: Table name problem

Armando <[email protected]> Thu, 05 Oct 2006 19:54:52 -0500
Newsgroups gmane.comp.db.mysql.windows
Message-ID <[email protected]>
Access allows you to do all sorts of things that you shouldn't be 
allowed to do where databases are concerned. When it allows you to make 
a column named '+/-' you know there's going to be trouble if you ever 
try to move the data into another platform.

Simple rule of thumb, the only special character you should ever use is 
an underscore. It will save you tons of headache. Cheers.

Armando

Charles Mabbott wrote:
> 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.
> 
> 

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