Guest User

Untitled

a guest
Dec 3rd, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. function mysqlquery {
  2. local dbserver='localhost'
  3. local dbuser='user'
  4. local dbpass='pass'
  5. local db='mydb'
  6. mysql -h "$dbserver" -u "$dbuser" -p "$dbpass" --skip-column-names --raw -e "$*" "$db"
  7. if [ $? -ne 0 ]; then
  8. return 1
  9. fi
  10. }
  11.  
  12. for XY in $(mysqlquery "select XY from ABC where DEF = 123" 2>/dev/null);do
  13. dosomethingwith $XY
  14. done
  15. if mysqlquery "select XY from ABC where DEF = 123" 2>/dev/null; then
  16. echo true
  17. fi
  18.  
  19. function mysqlquery {
  20. local dbserver='localhost'
  21. local dbuser='user'
  22. local dbpass='pass'
  23. local db='mydb'
  24. result=$(mysql -h "$dbserver" -u "$dbuser" -p "$dbpass" -e "$*" "$db" 2>/dev/null)
  25. if [ $? -ne 0 -o -z "$result" ]; then
  26. return 1
  27. fi
  28. }
  29.  
  30. result=$(mysqlquery "select XY from ABC where DEF = 123" 2>/dev/null)
  31. for XY in $result;do
  32. dosomethingwith $XY
  33. done
  34. if mysqlquery "select XY from ABC where DEF = 123" 2>/dev/null; then
  35. echo true
  36. fi
Add Comment
Please, Sign In to add comment