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 as you can get from 'SHOW'
commands. Every
Ok, so how do I disable that?
- Mark
-Original Message-
From: John Daisley [mailto:john.dais...@mypostoffice.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 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 account. I
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 know that it shows up under any account. I
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 is instant
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]
?
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: Data Types
For more information, type 'help item', where item is one of the following
topics
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
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