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 enables you to easily explore all tables and content that is saved in your database. Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated ...