title: MySqlDataAdapter doesn't clear DataTable when select query returns no rows?
body: <p>I don't understand How the <code>MySQL Data Adapter Fill</code> method really works. Everything was working fine until i try to fill a data table from and empty MySQL table. The Data Table doesn't get cleared to reflect the empty MySQL Table Why? </p>
  
  <p>In my database I have multiple tables with the exact same schema but one table is empty and the other has rows.</p>
  
  <p>Scenario 1: </p>
  
  <p>lets say I run the fill method on an empty data Table and the select command on a MySQL table with rows The data table is filled accordingly.</p>
  
  <p>scenario 2</p>
  
  <p>lets say I run the Fill method on same data table (which has rows now) but I run the select command on a different MySQL table which also has rows but the same exact schema. The Data Table gets cleared and filled to reflect this new MySQL Table.</p>
  
  <p>scenario 3: </p>
  
  <p>lets say I run the Fill method on same data table (which has rows now) but I run the select command on a different MySQL table with no rows but same exact schema. The Data Table Doesn't get cleared to reflect the empty MySQL Table Why? </p>