DeProgrammer99

DeProgrammer99 t1_jdvdww3 wrote

I also add the SET clause last when writing SQL update statements. For the non-programmers out there: an update is usually in the form "UPDATE some table SET some column = some value WHERE some condition" and if you leave off the WHERE, you'll end up changing every row in the table...which is very rarely what you want to do. MySQL has a setting named "I am a dummy" that prevents you from leaving off the WHERE, too.

3