Advertisement
Guest User

Untitled

a guest
Jul 31st, 2014
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. read min max rows <<< $(mysql $dbDatabase -u $dbUser -p$dbPass -B -N -e
  2. "SELECT MIN(`DateTime`), MAX(`DateTime`), COUNT(*) FROM $dbTable")
  3. echo "Min Date:" $min
  4. echo "Max Date:" $max
  5. echo "Total Rows:" $rows
  6.  
  7. Min Date: 2013-03-18
  8. Max Date: 20:30:00
  9. Total Rows: 2014-07-31 14:30:00 11225139
  10.  
  11. IFS=$'t' read min max rows <<< ...
  12.  
  13. Min Date: 2013-03-18 20:30:00 2014-07-31 14:30:00 11225139
  14. Max Date:
  15. Total Rows:
  16.  
  17. read min max rows <<< $(mysql $dbDatabase -u $dbUser -p$dbPass -B -N -e
  18. "SELECT MIN(`DateTime`), MAX(`DateTime`), COUNT(*) FROM $dbTable"
  19. | tr ' ' '.')
  20. min=$(tr '.' ' ' <<< $min)
  21. max=$(tr '.' ' ' <<< $max)
  22.  
  23. echo "Min Date:" $min
  24. echo "Max Date:" $max
  25. echo "Total Rows:" $rows
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement