Live Demo

Database CRUD Operations

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

Product List (5 rows)

ID Name Price Stock Category
6 Widget $9.99 100 Tools ×
7 Gadget $24.99 50 Electronics ×
8 Doohickey $4.99 200 Hardware ×
9 Thingamajig $49.99 25 Electronics ×
10 Whatchamacallit $14.99 75 General ×

Add Product (INSERT)

Aggregate Stats

5
products
$20.99
avg price
450
total stock

Edit / Reset

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

6: Widget 7: Gadget 8: Doohickey 9: Thingamajig 10: Whatchamacallit
Reset Sample Data