sqrt()We can get square root of any number by using sqrt function, here are some examples.
For negative number we will get NULL output
Example of sqrt function with update queryWe know how to find out hypotenuse of a right angle triangle.
We will create one UPDATE query by using MySQL pow function.
Here it is
This will update the table with value of hypotenuse . Here is the PHP code to update the table.
Download SQL dump file of this table
This article is written by plus2net.com team.
▼ More on Math functions in SQL