On Fri, 2002-03-08 at 08:33, joseph.chillari@stripped wrote:
> Access can do it, & I have queries in access that need to be able to read
> the data I imported into Mysql from access.
> Can it be done, if so how
(hello fellow Australian ;-)
Well, you can stuff pretty much anything into a column name if you quote
it in backticks: `some thing:bla.bla`.
Maybe that knowledge will help?
Naturally, it's nicer to not have funny characters in db/table/column
names. Avoids confusion, errors, and makes things portable. Other RDBMS
will be even more picky than MySQL.
MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <arjen@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer
/_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia