title: How to insert data in different tables using MySql database?
body: <p>Normally I insert data in MySql in one table (sales) example.</p>
  
  <pre><code>string query = "INSERT INTO sales (price, user, date) " +
                               "VALUES(" +
                               "'" + txtQuant.Text + "'," +
                               "'" + txtLog.Text + "'," +
                                "NOW())";
  </code></pre>
  
  <p>But now I change my mind and decided to separately create another table which will I name settings for column price. this is my first time to do this so I have no idea what to do.</p>
  
  <p>I tried this.</p>
  
  <pre><code>string query = "INSERT INTO sales (user, date), settings (price) " +
                               "VALUES(" +
                               "'" + txtLog.Text + "'," +
                                "NOW())", "'" + txtQuant.Text + "'";
  </code></pre>
  
  <p>but it doesn't work.</p>