This content is in the "archives" of Gadgetopia . It has been moved to this subdomain as it is no longer considered relevant to the site. It is being hosted here for a indeterminate period of time. Its existence at this URL is not guaranteed, and it may be removed at any time. If you would like to refer to this content in the future, you are encouraged to save it to your local file system.

Here’s a command line switch for MySQL that’s both funny and pretty handy:

– i-am-a-dummy Synonym for option – safe-updates, -U.

Yes, there is a MySQL switch called “i-am-a-dummy”. It’s an alias of another switch, which provides more information:

– safe-updates Only allow UPDATE and DELETE that uses keys.

Now, that’s handy. This means you couldn’t accidentally wipe out your table because the system won’t process DELETEs or UPDATEs that don’t specify primary key values. Smart. It strikes me that the alias should be “i-am-not-a-dummy.”