title: how to Insert data from Online MySQL database to Local MySQL datatable Frequently using sql query?
body: <p>I have to MySQl databases, 1st is online hosted named <strong>onlinedb</strong>, and second is on local machine(localhost) named <strong>localdb</strong>, now i want to insert online database's data to my local host's database table <strong>frequently and as per user request</strong>, and i am using <strong>VB6</strong> for my application. so how can i do it using query?</p>
  
  <p>My destination and source database are on different location, destination database is on local host, and source database is online hosted on server.</p>
  
  <p>I have tried this query, but it is not working.</p>
  
  <p>Query:</p>
  
  <pre><code>"INSERT INTO localdb.mytable SELECT * FROM onlinedb.mytable  WHERE mytable.Id=0"
  </code></pre>
  
  <p>Thank you in advance.</p>