Storing passwords in database after encryption..I m new to Sql..so someone plz tell me the detailed proceedure

Question

I m new 2 SQL ..plz help me.

Answer 1

Learn the SQL commands. All you really need to do is (using the language / database interface of your choice) use the INSERT command, UPDATE command, or whichever you are looking for. The value you will be adding is simply the password. Encrypt the password using md5 or something similar. Store the encrypted value using the above commands in the appropriate row for the user / whatever you are dealing with. When you go to test for a login or something, take the entered password, md5 it just as you did before, and compare the two encrypted versions. If they match, success. Else the password entered is wrong.

Answer 2

only one betta can live in a 5 gallon tank, no other fis can survive in a tank that small. "except maybe for some very rare expensive fish" neons do best in groups of 7 or more. bettas are carnivours and may decide to eat the neons. also, neons might become nippy and tear a bettas fins. tetras are sensative fish, they do not deal well with chemical, biological or temperature shifts. these shifts occur often in new and unastablished tanks. and also in small tanks, or overstocked tanks, or underfiltered tanks etc.

Answer 3

What database are you using? You know, you can probably figure this out by reading the documentation for the database, which ever one it is. It's not the same for all of them.

Answer 4

Encrypt the password and store it



Then pull it out in its encrypted state and decrypt it for use.