Advertisement
Guest User

get single sql line from bash

a guest
Aug 23rd, 2014
192
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.75 KB | None | 0 0
  1. pi@raspberrypi ~ $ cat getsingleSQLline.sh
  2. #!/bin/bash
  3. my_host="localhost";my_port="3306";my_user="tester";my_pwd="tester";
  4. my_db="tester";my_tbl="users";my_fld="username";
  5. my_stat="select $my_fld from $my_tbl\G;";
  6. my_slist="/tmp/userlist";
  7. my_dlist="/tmp/db_userlist";
  8. # do no change unless you know what you do
  9. mysql -ss -N -h $my_host -P $my_port -u $my_user -p$my_pwd -D $my_db -e "$my_stat" > /tmp/GETSQLUSERS.TXT
  10. cat /tmp/GETSQLUSERS.TXT | grep -v row  | sort > $my_dlist
  11. rm /tmp/GETSQLUSERS.TXT
  12. diff -u $my_slist $my_dlist > /tmp/userlist.patch
  13. if [ -s "/tmp/userlist.patch" ]
  14.  then
  15.         echo "Userlist needs patching"
  16.         #patch $my_slist < /tmp/userlist.patch
  17.  else
  18.         echo "Userlist is up2date"
  19. fi
  20. rm /tmp/userlist.patch
  21. exit 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement