---+
> | 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
.
Regards
John
> I have been meaning to find out about this since I moved to mysql 5.
> In version 4, I never saw the table "information schema". With it
> being in version 5, I assume it was something only the root users, or
> a higher level user could see.
>
> I now k
I have been meaning to find out about this since I moved to mysql 5.
In version 4, I never saw the table "information schema". With it
being in version 5, I assume it was something only the root users, or
a higher level user could see.
I now know that it shows up under any a
We have a pretty large database (several terabytes and hundreds of tables).
When I do a simple query from the information schema, e.g. select table_name
from tables, it can minutes to come back with the answer. Yet, if I do a
show tables, describe or "show create table" the response
alent columns from INFORMATION_SCHEMA,
> as similar as possible ?
I do not think you can use the information schema to get this
information. However you can use help:
For server side help, type 'help contents'
mysql> help DATA TYPES
You asked for help about help category: &
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]
Hi all!
Well, question is how could I to retrieve information about
types supported . In PostgreSQL the query would be:
--
SELECT pg_type.oid, typname, usename, obj_description(pg_type.oid)
FROM pg_type, pg_user
WHERE typowner=usesy
All,
I've searched the help and even found this very useful link
http://www.xcdsql.org/Misc/MySQL_INFORMATION_SCHEMA.html regarding all the
Information schemas.
What I can find is information regarding some way to retrieve the number of
pages used to store an index. Perhaps this is because th
