#!/bin/Bashmysql='mysql-u***-p***-hws5 Account'tmp="tmp"Resultsource="Resultsource"resultdest="resultdest"Echo "Select User_id,phone_num,email from user_accounts where length (user_id) = one limit 1"|${mysql} >${tmp}sed '1d'${TMP} >${resultsource}>${resultdest} whileRead user_id phone_num email Do Echo${USER_ID} 'EchoRokid${phone_num}account 'echo-n rokid${phone_num}account|md5sum|cut-d ""-f 1|tr [ A-z] [a-z]Echo${USER_ID} 'Echo-N rokid${phone_num}account|md5sum|Cut-D" "-F1|TR[A-z] [A-z] ' >>${resultdest} Done<${resultsource}# whileread user_id phone_num_md5 # Do # Echo "Update user_accounts Set phone_num = \ "${phone_num_md5}\" where user_id = \ "${user_id}\""|$MYSQL # Done< ${resultdest}
Above the red bold statement, for the correct md5sum encryption method (pay special attention to the front echo-n option)
Ps:mac The red bold option above in the file, always do not remove the carriage return after the string.
Available via XXD filename
or od-c filename to see if there is a carriage return character
Not to be continued ...
Shell Echo-n md5sum How to use