MySQL Math 65 codes

  1. Home
  2. MySQL
  3. Math
1 Abstract value demo
2 Another MAX function
3 Another SUM
4 Call PI
5 CEIL() and CEILING() return the smallest integer that is not less than the specified number
6 COT(value)
7 Do calculation
8 Do calculation with SUM
9 Do math sin
10 Get Pi and round it up and down
11 Get some square roots
12 Getting Column Averages
13 GREATEST() and LEAST() Functions
14 LEAST() function
15 MOD in MySQL
16 Modulus operator
17 POW(number, power)
18 Random row from the table
19 Retrieve the largest integer that is not greater than a specified value
20 Retrieving Column Totals
21 Retrieving Maximum and Minimum Values
22 ROUND value in MySQL
23 ROUND(number [, decimal])
24 Simple MAX
25 Simple MIN
26 Simplest SUM
27 Square root
28 The MOD() function returns the remainder derived by dividing two numbers
29 The PI() function returns the value of PI
30 The SQRT() function returns to the square root of a specified number
31 To know the percentage distribution
32 To put each population value in the proper category, divide by five million and use the integer result
33 To sort rows by product serial number, use MID( ) to extract the middle five characters from the id values, be
34 Treat Monday as the first day of the week and Sunday as the last, use a the MOD( ) function to map Monday to 0
35 Trigonometry Functions
36 TRUNCATE(number, decimal)
37 Try multiplying the FLOOR( ) results by five
38 Use ABS 2
39 Use ACOS
40 Use and ATAN and ATAN2
41 Use ASIN
42 Use ATAN
43 Use AVG and alias
44 Use AVG and compare
45 Use AVG and SUM together
46 Use CEILING in MySQL
47 Use COS
48 Use COT
49 Use FLOOR in MySQL
50 Use FLOOR( ) if you prefer integer values to floating-point values
51 Use log
52 Use LOG10 and LOG2
53 Use MAX to get the largest value
54 Use power
55 Use RADIANS
56 Use SIN
57 Use SUM and alias
58 Use SUM and alias 2
59 Use SUM on int value
60 Use TAN
61 Use the COT() function to determine the cotangent of a number
62 Use the MOD() function to divide the Amount values by 10 and then return the remainder from that division
63 Use the POW() function to raise the Amount values by a power of 2
64 Use TRUNCATE
65 Using LPAD( ) was shown for making sure the month values have two digits