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
Yes, I am sorry, I didn't use Backticks.. - I used ' not `
THX - now it works!
-Ursprüngliche Nachricht-
Von: Johan De Meersman [mailto:vegiv...@tuxera.be]
Bereitgestellt: Mittwoch, 13. Jänner 2010 17:11
Bereitgestellt in: gmane.comp.db.mysql.general
Unterhaltung: Show
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
>
> > > -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 work
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
eas?
> >
> >
> >
> >
> > -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 Tabl
t 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 f
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
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
- 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
&g
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 milliseconds. It
is
apparently never cached
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
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_sch
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
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 Select statement that can do the same thing.
Thanks in adva
Здравствуйте, 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 idea
Hi!
I use Visual FoxPro as a front end to a MySQL server, via MyODBC 3.51.
Since I have updated MySQL from 4.1.x to 5.0.18 (SuSE RPM), I get no
result from SHOW TABLES (used for up/downloading). Any ideas?
Ivan Russell
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Thanks for your reply,
I have a query where I select all table names where the table name has PID_1
in i.e.
SHOW TABLES LIKE '%PID_1%';
However there may be cases where I need to search for tables where the table
name is PID_1 or PID_2. Do you another way I might be able to do t
haun thornburgh" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, February 02, 2005 1:03 PM
Subject: SHOW TABLES Problem
> Hi,
>
> The syntax for show tables from the manual is:
>
> SHOW [FULL|OPEN] TABLES [FROM db_name] [LIKE 'pattern']
>
> so whay doesnt the fol
Hi,
The syntax for show tables from the manual is:
SHOW [FULL|OPEN] TABLES [FROM db_name] [LIKE 'pattern']
so whay doesnt the following query work:
SHOW TABLES LIKE REGEXP 'PID_[0-9]+';
Thanks for your help
Shaun
--
MySQL General Mailing List
For list archives: http://list
"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 li
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 wondering whether it ca
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
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 ascending or descending order the same way you
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
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
each db is
completly different (unless they all use the same "SHOW TABLES" command
which I don't know if they do or not.)
As far as the first way goes you could only do it, as far as I know, in
some form of program.
-Nick
p.s. this really isn't related to MySQL becuase you are asking
Hi Everyone.
Here's a VERY unusualy problem.
We are running a mod_perl application with MySQL. One of the functions
in the program performs a "SHOW TABLE" command. This is performed with
apparently great regularity within the program.
It has begun locking a process up, at 100% CPU (All held by
After I created the mysql database, the 'show tables' command displayed the
empty set. I checked my mysql.log file and found no errors. My permission in
mysql.db and mysql.user look good (i.e., usernames seem to be correct and
all permission columns are 'Y'). Any help would be
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
EMAIL PROTECTED]]
> Sent: Monday, 3 December 2001 5:40 p.m.
> To: [EMAIL PROTECTED]
> Subject: SHOW TABLES; show nothing
>
>
[...]
> mysql> SHOW DATABASES;
> +--+
> | Database |
> +--+
> | |
> | |
> | |
> |
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
mysql> CREATE TABLE faxblast (company VARCHAR(100), phone VARCHAR(12), fax
TINYINT (10) UNSIGNED, state CHAR(2), description VARCHAR(80), sic
VARCHAR(7));
Query OK, 0 rows affected (0.09 sec)
mysql> SHOW TABLES;
Empty set (0.00 sec)
mysql> DESCRIBE
Hi.
It's been a while, but here it goes...
As far as I know, the mysql command line client does not know about
commands, i.e. the name completion feature (via TAB) is _not_ context
sensitive and will just present all completions which fit to the word
fragment you typed.
So, without knowledge wh
>Description:
this is how i find the bug.
under the mysql console, i tried to drop a table, and i know that the mysql console
do the same thing like bash
some of the command ... and the command autocomplets. OK .. let me show
mysql> drop table categor;
categories categor
I have a Coldfusion website administration function sitting on a MySQL
database. I am using a SQL query (see below) to 'show tables'. I am then
using the results to dynamically build database modification pages (enabling
administrator to modify the database structure as well as modi
hed to a database and that tables exist
M> but 'show tables;' doesn't seem to work. I am sure it is user error
M> but could you please show me my error.
IMHO sounds like a bug. I think you should submit bugreport.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Thanks for all the replies - it shows me to look a little harder next time before I
send a question to the mailing list. Thanks, but ...
I did as it told but it still return an empty set. Here are the results:
mysql> show tables;
Empty set (0.01 sec)
mysql> select da
t; > Scratch that, normally egcs and gcc are the same, at least on older
> > redhat distros. Redhat 7.0 gives you compat-egcs package which isn't the
> > same as your gcc.
> >
> > I symlinked (on a 7.1 redhat box) egcs to gcc (2.96-69) and --rebuild
> > 3.2
Daniel wrote:
>
> Scratch that, normally egcs and gcc are the same, at least on older
> redhat distros. Redhat 7.0 gives you compat-egcs package which isn't the
> same as your gcc.
>
> I symlinked (on a 7.1 redhat box) egcs to gcc (2.96-69) and --rebuild
> 3.23.38 from
Scratch that, normally egcs and gcc are the same, at least on older
redhat distros. Redhat 7.0 gives you compat-egcs package which isn't the
same as your gcc.
I symlinked (on a 7.1 redhat box) egcs to gcc (2.96-69) and --rebuild
3.23.38 from the .src.rpm.
Both show tables, show database
recompiling mysql with
> gcc 2.96
>
> Daniel wrote:
>
>> Has there been any resolution the
>> show tables;
>> show databases;
>> my @tablenames = $dbh->tables;
>> etc...
>>
>> not w
A few people have said that they've fixed it by recompiling mysql with
gcc 2.96
Daniel wrote:
>
> Has there been any resolution the
> show tables;
> show databases;
> my @tablenames = $dbh->tables;
> etc...
>
> not working on RedHat 7.X machines?
>
> --
Has there been any resolution the
show tables;
show databases;
my @tablenames = $dbh->tables;
etc...
not working on RedHat 7.X machines?
--
Daniel Bohling
NewsFactor Network
-
Before posting, please check:
h
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
>Description:
empty show tables
>How-To-Repeat:
show tables;
>Submitter-Id:
>Originator:[EMAIL PROTECTED]
>Organization:
poelzi.org
>MySQL support: none
>Synopsis: show tables return nothing. show databases too.
>Severity: serio
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/
Dear All
The following C and CXX flags will work (/usr/local/bin/gcc is actually
pgcc).
Reading specs from
/usr/local/lib/gcc-lib/i686-pc-linux-gnu/pgcc-2.95.2.1/specs
gcc version pgcc-2.95.2.1 20001224 (release).
CC='/usr/local/bin/gcc' CFLAGS='-O6 -mpentiumpro -mstack-align-double'
CXX='/u
61 matches
Mail list logo
