RE: "-" character in table name

2002-04-10 Thread nickg
oesn'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

Re: "-" character in table name

2002-04-10 Thread David Chen
lt;[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

RE: "-" character in table name

2002-04-10 Thread Gregory Junker
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 > > > Hell

RE: "-" character in table name

2002-04-10 Thread nickg
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

"-" character in table name

2002-04-10 Thread David Chen
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