Try enclosing it: describe `A-14c`;
nickg -----Original Message----- From: David Chen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 2: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
