sqrt mysql function to get square root of number

select sqrt(16); // output is 4
select sqrt(20); // output is 4.47213595499958

For negative number we will get NULL output

select sqrt(-25); // output is NULL

Example of sqrt function with update query

We know how to find out hypotenuse of a right angle triangle.

H² = A² + B²;

H= Square root of (A² + B²) ;

We will create one UPDATE query by using MySQL pow function.
Here it is

update sql_sqrt set H=sqrt(pow(A,2) + pow(B,2))

This will update the table with value of hypotenuse . Here is the PHP code to update the table.

require 'config.php'; // Database connection
$sql=$dbo->prepare("update sql_sqrt set H=sqrt(pow(A,2) + pow(B,2))");
if($sql->execute()){
echo "Successfully updated H";
}// End of if profile is ok 
else{
print_r($sql->errorInfo()); // if any error is there it will be posted
$msg=" Database problem, please contact site admin ";
}

Download SQL dump file of this table

SQL Math References Standard deviation Average value Query

Subhendu Mohapatra

Author

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

Subscribe to our YouTube Channel here

sqrt(): square root of any number

Example of sqrt function with update query

Subhendu Mohapatra