title: MySql update all fields in a column to their default value
body: <p>I would like to be able to set default values for home_country field using update statement.</p>
  
  <p>This is by database table:</p>
  
  <pre><code>CREATE TABLE `countries` (
    `id` smallint(6) NOT NULL AUTO_INCREMENT,
    `name` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
    `home_country` tinyint(1) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
  ) ENGINE=MyISAM;
  </code></pre>
  
  <p>I'm using :</p>
  
  <pre><code>$sql = "UPDATE countries SET home_country = DEFAULT WHERE id = 1"
  </code></pre>
  
  <p>But for some reason it's not working for me.
  In the above Country, with ID 1 should have home_country value set to 1, while all other reset to 0</p>