mysql: table exists

gistfile1

sub does_table_exist {
	# check wether tables exists in the database
	my ($dbHandle, $tablename) = @_;
	eval { $dbHandle->do("select count(*) from $tablename where 1=0") };
	if ($dbHandle->err) {
		# Table does not exist
		#print "Table $tablename does not exist.\n";
		return 0;
	}
	else {
		# Table exists
		return 1;
	}
}