Originally Posted by Old Pedant
Ummm...why would they put it in there if it was evil?
Every major database system--and even Microsoft's "toy" Access database--provides it.
I think maybe the only reason it has a bad rep in MySQL is because it isn't supported by idiotic MyISAM. So if you were depending on it working and then forgot and used MyISAM...*KABLOOEY*.
Maybe because it is soooo easy to trash a whole bunch of data with the click of a button?!
I have just picked that up from others over time. (Maybe just like I have gotten that silly idea in my head that "Natural Keys" are evil?!)