How to check if table exists - without requiring MySQL

Site Admin Joined: Jun 04, 2004 Posts: 6433

I'm looking for a way to determine if a table should be created (sort of a self-install), without requiring MySQL. I've thought of selecting a dummy record that is required, but not used. Any other suggestions?

Posted: Fri Dec 23, 2005 8:44 am

kguske, I think Raven's Who-Is-Where block does this. Here is how he did it:

Code:




function mysql_table_exists($table) {


   $exists = mysql_query("SELECT 1 FROM `$table` LIMIT 0");


   if ($exists) return true;


   return false;


}


//   mysql_query('drop table '.$prefix.'_wiw_m');


if (!mysql_table_exists($prefix.'_wiw_m')) {


   mysql_query('create table '.$prefix.'_wiw_m (who varchar(20), mn varchar(20)) type=memory') or die('MySQL said: '.mysql_error());


}

So, it does look like he took that approach.

Posted: Fri Dec 23, 2005 9:29 am

Thanks, montego. That approach could be generalized - i.e. it should work even if another database is used, unless there is something database-specific in the create SQL. I'll give it a try...