HTML Code
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>Web SQL UPDATE by condition</title>
  <style>
    body { font-family: system-ui, sans-serif; margin: 1.5rem; line-height: 1.5; }
    button { margin-right: 0.5rem; margin-bottom: 0.5rem; padding: 0.5rem 0.9rem; cursor: pointer; }
    #status { margin-top: 1rem; }
  </style>
</head>
<body>
  <h1>Update by condition</h1>
  <p>Mark every open task as done with <code>UPDATE ... WHERE done = ?</code>.</p>

  <button type="button" id="seedBtn" disabled>Seed tasks</button>
  <button type="button" id="markBtn" disabled>Mark open as done</button>
  <button type="button" id="listBtn" disabled>List tasks</button>

  <p id="status">Checking Web SQL&hellip;</p>

  <script>
    var statusEl = document.getElementById('status');

    if (!window.openDatabase) {
      statusEl.textContent = 'Web SQL is not available in this browser.';
    } else {
      var db = openDatabase('tryitWsqlUpdateWhere', '1.0', 'Try It', 1024 * 1024);

      db.transaction(function (tx) {
        tx.executeSql(
          'CREATE TABLE IF NOT EXISTS tasks (id INTEGER PRIMARY KEY, title TEXT, done INTEGER)'
        );
      }, null, function () {
        statusEl.textContent = 'Ready.';
        document.getElementById('seedBtn').disabled = false;
        document.getElementById('markBtn').disabled = false;
        document.getElementById('listBtn').disabled = false;
      });

      document.getElementById('seedBtn').addEventListener('click', function () {
        db.transaction(function (tx) {
          tx.executeSql('DELETE FROM tasks');
          tx.executeSql('INSERT INTO tasks (id, title, done) VALUES (?, ?, ?)', [1, 'Write docs', 0]);
          tx.executeSql('INSERT INTO tasks (id, title, done) VALUES (?, ?, ?)', [2, 'Ship feature', 1]);
          tx.executeSql('INSERT INTO tasks (id, title, done) VALUES (?, ?, ?)', [3, 'Fix bug', 0]);
        }, null, function () {
          statusEl.textContent = 'Seeded 3 tasks (2 open, 1 done).';
        });
      });

      document.getElementById('markBtn').addEventListener('click', function () {
        db.transaction(function (tx) {
          tx.executeSql(
            'UPDATE tasks SET done = ? WHERE done = ?',
            [1, 0],
            function (tx, result) {
              statusEl.textContent = 'Marked ' + result.rowsAffected + ' task(s) done.';
            }
          );
        });
      });

      document.getElementById('listBtn').addEventListener('click', function () {
        db.transaction(function (tx) {
          tx.executeSql(
            'SELECT title, done FROM tasks ORDER BY id',
            [],
            function (tx, result) {
              if (result.rows.length === 0) {
                statusEl.textContent = 'No tasks. Seed first.';
                return;
              }
              var parts = [];
              for (var i = 0; i < result.rows.length; i++) {
                var row = result.rows.item(i);
                parts.push(row.title + (row.done ? ' (done)' : ' (open)'));
              }
              statusEl.textContent = parts.join(', ');
            }
          );
        });
      });
    }
  </script>
</body>
</html>
Lines: 0 | Characters: 0
Live Preview Auto-refresh on Run
Web SQL UPDATE — Update by Condition
