` = back ticks next to the 1 and above the Tab, not ' = apostrophe next to the ; and Enter, you should be able to copy directly from the e-mail
mysql> describe A-14c; ERROR 1064: You have an error in your SQL syntax near '-14c' at line 1 mysql> describe 'A-14c'; ERROR 1064: You have an error in your SQL syntax near ''A-14c'' at line 1 mysql> describe "A-14c"; ERROR 1064: You have an error in your SQL syntax near '"A-14c"' at line 1 mysql> describe `A-14c`; ERROR 1146: Table 'dns.A-14c' doesn't exist mysql> nickg -----Original Message----- From: David Chen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 2:20 PM To: nickg; [EMAIL PROTECTED] Subject: Re: "-" character in table name mysql> describe 'A-14c'; ERROR 1064: You have an error in your SQL syntax near ''A-14c'' at line 1 It's not working... ----- Original Message ----- From: "nickg" <[EMAIL PROTECTED]> To: "David Chen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, April 10, 2002 2:13 PM Subject: RE: "-" character in table name > 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 > --------------------------------------------------------------------- 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
