Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Common denormalized fields on orders ALTER TABLE orders ADD COLUMN subtotal DECIMAL(10,2); ALTER TABLE orders ADD COLUMN item_count INT DEFAULT 0; -- Updated via trigger or application code after order_items change -- Avoids expensive SUM() on every order fetch
Result
Open