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]