$query=mysql_query("select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME=$db_name"); //$res=mysql_fetch_row($query); if($query) //create db else echo 'db exists!';
CREATE TABLE IF NOT EXISTS `tablename` ( `id` int(10) unsigned NOT NULL auto_increment COMMENT 'ID', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
//$res=mysql_fetch_row($query);
if($query)
//create db
else
echo 'db exists!';
CREATE TABLE IF NOT EXISTS `tablename` (
`id` int(10) unsigned NOT NULL auto_increment COMMENT 'ID',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
如果要列出所有的库,用mysql_list_dbs
$query=mysql_query("show databases");
while($res=mysql_fetch_row($query))
$data[]=$res;
if(!in_array($db_name,$data))
//create db
else
echo 'db exists!';
按你这样说的话,用if(mysql_query("use $db_name"))效果一样吧