What Is This Called?

[samXR]

hey i got a question.at the side of SQLyog.there is “infomation_schema” , “my_bd” , “mysql” and “test”.what is that called??

Then if i click on the plus sign of test..then a few column pop out..What is that called too??

i need to know the names because i have to execute some php codes with that 'unknown' name..

Any help would be great..thanks a lot..

[peterlaursen]

“infomation_schema” , “my_bd” , “mysql” and “test” are the databases on the server. If you click the + objects (tables and other objects) in each databases will show.

“infomation_schema” and “mysql” are mysql system databases.

“test” is a database that gets installed when mysql get installed. This is not impotant. Actually it is recommended to drop it on production servers.

“my_bd” must be a database that you or some application-installer created.

[samXR]

peterlaursen wrote on Jun 16 2009, 07:33 AM:

“infomation_schema” , “my_bd” , “mysql” and “test” are the databases on the server. If you click the + objects (tables and other objects) in each databases will show.

“infomation_schema” and “mysql” are mysql system databases.

“test” is a database that gets installed when mysql get installed. This is not impotant. Actually it is recommended to drop it on production servers.

“my_bd” must be a database that you or some application-installer created.

what are their name??

i need to extract them in my php codes..

i need to replace particulars with the “name”..

thank you..

:::::::::::::::::::::php codes:::::::::::::::::

Select a Database Name :

“.$row['Name'].”n”;

}

?>

[peterlaursen]

I do not understand. The name of the databases are what SQLyog displayes (“test” etc.)

In a SELECT statement like “SELECT * FROM Particulars”, 'Particular' is a table and not a database. You may write the full syntax like “SELECT * FROM somedatabase.Particulars ” or you may send a “USE somedatabase”.

[Author]

Posts