Live Demo

Database CRUD Operations

Connect, query, insert, update, and delete with SQLite via ADODB

Product List (2 rows)

ID Name Price Stock Category
7 Gadget $24.99 50 Electronics ×
8 Doohickey $4.99 200 Hardware ×

Add Product (INSERT)

Aggregate Stats

2
products
$14.99
avg price
250
total stock

Edit / Reset

Click a row id below to edit, or reset all data.

7: Gadget 8: Doohickey
Reset Sample Data