Re: Show Tables not working
Re: Show Tables not working
am 13.01.2010 14:44:10 von h.bacik
Hey
Nobody any ideas?
-----Ursprüngliche Nachricht-----
Von: Intell! Soft [mailto:intellisoft@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=gcdmg-mysql-2@m.gmane.org
Re: Show Tables not working
am 13.01.2010 14:56:17 von Johan De Meersman
--001636d33c7c6c5899047d0c2251
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Try backticks.
On Wed, Jan 13, 2010 at 2:44 PM, Intell! Soft wrot=
e:
> Hey
>
> Nobody any ideas?
>
>
>
>
> -----Ursprüngliche Nachricht-----
> Von: Intell! Soft [mailto:intellisoft@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=3Dvegivamp@tuxera.b=
e
>
>
--=20
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--001636d33c7c6c5899047d0c2251--
Re: Show Tables not working
am 13.01.2010 15:07:02 von Ananda Kumar
--00504502b146e5c226047d0c48f8
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
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 wrot=
e:
> Try backticks.
>
> On Wed, Jan 13, 2010 at 2:44 PM, Intell! Soft
> >wrote:
>
> > Hey
> >
> > Nobody any ideas?
> >
> >
> >
> >
> > -----Ursprüngliche Nachricht-----
> > Von: Intell! Soft [mailto:intellisoft@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=3Dvegivamp@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
>
--00504502b146e5c226047d0c48f8--
Re: Show Tables not working
am 13.01.2010 15:36:07 von h.bacik
------=_NextPart_000_008D_01CA9466.209CEA50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
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
-----Ursprüngliche Nachricht-----
Von: Ananda Kumar [mailto:anandkl@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
wrote:
> Try backticks.
>
> On Wed, Jan 13, 2010 at 2:44 PM, Intell! Soft
> >wrote:
>
> > Hey
> >
> > Nobody any ideas?
> >
> >
> >
> >
> > -----Ursprüngliche Nachricht-----
> > Von: Intell! Soft [mailto:intellisoft@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=vegivamp@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
>
------=_NextPart_000_008D_01CA9466.209CEA50
Content-Type: text/plain; charset=us-ascii
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
------=_NextPart_000_008D_01CA9466.209CEA50--
Re: Show Tables not working
am 13.01.2010 15:47:12 von Johan De Meersman
--001517741884845be9047d0cd8f7
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
It is valid, it's just not a very smart thing to do, as various tools may
not be very happy about it.
On Wed, Jan 13, 2010 at 3:07 PM, Ananda Kumar wrote:
> 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
> >wrote:
>
> > Try backticks.
> >
> > On Wed, Jan 13, 2010 at 2:44 PM, Intell! Soft
> > >wrote:
> >
> > > Hey
> > >
> > > Nobody any ideas?
> > >
> > >
> > >
> > >
> > > -----Ursprüngliche Nachricht-----
> > > Von: Intell! Soft [mailto:intellisoft@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 workin=
g
> > > 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=3Dvegivamp@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
> >
>
--=20
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--001517741884845be9047d0cd8f7--
Re: Show Tables not working
am 13.01.2010 17:10:53 von Johan De Meersman
--000e0cd56c32cda943047d0e0388
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Then you possibly aren't using backticks, because I just tested them :-)
On Wed, Jan 13, 2010 at 3:36 PM, Intell! Soft wrot=
e:
> 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
>
>
>
>
> -----Ursprüngliche Nachricht-----
> Von: Ananda Kumar [mailto:anandkl@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
> wrote:
>
> > Try backticks.
> >
> > On Wed, Jan 13, 2010 at 2:44 PM, Intell! Soft
> > >wrote:
> >
> > > Hey
> > >
> > > Nobody any ideas?
> > >
> > >
> > >
> > >
> > > -----Ursprüngliche Nachricht-----
> > > Von: Intell! Soft [mailto:intellisoft@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=3Dvegivamp@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=3Dvegivamp@tuxera.b=
e
>
--=20
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--000e0cd56c32cda943047d0e0388--
Re: Show Tables not working
am 13.01.2010 17:20:03 von h.bacik
------=_NextPart_000_00B3_01CA9474.A5A52060
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
Yes, I am sorry, I didn't use Backticks.. - I used ' not `
THX - now it works!
-----Ursprüngliche Nachricht-----
Von: Johan De Meersman [mailto:vegivamp@tuxera.be]
Bereitgestellt: Mittwoch, 13. Jänner 2010 17:11
Bereitgestellt in: gmane.comp.db.mysql.general
Unterhaltung: Show Tables not working
Betreff: Re: Show Tables not working
Then you possibly aren't using backticks, because I just tested them :-)
On Wed, Jan 13, 2010 at 3:36 PM, 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
>
>
>
>
> -----Ursprüngliche Nachricht-----
> Von: Ananda Kumar [mailto:anandkl@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
> wrote:
>
> > Try backticks.
> >
> > On Wed, Jan 13, 2010 at 2:44 PM, Intell! Soft
> > >wrote:
> >
> > > Hey
> > >
> > > Nobody any ideas?
> > >
> > >
> > >
> > >
> > > -----Ursprüngliche Nachricht-----
> > > Von: Intell! Soft [mailto:intellisoft@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=vegivamp@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=vegivamp@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
------=_NextPart_000_00B3_01CA9474.A5A52060
Content-Type: text/plain; charset=us-ascii
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
------=_NextPart_000_00B3_01CA9474.A5A52060--
Re: Show Tables not working
am 13.01.2010 17:35:04 von mos
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=
=20
a lot of grief. You can go to the data directory and see if you can browse=
=20
the directory. Maybe the OS has a problem with spaces or maybe it isn't=20
really a space in the database name. Maybe it is a special character or two=
=20
spaces?
Mike
>-----Ursprüngliche Nachricht-----
>Von: Ananda Kumar [mailto:anandkl@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
>wrote:
>
> > Try backticks.
> >
> > On Wed, Jan 13, 2010 at 2:44 PM, Intell! Soft
> > >wrote:
> >
> > > Hey
> > >
> > > Nobody any ideas?
> > >
> > >
> > >
> > >
> > > -----Ursprüngliche Nachricht-----
> > > Von: Intell! Soft [mailto:intellisoft@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=3Dvegivamp@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=3Dmos99@fastmail.fm
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg