Skip to content

Latest commit

 

History

History
8 lines (5 loc) · 388 Bytes

003-mysql-dummy-mode.md

File metadata and controls

8 lines (5 loc) · 388 Bytes

#MySQL Safe Update ("Dummy") Mode

mysql --safe-updates or mysql --i-am-a-dummy

Requires you to use unique identifiers when deleting rows, thus helping to prevent you from inadvertently emptying the table. For example, delete from users where 1=1 will fail since an identifying column isn't used.

Hat Tip: This HN thread: https://news.ycombinator.com/item?id=11342968