At 08:36 AM 1/13/2010, Intell! Soft wrote:
As I told, Backticks don't work.
But it is valid to use spaces in DB's because, mySQL Administrator can
handle it and my third party tool MySQL Maestro can also handle it. So,
when those two programs get the tables, then there has to be a solution
for it!?
THX
Replace the space in the database name with an underscore and save yourself
a lot of grief. You can go to the data directory and see if you can browse
the directory. Maybe the OS has a problem with spaces or maybe it isn't
really a space in the database name. Maybe it is a special character or two
spaces?
Mike
-----Ursprüngliche Nachricht-----
Von: Ananda Kumar [mailto:anan...@gmail.com]
Bereitgestellt: Mittwoch, 13. Jänner 2010 15:07
Bereitgestellt in: gmane.comp.db.mysql.general
Unterhaltung: Show Tables not working
Betreff: Re: Show Tables not working
i dont think "my design" is valid.
There should not be any SPACE for a db name.
On Wed, Jan 13, 2010 at 7:26 PM, Johan De Meersman
<vegiv...@tuxera.be>wrote:
> Try backticks.
>
> On Wed, Jan 13, 2010 at 2:44 PM, Intell! Soft <h.ba...@intelli-soft.at
> >wrote:
>
> > Hey
> >
> > Nobody any ideas?
> >
> >
> >
> >
> > -----Ursprüngliche Nachricht-----
> > Von: Intell! Soft [mailto:intellis...@fachoptiker.net]
> > Bereitgestellt: Freitag, 08. Jänner 2010 11:06
> > Bereitgestellt in: gmane.comp.db.mysql.general
> > Unterhaltung: Show Tables not working
> > Betreff: Show Tables not working
> >
> > Hey
> >
> > I try to use: Show Tables from My Design
> > Where "My Design" is the name of the Database. - But it is not
working
> > Even not with: Show Tables from 'My Design'
> >
> > How can I use a Database name wit 2 words in it!?
> >
> > THX
> >
> >
> >
> >
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be
> >
> >
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mo...@fastmail.fm
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
