---+
> | information_schema |
> | hgallery |
> ++
> 2 rows in set (0.00 sec)
>
> mysql>
>
> Ok, so how do I disable that?
>
> - Mark
>
>
> -Original Message-
> From: John Daisley [mailto:john.dais...@my
postoffice.co.uk]
Sent: woensdag 29 april 2009 5:58
To: Scott Haneda
Cc: mysql@lists.mysql.com
Subject: Re: Information Schema
Scott
Information_schema is a virtual database only. I think it was added in
MySQL 5.0.2 to comply with SQL:2003 specifications.
information_schema provides the same info
Scott
Information_schema is a virtual database only. I think it was added in
MySQL 5.0.2 to comply with SQL:2003 specifications.
information_schema provides the same info as you can get from 'SHOW'
commands. Every user automatically has select privs for information_schema
and its not possible to
On Tue, Mar 18, 2008 at 9:58 AM, Carlos Savoretti
<[EMAIL PROTECTED]> wrote:
> Hi all!
>
> Well, question is how could I to retrieve information about
> types supported . In PostgreSQL the query would be:
>
> --
> SELECT pg_type.oi
Carlos Savoretti schrieb:
Hi all!
Well, question is how could I to retrieve information about
types supported.
IMHO, no
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> are you asking how is it you can access information in a MySQL DB without
> connecting to MySQL DB?
>
> please elaborate
>
No, the thing is that I'm already running in the mysqld process because I'm
talking about a custom engine library that I wrote.
So my code runs inside mysql, hence I don
Currently, everything you listed can be done via queries to the server. Take
a look at the MySQL manual for all the queries and their requisite responses.
And I'm quite sure what you want to do has already been done. Please take a
look at MySQL CC and MySQL Administrator (both available from
Waseem Ahmad Zia <[EMAIL PROTECTED]> wrote:
>
> I require information that latest version(4.0.15) of mysql provides support for
> executing subqueries and prepared statement,if it is possible in this new version of
> mysql then i require information about drivers for prepared state ment and how
Waseem Ahmad Zia wrote:
Hello hi
I require information that latest version(4.0.15) of mysql provides
support for executing subqueries and prepared statement,if it is
possible in this new version of mysql then i require information about
drivers for prepared state ment and how to user sub quries in
Florian Litot wrote:
>
> hi,
>
> Somebody saw comparaisons of productivity for mysql and others RDBMS?
> or somebody do comparaisons?
>
> thanks
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (th
I do this with
select db;
show tables;
then parse through the result.
Niclas Hedhman wrote:
>On Wednesday 09 October 2002 21:43, Inbal Ovadia wrote:
>
>
>>Hi all,
>>There is a way to know if I have table x in my db?
>>Let's say some catalog tables that hold information about the db like
>
On Wednesday 09 October 2002 21:43, Inbal Ovadia wrote:
> Hi all,
> There is a way to know if I have table x in my db?
> Let's say some catalog tables that hold information about the db like
> tables name etc.
> and i can do query like "select tables from catalogName" and get all the
> tables in t
Sure you can.
show tables like 's%' from mydatabase;
Iikka Meriläinen wrote:
>On Wed, 9 Oct 2002, Inbal Ovadia wrote:
>
>
>
>>Hi all,
>>There is a way to know if I have table x in my db?
>>Let's say some catalog tables that hold information about the db like tables
>>name etc.
>>and i can do
show tables;
show tables from catalogName;
show tables from catalogName like 'order%';
-J
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf
Of Iikka Meriläinen
Sent: Wednesday, October 09, 2002 10:09 AM
To: Inbal Ovadia
Cc: '[EMAIL PROTECTE
On Wed, 9 Oct 2002, Brian Reichert wrote:
> On Wed, Oct 09, 2002 at 03:43:15PM +0200, Inbal Ovadia wrote:
> > Hi all,
> > There is a way to know if I have table x in my db?
> > Let's say some catalog tables that hold information about the db like tables
> > name etc.
> > and i can do query like "
show tables;
On Wednesday, Oct 9, 2002, at 05:43 America/Anchorage, Inbal Ovadia
wrote:
> Hi all,
> There is a way to know if I have table x in my db?
> Let's say some catalog tables that hold information about the db like
> tables
> name etc.
> and i can do query like "select tables from cata
On Wed, 9 Oct 2002, Inbal Ovadia wrote:
> Hi all,
> There is a way to know if I have table x in my db?
> Let's say some catalog tables that hold information about the db like tables
> name etc.
> and i can do query like "select tables from catalogName" and get all the
> tables in the db
Hi,
I g
On Wed, Oct 09, 2002 at 03:43:15PM +0200, Inbal Ovadia wrote:
> Hi all,
> There is a way to know if I have table x in my db?
> Let's say some catalog tables that hold information about the db like tables
> name etc.
> and i can do query like "select tables from catalogName" and get all the
> table
Hi,
No problem so far with mysql 4.0.x, no crash at all on a production server
with a really high load.
If you want to use mysql 4.0.2, take a look here :
http://www.mysql.com/doc/I/n/Installing_source_tree.html
Best Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Je
So it's better using 4.0.1 of 4.0.2?
Jean-Francois Dionne
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Jean-Francois Dionne" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 15, 2002 8:12 PM
Subject
On Fri, Feb 15, 2002 at 08:03:19PM -0500, Jean-Francois Dionne wrote:
> I see people speaking about mysql 4.0.2... but where you get it?
> they write some thing about it on web page but 4.0.2 is not in the
> download list...
It's from the MySQL source tree. See this url:
http://www.mysql.com
Hmmm. That's a pretty generic statement. There are lots of different ways
to get information from a database. Need more info.
Ryan Sander
Web Developer
[EMAIL PROTECTED]
http://www.cantonrep.com
> --
> From: sunil nair
> Sent: Wednesday, November 28, 2001 8:20 AM
> To
Read The Manual!
- Original Message -
From: "sunil nair" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 28, 2001 7:20 AM
Subject: information retrival from database
please mail me a detailed note on
information retrival from database.
address:[EMAIL PROT
http://devshed.com/Server_Side/MySQL/Intro/
At 11:22 AM 8/22/2001 -0500, randys wrote:
>I am a user whom it loves to use the services of mysql, but do not have
>like beginning, please to send the manuals to me of as to begin to work
>this fabulous manejador of data base
>
>att. randy ochoa
Ch
http://www.mysql.com/ es la pagina de mysql. Desde alli puede encontrar
la documentacion - en varios formatos- es de las mejores que pueda
conseguir.
Happy reading,
---
Claudia M. Castaneda
Phone 301 286 3397
On Wed, 22 Aug 2001, randys wrote:
> I am a user whom it loves to use the se
On Sat, Jun 02, 2001 at 04:30:29PM +0200, Nimeesh Patel wrote:
> i want to know is there any size limit(no. of rows) for mysql
> created table. In my case table contain only four cloumn
> date,ip_address(varchar[20],tx_bytes(integer),rx_bytes(integer). i
> want to maintain a huge database of t
Ken Menzel wrote:
>
> Bonjour Hassan,
> Il y a une liste français du MySQL que je viens de trouver.
> Peut-être ça t'aide.
> [EMAIL PROTECTED]
>
> En Plus, il y a php-france,
> envoyez un mail à [EMAIL PROTECTED]
>
> Je suis un participant tous les deux. J'espère que je t'y verra!
>
> Amica
icalement,
Ken
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message -
From: "hassan el forkani" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Samir Baghdadi" <[EMAIL PROTECTED]>; <[EMAIL PROTE
At 01:56 23/04/01 -0700, Van wrote:
>hassan el forkani wrote:
> >
> > j'ai eu le meme probleme mais en environnement de développement, ce que je
> > sait c'est que ca dépend du characterset de votre base de donnée faut
> > demander à votre hebergeur le characterset (dans les "environnement
> > var
TED]
- Original Message -
From: "hassan el forkani" <[EMAIL PROTECTED]>
To: "Samir Baghdadi" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, April 22, 2001 6:21 AM
Subject: Re: Information Technique
> j'ai eu le meme probleme mais
hassan el forkani wrote:
>
> j'ai eu le meme probleme mais en environnement de développement, ce que je
> sait c'est que ca dépend du characterset de votre base de donnée faut
> demander à votre hebergeur le characterset (dans les "environnement
> variables") du serveur mysql ou votre base est he
j'ai eu le meme probleme mais en environnement de développement, ce que je
sait c'est que ca dépend du characterset de votre base de donnée faut
demander à votre hebergeur le characterset (dans les "environnement
variables") du serveur mysql ou votre base est hebergée
At 23:33 21/04/01 +020
Samir Baghdadi wrote:
>
> Salut Mr/Mme,
>
> J'ai une question précise : Comment coder les
> caractères spéciaux (de type à, é,..) dans une BDD
> MySql
>
> Le problème c'est que j'ai developpé avec JSP un site
> en utilisant le Système d'exploitation Windows (les
> essais étaient positifs).
> Lo
Chidamparam writes:
> Hi,
> We are a Telecom Software Product Development company, developed a product
> on Windows NT platform with MS SQL Server 2000 Database,
> inserting around 3 million records/month (in one table), the database grows
> to 20GB/month and the database will be accessed sim
1: No
2: No
3: Not Yet
Cal
http://www.calevans.com
-Original Message-
From: Chidamparam [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 5:46 AM
To: '[EMAIL PROTECTED]'
Subject: information
Hi,
We are a Telecom Software Product Development company, developed a product
on Wind
1) How was it 'installed' Did you use RPMs, the source, or a bindist?
2) Did you make sure mysqld wasn't already running? 'ps auxwww | grep
mysqld'
Mani kandan Ramachandran wrote:
>
> Respected Sir/Madam
>
> While i configure mysql in my RedHat 7.0,it gives problem.And i do not
> know how t
36 matches
Mail list logo
