At 2:18 AM +0100 3/16/01, Erling Paulsen wrote:
>I just exported (via myodbc) an old access database for my sportsclub to
>mysql (the tables). The ms-access database application still works nicely on
>the new linked tables in mysql. However, I'm now also writing a php based
>client to use the database over the web and the problem is as follows:
>
>They guy that developed the access database used `#' (comment character)
>characters to name certain columns. i.e. "Person#". How can manually select
>such a column in a mysql query (ex. via the mysql client)? - since it seems
>whatever i enclose the column name in, the rest of the query is interpreted
>as a comment!
Use backticks around the column name when you refer to it: `Person#`
>
>--
>Erling Paulsen
>Norway
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
