FUNCTIONS AND OPERATIONS MY SQL

Before operate the program, we must have and open xampp (start apache and mysql) then open localhost phpMyAdmin. Next open command prompt (cmd) and follow the steps until success like in the two pictures above. In every operation must input SELECT. There are some of operations :

 1. First operation is subtraction, the user only input SELECT number1-number2. Then the result will show. The other operations addition,multiplication, and division.

2. SELECT COS to find the value of cos. The others is sin, cot, tan etc.

 3. SELECT ASIN to find the value of arc sin. Also ACOS,ACOT,ATAN, etc.

 4. SELECT LEAST, user must input some of numbers or characters then will be arrange from number or character earlier or smallest. If we input characters don’t forget use ‘’ symbol.

5.  SELECT GREATEST is operation to search highest value from the data that inputed by user.

 6.    SELECT RADIANS to return argument or data input converted to radians.

 7.    SELECT DEGREES is operation to convert data from radians to degrees.

 8.  SELECT ABS is operation to find the absolute value. All of numbers that inputed by user will become positive value.

9.  SELECT SIGN, users must input data (positive or negative) and if the input is positive so the result is 1 , if the input is negative the result is -1.

 10. SELECT ROUND to find the real round value of the data input.

 11. SELECT MOD is the operation to find the remainder velue of the division.

 12.   SELECT POW is the operation to find the value of power.

 13. SELECT FLOOR is the operation to find the value of round down.

 14.   SELECT CEIL is the operation to find the value of round up.