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. > > I created a db named a-b that includes a hyphen. > > > > % mysql a-b > > mysql> show tables ; > > +-------------------------+ > > | Tables_in_a-b | > > +-------------------------+ > > | a | > > | 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 Takanori Ugai -- Takanori Ugai internet: [EMAIL PROTECTED] Document Processing Lab. FUJITSU LABORATORIES LTD. Kawasaki Japan --------------------------------------------------------------------- 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