SHOW syntax and hyphen in a dbname

2002-07-29 Thread Takanori Ugai
Dear Folks, I'm not sure this is a bug or the SQL syntax. I created a db named a-b that includes a hyphen. % mysql a-b mysql show tables ; +-+ | Tables_in_a-b | +-+ | a | | b |

Re: SHOW syntax and hyphen in a dbname

2002-07-29 Thread Jeremy Zawodny
On Tue, Jul 30, 2002 at 01:45:59PM +0900, Takanori Ugai wrote: Dear Folks, I'm not sure this is a bug or the SQL syntax. I created a db named a-b that includes a hyphen. % mysql a-b mysql show tables ; +-+ | Tables_in_a-b | +-+

Re: SHOW syntax and hyphen in a dbname

2002-07-29 Thread Takanori Ugai
Thank you all to answer me Quotation. mysql show tables from `a-b`; It is working well. In messasge [EMAIL PROTECTED], Jeremy Zawodny [EMAIL PROTECTED] wrote: On Tue, Jul 30, 2002 at 01:45:59PM +0900, Takanori Ugai wrote: Dear Folks, I'm not sure this is a bug or the SQL syntax.