Encrypting Password Field in MySQL using MD5

The Following sample code shows the MD5 functions usage in MySQL to encrypt your password fields

Now let's insert a record with MD5 applied to the password field.

mysql> INSERT INTO user_md5 VALUES ('member1',MD5('secretpassword') );

MySQL update Multiple Fields using UPDATE SET

Example:

Table Name: Empdet

UPDATE Empdet SET CNO='$mobil',PEMAIL='$emailid' ,LNO='$land',FATHUS='$fah',DOOR1='$door1',STREET1='$street1',LOC1='$loc1',CITY_DIST1='$dist1',STATE1='$state1',PIN1='$pin1',DOOR2='$door2',STREET2='$street2',LOC2='$loc2',CITY_DIST2='$dist2',STATE2='$state2',PIN2='$pin2',QUAL='$qual',AD_QUAL='$adqual' WHERE EID='$empid';

MYSQL LOAD INFILE EXPORT OUTFILE

Syntax and Example


LOAD DATA LOCAL INFILE '/home/kk/EHRMSList.csv'
INTO TABLE EMP
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(SNO,EID,NAME,DEPT);

SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM test_table;

Password Encryption in MySQL using MD5

Example:


CREATE TABLE Users
(
Username CHAR(15) NOT NULL,
Password CHAR(15) NOT NULL
);

INSERT INTO Users (username,password) VALUES ('name',md5('pass'));