Hey MySQL, what's my heart rate?

I decided to follow what my colleagues are doing. Monitoring heart rate while running.

Miles to go ...: Heart Rate Monitors and Marathon Training
I'm planning to buy a heart rate monitor (HRM) to assist me. Read here to see why heart monitoring is beneficial
Bringing some science into running : Interconnectedness of all things
heart rate thresholds not to go above. So for longer distances taking much longer than an hour stay below 156 beat per minute and with 171 as my max heart rate

As I wrote before in this entry, all my heart rate data are stored in MySQL tables. This includes data from 2 sessions to know 2 kinds of 'heart rate'.
  1. Maximum Heart Rate(MHR)
    I did pretty hard work out in which I climbed up stairs for 100 meters twice.
  2. Resting Heart Rate(RHR)
    I measured my heart rate while I was still in bed after 6 hours sleep.
So, here's my MHR and RHR, retrieved by a SQL statement.
mysql> select max(cast(MaxHR as UNSIGNED)),min(cast(AverageHR as UNSIGNED)) from tracklapmaster where AverageHR!=0;
+------------------------------+----------------------------------+
| max(cast(MaxHR as UNSIGNED)) | min(cast(AverageHR as UNSIGNED)) |
+------------------------------+----------------------------------+
|                          185 |                               46 |
+------------------------------+----------------------------------+
Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today