This article describes how to use SQRT functions in MySQL. it is the basic knowledge of MySQL beginners, for more information, see The SQRT function of MySQL to calculate the square root of any number. You can use the SELECT statement to find any number of square verification root:
mysql> select SQRT(16);+----------+| SQRT(16) |+----------+| 4.000000 |+----------+1 row in set (0.00 sec)
The floating point value, because internal MySQL will process the square root of the floating point data type.
You can use the SQRT function to calculate the square root of a record. To learn more about SQRT function usage, consider that the table of EMPLOYEE_TBL has the following records:
mysql> SELECT * FROM employee_tbl;+------+------+------------+--------------------+| id | name | work_date | daily_typing_pages |+------+------+------------+--------------------+| 1 | John | 2007-01-24 | 250 || 2 | Ram | 2007-05-27 | 220 || 3 | Jack | 2007-05-06 | 170 || 3 | Jack | 2007-04-06 | 100 || 4 | Jill | 2007-04-06 | 220 || 5 | Zara | 2007-06-06 | 300 || 5 | Zara | 2007-02-06 | 350 |+------+------+------------+--------------------+7 rows in set (0.00 sec)
Assume that the square root of all dialy_typing_pages is calculated based on the preceding table. then, run the following command:
mysql> SELECT name, SQRT(daily_typing_pages) -> FROM employee_tbl;+------+--------------------------+| name | SQRT(daily_typing_pages) |+------+--------------------------+| John | 15.811388 || Ram | 14.832397 || Jack | 13.038405 || Jack | 10.000000 || Jill | 14.832397 || Zara | 17.320508 || Zara | 18.708287 |+------+--------------------------+7 rows in set (0.00 sec)