# One case per line: label|setup (optional, runs with safe updates off)|statement (runs with sql_safe_updates=1) no WHERE (UPDATE)||UPDATE orders SET status='x' no WHERE (DELETE)||DELETE FROM orders WHERE 1=1||UPDATE orders SET status='x' WHERE 1=1 WHERE TRUE||UPDATE orders SET status='x' WHERE TRUE WHERE id > 0 (primary key)||UPDATE orders SET status='x' WHERE id > 0 WHERE id <> -1 (primary key)||UPDATE orders SET status='x' WHERE id <> -1 WHERE id IS NOT NULL (primary key)||UPDATE orders SET status='x' WHERE id IS NOT NULL WHERE id = id (primary key)||UPDATE orders SET status='x' WHERE id = id WHERE id = 5 OR 1 (typo)||UPDATE orders SET status='x' WHERE id = 5 OR 1 WHERE customer_id > 0 (indexed column)||UPDATE orders SET status='x' WHERE customer_id > 0 WHERE customer_id = 7 (indexed, 20 rows)||UPDATE orders SET status='x' WHERE customer_id = 7 WHERE customer_id + 0 = 7 (same 20 rows)||UPDATE orders SET status='x' WHERE customer_id + 0 = 7 WHERE status = 'new' (unindexed column)||UPDATE orders SET status='x' WHERE status = 'new' WHERE status = 'new' LIMIT 100000||UPDATE orders SET status='x' WHERE status = 'new' LIMIT 100000 no WHERE, LIMIT 100000 (UPDATE)||UPDATE orders SET status='x' LIMIT 100000 no WHERE, LIMIT 100000 (DELETE)||DELETE FROM orders LIMIT 100000 WHERE id IN (subquery on itself)||UPDATE orders SET status='x' WHERE id IN (SELECT id FROM (SELECT id FROM orders) s) multi-table UPDATE, no WHERE||UPDATE orders o JOIN customers c ON c.id = o.customer_id SET o.status='x' multi-table UPDATE, WHERE c.id > 0||UPDATE orders o JOIN customers c ON c.id = o.customer_id SET o.status='x' WHERE c.id > 0 through a view, no WHERE|CREATE VIEW v_orders AS SELECT * FROM orders|UPDATE v_orders SET status='x' inside a stored procedure, no WHERE|CREATE PROCEDURE wipe() UPDATE orders SET status='x'|CALL wipe() TRUNCATE||TRUNCATE TABLE orders