title: How to create sql script that generates insert statements with tables data in mysql/mssql
body: <p>Could any one provide an example sql script that generates</p>
  
  <p>Could anyone help me out.
  Is there a way to create a script that will generate insert statements for the table with already existing data?</p>
  
  <p>There is a table with such a structure -> <strong>Country [id (int pk), name(nvarchar)]</strong> How will the script for generating such and output look like?</p>
  
  <p>Output:</p>
  
  <pre><code>INSERT INTO country (NAME) VALUES ('canada');
  
  INSERT INTO country (NAME) VALUES ('england');
  
  INSERT INTO country (NAME) VALUES ('italy');
  
  INSERT INTO country (NAME) VALUES ('spain');
  </code></pre>