#!/bin/bash

MYSQL='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) = 11 limit 1"|${MYSQL} > ${tmp}

sed '1d' ${tmp} > ${resultsource}

> ${resultdest}

while read user_id phone_num email

do

  echo ${user_id} `echo ROKID${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" " -f |tr [a-z] [A-Z]` >> ${resultdest}

done < ${resultsource}

#while read user_id phone_num_md5

#do

#  echo "update user_accounts set phone_num = \"${phone_num_md5}\" where user_id = \"${user_id}\"" | $MYSQL

#done < ${resultdest}