This is probably not the best recommendation but if you are compiling from
the source distribution, you might locate where the comment character is
defined and change it to some other character and recompile. I have no idea
of the potential ramifications in doing this and you would need to be very
careful as to the replacement character you choose.

-----Original Message-----
From: Dirk Ostertag [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 9:09 AM
To: [EMAIL PROTECTED]
Subject: Must use '#' in fieldnames


Hello everybody,

I have to create a table on a MySQL-Server with fieldnames like a35#70.
if I ty it that way

create table test (
    a35#70 char (70));

on the mysql - prompt, the creation fails. Even brackets like in MsSQL
or '`' doesn't help.
Can anybody tell me what to do?

thank
Dirk



---------------------------------------------------------------------
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

---------------------------------------------------------------------
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

Reply via email to