ST Alpha - "just ... never forget the WHERE clause, or every user in the entire database will have their password reset to the new one." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 151

In response to "Goddamn, I love you man. " by Dr.Vermin

just ... never forget the WHERE clause, or every user in the entire database will have their password reset to the new one.

Posted by Beryllium (aka grayman) Jan 20 '11, 14:43

Also, check if your database supports transactions.

then you can do:

BEGIN;

UPDATE [...];

SELECT [... SQL to confirm that the change didn't fux0r anything];

If you screwed up, just issue "rollback;" and it restores the database to the way it was before you started. If everything looks OK, you do "commit;" and it saves the changes.

Responses:

Awesome. Again, thanks. - Dr.Vermin Jan 20, 14:47 1
- oh, yeah ... you can also do the md5 thing when editing the fields (in the drop-down menu to the left of the input box) -- nm - Beryllium Jan 20, 14:49

Post a message top

just ... never forget the WHERE clause, or every user in the entire database will have their password reset to the new one.

Replies are disabled on threads older than 7 days.