Let's say someone designed a database and left users passwords plaintext in there. Someone else comes along and wants to at least md5 them. Is there a way this person could do it with a SQL statement as opposed to running a script to do it? I'm using MySQL. I was thinking something like
yea, ok, thanks guys! I really just want to know if MYSQL could self refer like that. Another case I could use help on is I'd like to convert from a TIMESTAMP to a DATE. The Timestamp is like YYYYMMDDHHMMSS anbd I want just date. Is there a way to do it without creating another column? That is, if I just change the column type to DATE will it be alright?
on the extreme chance someone selects a all hex 32 character lowercase string as a password, put in a note that if their password suddenly does not work, to contact you.. or go to x.php to be given a password reset..