Skip to content

Instantly share code, notes, and snippets.

@greenlion

greenlion/gist:f8dff67fa9d1fc0cef833cbe99a10dc6

Created May 11, 2019 08:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save greenlion/f8dff67fa9d1fc0cef833cbe99a10dc6 to your computer and use it in GitHub Desktop.
Save greenlion/f8dff67fa9d1fc0cef833cbe99a10dc6 to your computer and use it in GitHub Desktop.
Download ZIP
bc stddev example
Raw
gistfile1.txt
MariaDB [bcnum]> select * from t1;
+-----------------------+
| c1 |
+-----------------------+
| 1.8446744073709552e19 |
| 9.223372036854776e18 |
| 9.223372036854776e18 |
+-----------------------+
3 rows in set (0.000 sec)
MariaDB [bcnum]> select bc_stddev(c1),stddev(c1) from t1;
+------------------------------------------+-----------------------+
| bc_stddev(c1) | stddev(c1) |
+------------------------------------------+-----------------------+
| 8695878550221854989.25238385459117182587 | 4.3479392751109274e18 |
+------------------------------------------+-----------------------+
1 row in set (0.001 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment