Have you tried delimiting the table name with some form of quotes?
> -----Original Message----- > From: David Chen [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 10, 2002 4:05 PM > To: [EMAIL PROTECTED] > Subject: "-" character in table name > > > Hello, > > I probably installed a PHP script that created a table with a > - in its name. > I can't figure out how to even touch this table. If I try: > > mysql> describe A-14c; > ERROR 1064: You have an error in your SQL syntax near '-14c' at line 1 > > This table exists for sure though: > > | Tables_in_blesysdb | > +---------------------+ > | A-14c | > | allvisitors | > | articlepages | > | articles | > ... > > > I played around, and I can't create a table with - either: > mysql> create table d-test; > ERROR 1064: You have an error in your SQL syntax near '-test' > at line 1 > > > Any help is appreciated. Thanks. > > > Sincerely, > David Chen > > > --------------------------------------------------------------------- > 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
