Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Basic UPDATE UPDATE products SET price = price * 1.10, updated_at = NOW() WHERE category_id = 3; -- UPDATE with RETURNING UPDATE users SET last_login = NOW() WHERE email = 'alice@example.com' RETURNING id, name, last_login; -- UPDATE with FROM (join-based update) UPDATE order_items oi SET discounted_price = oi.unit_price * (1 - d.rate) FROM discounts d WHERE d.product_id = oi.product_id AND d.expires_at > NOW(); -- DELETE with RETURNING DELETE FROM sessions WHERE expires_at < NOW() RETURNING session_id, user_id; -- DELETE with USING (join-based delete) DELETE FROM order_items oi USING orders o WHERE oi.order_id = o.id AND o.status = 'cancelled'; -- TRUNCATE — fast bulk delete (use with care) TRUNCATE TABLE temp_import_data; -- TRUNCATE with CASCADE (also truncates referencing tables) TRUNCATE TABLE orders CASCADE;
Result
Open