title: mysql: set column default values for insert
body: <p>I have a sql file from mysqldump a database last month. Now all the tables in the database are added an extra column, say: </p>
  
  <pre><code>country varchar(20) not null.  
  </code></pre>
  
  <p>how to import the dump file into the database with country set to "US"? The database has data from other countries, so the database can not be deleted and re-created.</p>
  
  <p>Manually I need to do two things to the dump sql file:</p>
  
  <pre><code>1. remove all create table statements,
  2. add country("US") to all insert statements.
  </code></pre>
  
  <p>But the sql dump file is huge. Is there a good way to achieve this?
  Thanks.</p>