|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
plain text <> MD5
Hey,
I've got a list of names with passwords in csv. I want to import them all into a sql database, but the password needs to be MD5 format. Do you guys know a 'simple' way to import the complete list into SQL so the passwords are changed? Thanks a lot!!! Brononi |
|
#2
|
||||
|
||||
|
If you have SQLServer available (you didn't mentioned what DB you're using), you can write a DTS script which incorporates the MD5 hashing, which will process the CSV lines as they are inserted.
|
|
#3
|
|||
|
|||
|
Hey,
I'm using '4.0.18-standard'. I hope it was this you needed. I don't have any knowledge about the DTS. Can i find a 'example' somewhere? |
|
#4
|
||||
|
||||
|
Quote:
What is that? |
|
#5
|
|||
|
|||
|
The version of the server we use.
This is what i can see: - PHP version: 4.3.3 - MySql version: 4.0.18-standard - cPanle Build: 9.2.0-STABLE 25 - Apache version: 1.3.29 (Unix) - PERL version: 5.8.0 I can play on this system without any problem. ![]() |
![]() |
| Viewing: Dev Articles Community Forums > Databases > General SQL Development > plain text <> MD5 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|