Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- read min max rows <<< $(mysql $dbDatabase -u $dbUser -p$dbPass -B -N -e
- "SELECT MIN(`DateTime`), MAX(`DateTime`), COUNT(*) FROM $dbTable")
- echo "Min Date:" $min
- echo "Max Date:" $max
- echo "Total Rows:" $rows
- Min Date: 2013-03-18
- Max Date: 20:30:00
- Total Rows: 2014-07-31 14:30:00 11225139
- IFS=$'t' read min max rows <<< ...
- Min Date: 2013-03-18 20:30:00 2014-07-31 14:30:00 11225139
- Max Date:
- Total Rows:
- read min max rows <<< $(mysql $dbDatabase -u $dbUser -p$dbPass -B -N -e
- "SELECT MIN(`DateTime`), MAX(`DateTime`), COUNT(*) FROM $dbTable"
- | tr ' ' '.')
- min=$(tr '.' ' ' <<< $min)
- max=$(tr '.' ' ' <<< $max)
- echo "Min Date:" $min
- echo "Max Date:" $max
- echo "Total Rows:" $rows
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement