title: Updating a row of data in WebSQL
body: <p>WebSQL has been deprecated but it is still useful for some applications at this time.</p>
  
  <p>This is my table, I am using KnockoutJS:</p>
  
  <pre><code>&lt;table class='producttable'&gt;
  &lt;tr&gt;
      &lt;th&gt;Name&lt;/th&gt;
      &lt;th&gt;Description&lt;/th&gt;
      &lt;th&gt;Price&lt;/th&gt;
  &lt;/tr&gt;
  &lt;tbody data-bind="foreach: products"&gt;
  &lt;tr&gt;
      &lt;td&gt;&lt;input data-bind='value: name' /&gt;&lt;/td&gt;
      &lt;td&gt;&lt;input data-bind='value: description' /&gt;&lt;/td&gt;
      &lt;td&gt;&lt;input data-bind='value: price' /&gt; &lt;/td&gt;
  &lt;/tr&gt;
  &lt;/tbody&gt;
  &lt;/table&gt;
  </code></pre>
  
  <p>I have been able to save/insert data into WebSQL like this:</p>
  
  <pre><code>function saveproduct(product) {
      db.transaction(function (tx) {
          tx.executeSql('INSERT INTO products (name, description, price) VALUES (?, ?, ?)',
          [product.name, product.description, product.price]);
      });
  }
  </code></pre>
  
  <p>I am unsure on how to update one row of data in WebSQL.</p>
  
  <p>I have tried this below, but it does not work. Am I heading in the right direction?</p>
  
  <pre><code>function updateproduct(product) {
      db.transaction(function (tx) {
          tx.executeSql('UPDATE products SET name=? WHERE id=?', [product.title]);
      });
  }
  </code></pre>