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
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 Admin
10 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
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 Meers
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
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 Nachr
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:intellis...@fachoptiker.net]
> Bereitgestellt: Freitag, 08. Jänner 2010 11:06
> Bereitgestellt in: gmane.comp.db.mysql.general
>
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
In the last episode (Aug 15), Laurence Meyer said:
> We have a production database that has 4,000+ tables. For a variety of
> reasons, our CGIs always have to run "show tables" to generate a list of
> all tables in the database.
>
> This is by far our slowest query; it currently takes about 100
>
- Original Message
> From: Laurence Meyer
> To: mysql@lists.mysql.com
> Sent: Sunday, 16 August, 2009 7:09:25
> Subject: show tables is slow/uncached
>
> We have a production database that has 4,000+ tables. For a variety of
> reasons,
> our CGIs always
> have to run "show tables"
Ok, thank you all. It was my mistake. I have quoted the SQL command with
single quotes under Windows.
Octavian
- Original Message -
From: "Stijn Verholen" <[EMAIL PROTECTED]>
To: "Octavian Rasnita" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, May 01, 2007 1
On Tue, May 1, 2007 09:57, Stijn Verholen wrote:
> Octavian Rasnita wrote:
>>
>> mysql -u user -p database -e 'show tables;' > file.txt
That one works for me, with a litle change. -s (kill's columnnames a.o.).
[EMAIL PROTECTED]:~# mysql -s -u rppt test -e 'show tables;' > file.txt
[EMAIL PROTECT
Octavian Rasnita wrote:
Hi,
I want to print the list of tables (one on a line) from a database
into an external file.
I have tried:
mysql -u user -p database -e 'show tables;' > file.txt
mysql -u root -p information_schema -e 'select table_name from tables
where table_schema="database_name"
On 7/6/06, Ed Reed <[EMAIL PROTECTED]> wrote:
Thanks for the helpful words. The fact of the matter is that I would love to
upgrade but since 5.0x doesn't have all the capabilities of 4.1x, an upgrade is
out of the question at this time. So I'm left to looking here for help.
What? An higher ve
Thanks for the helpful words. The fact of the matter is that I would love to
upgrade but since 5.0x doesn't have all the capabilities of 4.1x, an upgrade is
out of the question at this time. So I'm left to looking here for help.
Thanks for your time.
Anyone else have an idea on this?
>>> "Joc
On 7/6/06, Ed Reed <[EMAIL PROTECTED]> wrote:
Anyone have an idea on this?
Upgrade. Or at least stop repeating the question.
Jochem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Anyone have an idea on this?
Thanks
>>> "Ed Reed" <[EMAIL PROTECTED]> 7/5/06 1:54:25 PM >>>
Anyone have an idea on this?
Thanks
>>> "Ed Reed" < [EMAIL PROTECTED] > 6/30/06 2:51:44 PM >>>
Opps!
Thanks for the quick reply, Dan. But I forgot to mention I'm running MySQL
4.1.11
Any other sugges
Anyone have an idea on this?
Thanks
>>> "Ed Reed" <[EMAIL PROTECTED]> 6/30/06 2:51:44 PM >>>
Opps!
Thanks for the quick reply, Dan. But I forgot to mention I'm running MySQL
4.1.11
Any other suggestions?
Thanks again.
>>> Dan Nelson < [EMAIL PROTECTED] > 6/30/06 2:48:57 PM >>>
In the last e
Opps!
Thanks for the quick reply, Dan. But I forgot to mention I'm running MySQL
4.1.11
Any other suggestions?
Thanks again.
>>> Dan Nelson <[EMAIL PROTECTED]> 6/30/06 2:48:57 PM >>>
In the last episode (Jun 30), Ed Reed said:
> Is there a Select statement I can use to get table names so th
In the last episode (Jun 30), Ed Reed said:
> Is there a Select statement I can use to get table names so that I
> could use other Select statement syntax on the results?
>
> What I'd like to do is this,
>
> SHOW Replace(TABLES, 'tbl','') Like 'tbl%';
>
> But this doesn't work so I need a Sel
Здравствуйте, Ivan.
Вы писали 14 июня 2006 г., 21:57:16:
IR> Hi!
IR> I use Visual FoxPro as a front end to a MySQL server, via MyODBC 3.51.
IR> Since I have updated MySQL from 4.1.x to 5.0.18 (SuSE RPM), I get no
IR> result from SHOW TABLES (used for up/downloading). Any ideas?
IR> Ivan Russell
his?
From: "Gabriel PREDA" <[EMAIL PROTECTED]>
Reply-To: "Gabriel PREDA" <[EMAIL PROTECTED]>
To: "shaun thornburgh"
<[EMAIL PROTECTED]>,
Subject: Re: SHOW TABLES Problem
Date: Wed, 2 Feb 2005 13:48:43 +0200
Because it does not know REGEXP... only LIKE patter
Because it does not know REGEXP... only LIKE patterns...
% Matches any number of characters, even zero characters
_ Matches exactly one character
Taake a look in chapter 13 "String Comparison Functions".
Gabriel PREDA
- Original Message -
From: "shaun thornburgh" <[E
"Robert Morgan" <[EMAIL PROTECTED]> wrote:
>
> Hi, I'm populating a dropdown with table names so the user can then choose the table
> he/she wishes to
> edit. However I just want to show the lookup tables. I tried "show tables from DB
> where table like 'lkp' ;"
> but got an error; I'm just won
At 23:36 -0500 3/21/03, Bernard Miville wrote:
Hi,
I am using MySQL 3.23.
I use SHOW TABLES to obtain a list of tables from my database and
then put this list in an HTML select form on a web page. What I need
to
know, is there a way of obtaining this table list, using SHOW TABLES,
in ascendi
Kip,
Monday, October 07, 2002, 4:03:05 AM, you wrote:
KK> Is it possible to do a "show tables" similar to a select statement
KK> where ...
KK> similar to: select field where anotherfield like "ABC%" gives matches
KK> for all "field" which begins with ABC
KK> I'd like to say
KK> show tables li
Is it possible to do a "show tables" similar to a select statement
where ...
similar to: select field where anotherfield like "ABC%" gives matches
for all "field" which begins with ABC
I'd like to say
show tables like "ABC%"
ie. to get a list of all tables whose name begins with ABC.
Than
DB independent? As in an entire list of tables in your MySQL server? Or as
in independent from MySQL to say MS SQL Server? If the later then I'm sure
each db as some form of query to get a list of tables, just look it up. I
don't think there would be a unified way simple because each db is
complet
good use of it too. I.E. samba.
Which SHOULD I be using?
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 12:39 AM
To: Gill, Vern
Cc: [EMAIL PROTECTED]
Subject: Re: SHOW TABLES; show nothing
Hi.
On Mon, Dec 03, 2001 at 11:41:38PM
Hi.
On Mon, Dec 03, 2001 at 11:41:38PM -0800, [EMAIL PROTECTED] wrote:
> These areI thinkpre-built
> Dunno for sure.
>
> # rpm -qa | grep -i glibc
> compat-glibc-6.2-2.1.3.2
> glibc-devel-2.2-5
> glibc-common-2.2.4-13
> glibc-2.2.4-13
> # mysql --version
> mysql Ver 11.6 Distrib 3.23.28
as from any MySQL developers listening?
>
> -Original Message-
> From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 03, 2001 4:22 PM
> To: Quentin Bennett
> Cc: 'Gill, Vern'; [EMAIL PROTECTED]
> Subject: Re: SHOW TABLES; show nothing
&
r 1
make[1]: Leaving directory `/src/mysql-3.23.46'
make: *** [all-recursive-am] Error 2
Any help there?
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 10:44 PM
To: Gill, Vern
Cc: [EMAIL PROTECTED]
Subject: Re: SHOW TABLES; show noth
Seems ok to me...
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 11:19 AM
To: 'Gill, Vern'; [EMAIL PROTECTED]
Subject: RE: SHOW TABLES; show nothing
Hi,
Try myisamchk'ing you mysql tables.
Regards
Quentin
-Original Me
?
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 4:22 PM
To: Quentin Bennett
Cc: 'Gill, Vern'; [EMAIL PROTECTED]
Subject: Re: SHOW TABLES; show nothing
Hi.
I remember this beeing reported once before. The answer supposed t
Hi.
I remember this beeing reported once before. The answer supposed that
it was a problem with the compiler shipped with Red Hat. The mail is:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:67476:ololjemolklapaobokil
(and the next in thread).
If this is indeed the case, a simple fix is to use th
Hi,
Try myisamchk'ing you mysql tables.
Regards
Quentin
-Original Message-
From: Gill, Vern [mailto:[EMAIL PROTECTED]]
Sent: Monday, 3 December 2001 5:40 p.m.
To: [EMAIL PROTECTED]
Subject: SHOW TABLES; show nothing
mysql> CREATE TABLE faxblast (company VARCHAR(100), phone VARCHAR(12
I have had the same problem on a Redhat 7.0 box w/2.4.1 kernel with
mysql versions 3.23.32 thru 3.23.37
The tables and databases are there and are usable, but 'show databases'
and 'show tables' return nothing. We've installed this version on
another machine and it works fine. Must be a library
Hi Greg,
If you are speaking about show tables returns blank lines, than thank you
very much and I hope you will find it! Please, keep us on track!
Best regards,
Lumberer.
On Mon, Mar 12, 2001 at 09:57:28PM +, Greg Cope wrote:
> The following C and CXX flags will work (/usr/local/bin/gcc i
38 matches
Mail list logo
