Checking wether a database exists before creating one

[no_maam]

How do i check wether a database exists before creating one?
Thanks!

[TheDefender]

DROP DATABASE IF EXISTS 'databasename';
CREATE DATABASE 'databasename';

[celibate54]

or you can just do

SHOW DATABASES

and that will show you every database currently available to you

[no_maam]

@
I want to add a script to my PHP application that checks if the database exists (usefull when running the application for the first time on a server).

[drew010]

$dbtoadd = "someNewDb";

//mysql connect stuff here

$query = "SHOW DATABASES";

$result = mysql_query($query);

$dbExists = false;

while($data = mysql_fetch_row($result)) {
    if($data[0] == $dbtoadd) {
        $dbExists = true;
        break;
     }
}

if ($dbExists) {
    //dont create
} else {
    /do create
}

[no_maam]

Thanks drew010!