Re: Columns named with the # character

2001-03-16 Thread Fred van Engen
On Fri, Mar 16, 2001 at 10:33:05AM +0100, Fred van Engen wrote: > The mysql client doesn't know about backticks and therefore handles the # > (and '-- ') as the beginning of a comment. It wouldn't do that for quoted > and double-quoted strings. > > I see no workaround other than to change the cli

Re: Columns named with the # character

2001-03-16 Thread Fred van Engen
Erling and MySQL guys, On Fri, Mar 16, 2001 at 02:18:55AM +0100, 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

Re: Columns named with the # character

2001-03-15 Thread Erling Paulsen
day 17 hours 47 sec Threads: 19 Questions: 2457 Slow queries: 0 Opens: 30 Flush tables: 1 Open tables: 19 Queries per second avg: 0.017 -- - Original Message - From: "Sam Smith" <[EMAIL PROTECTED]> To: "Erling Paulsen" <[EMAIL PROTECTED]>

Re: Columns named with the # character

2001-03-15 Thread Paul DuBois
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 data