- Joined
- Jan 19, 2007
- Posts
- 2,207
- Reaction score
- 47
I've searched and think I'm getting closer but can't find answers which work.
I have two problems to solve. Can anyone help?
(1) I'm trying to convert a bunch of dates in a mysql db from varchar(20) eg. stored as "Aug 28, 2006" into int(10) format e.g. "1156741200" but can't figure out the sql query to run.
(2) I have a table with user info in it. Passwords are stored there encrypted md5. I need to change everyone's password. I could generate a list of plain text random passwords and put them in a column next to the user id's. I'm not sure of how to get the md5 version of the random password that I give them. Also I'm guessing the sql query would be:
Any help really appreciated... my headache is now full blown!
I have two problems to solve. Can anyone help?
(1) I'm trying to convert a bunch of dates in a mysql db from varchar(20) eg. stored as "Aug 28, 2006" into int(10) format e.g. "1156741200" but can't figure out the sql query to run.
(2) I have a table with user info in it. Passwords are stored there encrypted md5. I need to change everyone's password. I could generate a list of plain text random passwords and put them in a column next to the user id's. I'm not sure of how to get the md5 version of the random password that I give them. Also I'm guessing the sql query would be:
Code:
UPDATE table_name SET password=md5value WHERE user_id=some_value
Any help really appreciated... my headache is now full blown!