What does the information_schema database represent?

Posted by Mirage on Stack Overflow See other posts from Stack Overflow or by Mirage
Published on 2010-06-16T01:49:53Z Indexed on 2010/06/16 2:02 UTC
Read the original article Hit count: 203

Filed under:

information-schema

|

mysql5

I have one database in mysql.

But when i log into phpMyAdmin , it shows another database called information_schema.

Is that database always present with one database?

I mean to say is there a copy of information_schema for every database present in mysql or is there one database called inforemation_schema per mysql server?

If i modify this information_schema database how will that affect my current database?

© Stack Overflow or respective owner

Related posts about information-schema

Is It Possible to update any trigger in Information schema?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is It Possible to update any trigger in Information schema? >>> More
SQL Server: Can INFORMATION_SCHEMA Tell Me When a SQL Object Was Created?

as seen on Stack Overflow - Search for 'Stack Overflow'
Given: I added a non-nullable foreign key to a table. I settled on a way to populate the foreign key with default values. I checked in both changes to a re-runnable DB creation script. Other developers ran this script, and now they have the foreign key populated with default values on their developer… >>> More
SQL, PHP: want to get the collums of a table INFORMATION_SCHEMA gives acces denied --> alternative?

as seen on Stack Overflow - Search for 'Stack Overflow'
hi what i am trying to do is get all the collums of a table (the table can be empty) example of what i did before: SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'aTable' AND table_schema = 'theDatabase' it works perfectly on localhost however on my provider it gives: #1142… >>> More
MS SQL : Can you help me with this query?

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to run a diagnostic report on our MS SQL 2008 database server. I am looping through all of the databases, and then for each database, I want to look at each table. But, when I go to look at each table (with tbl_cursor), it always picks up the tables in the database 'master'. I think it's… >>> More
Query to return internal details about stored function in SQL Server database

as seen on Stack Overflow - Search for 'Stack Overflow'
I have been given access to a SQL Server database that is currently used by 3rd party app. As such, I don't have any documentation on how that application stores the data or how it retrieves it. I can figure a few things out based on the names of various tables and the parameters that the user-defined… >>> More

Related posts about mysql5

How to find out where or if MYSQL5 logs are stored on a machine WHM/Cpanel

as seen on Server Fault - Search for 'Server Fault'
I have a WHM/Cpanel re-seller hosting account on a virtual private server (Linux). I have root access to the machine via SSH I am trying to locate a file that contains information that will help me to determine which users have accessed what db and from which hosts. I would imagine this kind… >>> More
nginx+mysql5 loadtesting configuration strangeness

as seen on Server Fault - Search for 'Server Fault'
i am trying to setup a new server running on debian6 and trying to make it work smooth under load. i ve used a wordpress site as a test object, and tried the configurations on http://blitz.io. when i increase the mysql max_connections from 50 to 200 lots of timeouts start to occur. but on 50 , no… >>> More
Installing mysql on leopard: "Can't connect to local MySQL server through socket"

as seen on Stack Overflow - Search for 'Stack Overflow'
I migrated to a new machine and used migration assistant to copy across my files (which seemed to copy across the DBs) but I had to use macports to install Mysql (whereas last time I compiled from source via Dan Benjamin's guide). For some reason, mysql is intermittently throwing the following error; Can't… >>> More
Failed to link mysql5.1.39\bin\libmySQL.dll in a c++ project

as seen on Stack Overflow - Search for 'Stack Overflow'
When trying to link that library,I get such an error: fatal error LNK1107: invalid or corrupt file: cannot read at 0x2D0 Anyone familiar with this? >>> More
PHP5.3 is not working with MySQL5.1 IIS7 Times out

as seen on Stack Overflow - Search for 'Stack Overflow'
I have set up PHP5.3, MySQL5.1, and IIS7 on Window 7 but php doesn't want to work with MySQL. I'm assuming it is a configuration error or an incomplete install on my part. MySQL5.1 is working PHP5.3 is working, phpinfo() shows info and that i have enabled MySQL IIS is setup and using fastCgiModule… >>> More