CREATE PROCEDURE add_new_sale(@products) BEGIN INSERT INTO sales (time) VALUES (datetime('now')); SET @sale_id = last_insert_rowid(); FOREACH @prod_id, @qty, @price ...
This package provides the excelent SQLite-net library for accessing SQLite databases in Unity. Note: Android and WebGL platforms don't support loading SQLite databases from Streaming Assets and will ...