In this example we will create a function that returns power of given number. MySql already has a...
Author - Thomas Brown
Mysql Fibonacci Series With Stored Procedure
What is the Fibonacci series: The first number of this series is 0 and the second number is 1. The...
Mysql Create A Table With Code
In this post I will show you how to create a table with code on mysql database. Sometimes we need...
Sql Random Number Between 1000 and 9999
There is no direct function in sql that chooses a random number between two numbers. But there is a...
Sql Random Number Between 1 and 1000
To get random number in sql we use rand() function. But rand() funcition returns decimally random...
How to Calculate Age From Date Of Birth In Mysql
We calculate our age by the difference in full years between our current date and our date of birth...
Mysql Add Two Number With Function
In this post we will write a function that sums two number and returns result. Then, we will use...
Mysql Add Two Number With Stored Procedure and Output Parameter
In this post we will learn how to create a stored procedure with output parameter and how can we...
Mysql Random Number Between 1 and 100
Rand() function is used to select random numbers in Mysql. This function doesn’t get...
Sql Random Number Between 0 and 1
To get random number in sql we use rand() function. Rand() funcition returns decimally random...