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 Delete Example</title>
  <style>
    body {
      font-family: system-ui, sans-serif;
      margin: 0;
      padding: 1.5rem;
      background: #f8fafc;
      color: #334155;
      line-height: 1.6;
    }
    h1 { margin: 0 0 0.75rem; font-size: 1.25rem; color: #0f172a; }
    button {
      padding: 0.6rem 1.1rem;
      font-size: 0.9375rem;
      background: #dc2626;
      color: #fff;
      border: none;
      border-radius: 8px;
      cursor: pointer;
    }
    button:hover { background: #b91c1c; }
    #status {
      margin-top: 1rem;
      padding: 0.75rem 1rem;
      max-width: 460px;
      background: #fff;
      border: 1px solid #e2e8f0;
      border-radius: 8px;
      font-size: 0.875rem;
      min-height: 1.5rem;
    }
  </style>
</head>
<body>
  <h1>Delete Records from Web SQL</h1>
  <button type="button" id="deleteBtn">Delete Record with ID 1</button>
  <p id="status"></p>

  <script>
    if (!window.openDatabase) {
      document.getElementById('status').textContent =
        'Web SQL is not supported in this browser.';
    } else {
      var db = openDatabase('myDatabase', '1.0', 'Test DB', 2 * 1024 * 1024);

      db.transaction(function (tx) {
        tx.executeSql(
          'CREATE TABLE IF NOT EXISTS items (id INTEGER PRIMARY KEY, name TEXT)'
        );
        tx.executeSql(
          'INSERT OR IGNORE INTO items (id, name) VALUES (?, ?)',
          [1, 'Sample Record']
        );
      });

      document.getElementById('deleteBtn').addEventListener('click', function () {
        deleteRecord(1);
      });

      function deleteRecord(id) {
        db.transaction(function (tx) {
          tx.executeSql(
            'DELETE FROM items WHERE id = ?',
            [id],
            function (tx, result) {
              document.getElementById('status').textContent =
                result.rowsAffected
                  ? 'Deleted id ' + id
                  : 'No row found for id ' + id;
            },
            function (tx, error) {
              document.getElementById('status').textContent =
                'Error: ' + error.message;
              return true;
            }
          );
        });
      }
    }
  </script>
</body>
</html>
Lines: 0 | Characters: 0
Live Preview Auto-refresh on Run
Web SQL DELETE — Complete HTML Page
