List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 16 2001 4:32am
Subject:Re: Columns named with the # character
View as plain text  
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, paul@stripped
Thread
Columns named with the # characterErling Paulsen16 Mar
  • Re: Columns named with the # characterPaul DuBois16 Mar
  • Re: Columns named with the # characterFred van Engen16 Mar
Re: Columns named with the # characterErling Paulsen16 Mar