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, > > > &g

SHOW syntax and hyphen in a dbname

2002-07-29 Thread Takanori Ugai
| | b | +-+ 7 rows in set (0.00 sec) mysql> show tables from a-b ; ERROR 1064: You have an error in your SQL syntax near 'a-b' at line 1 I think the syntax should accept such a DB's name and this is a bug. Anybody knows how the SQL should handle the hyphen? Sinc