title: how to create few tables in a single query. MySQL
body: <p>I need to create 5-10 tables in mysql using php, but i think there is better way than the create 10 queries, so my question is, how to do this with a single query? is it psosible? Every table is different.</p>
  
  <pre><code>$sql = "CREATE TABLE IF NOT EXISTS `db_countries` (
             `countrykey` int(11) NOT NULL,
             `countrynamelat` varchar(500) NOT NULL default '',
              PRIMARY KEY  (`countrykey`)
          ) ENGINE=MyISAM  DEFAULT CHARSET=utf8";
  
  mysql_query($sql);
  
    $sql2 = "CREATE TABLE IF NOT EXISTS `db_city`(
                `city_key` int(11) NOT NULL,
                `city_name` varchar(500) NOT NULL,
                `city_code` int(11) NOT NULL,
                `city_country_key` int(11) NOT NULL,
              PRIMARY KEY(`city_key`)
            ) ENGINE=MyISAM DEFAULT CHARSET=utf8";
      mysql_query($sql2) or die(mysql_error());
  </code></pre>