disable safe update
# Disables safe update temporarily 
SET SQL_SAFE_UPDATES = 0;

# Updates multiple rows at once
UPDATE notes SET priority = 100 WHERE priority = 0;

# Enables safe update
SET SQL_SAFE_UPDATES = 1;
by Valeri Tandilashvili
4 years ago
MySQL
alter
1
Pro tip: use ```triple backticks around text``` to write in code fences