title: Delphi 7: ADO, need basic coding example
body: <p>I am a complete beginner here. Can someone please post some Delphi code to    </p>
  
  <ul>
  <li>create a database</li>
  <li>add a simple table</li>
  <li>close the database</li>
  </ul>
  
  <p>then, later</p>
  
  <ul>
  <li>open a database</li>
  <li>read each table</li>
  <li>read each field of a given table</li>
  <li>perform a simple search</li>
  </ul>
  
  <p>Sorry to be so clueless. I did google, but didn't find a useful tutorial ...</p>
  
  <p>In addition, it would be useful if the underlying database were MySql (5.1.36) (I don't even know if that makes any difference)</p>