/docs/MyDocs

« back to all changes in this revision

Viewing changes to DataBase/MySQL/sql/math.htm

• browse files at revision 1
• compare with another revision
• download diff
• download tarball
• view history from revision 1

Show diffs side-by-side

added

removed

DataBase/MySQL/sql/math.htm

 

1

<P>

 

2

<B>+,-,*,/,%</B> 1/0 = NULL, if Overflow - 0. Division will be calculated in

 

3

INT arithmetic only if it's result converted to int. <BR>

 

4

</P><P>

 

5

<B>ABS(x),SIGN(x),MOD(n,m)</B><BR>

 

6

<B>EXP(x),LOG(x),LOG10(x),POW/POWER(x,y),SQRT(x)</B><BR>

 

7

</P><P>

 

8

<B>PI(),COS(x),SIN(x),TAN(x),COT(x),ACOS(x),ASIN(x),ATAN(x)</B> COT - cotangens<BR>

 

9

<B>ATAN(y,x),ATAN2(y,x)</B> ATAN(y/x)<BR>

 

10

<B>DEGREES(X), RADIANS(X)</B> DEGREES<->RADIANS conversion<BR>

 

11

</P><P>

 

12

<B>FLOOR(X),CEILING(X),ROUND(X)</B> FLOOR - to smaller, CEILING - to larger,

 

13

ROUND - to nearest.<BR>

 

14

<B>ROUND(X,D)</B> rounding to number with <I>D</I> fraction decimals.<BR>

 

15

<B>TRUNCATE(X,D)</B> returns <I>X</I> truncated to <I>D</I> fraction decimals.<BR>

 

16

<B>FORMAT(X,D)</B> Formats number to format "#,###,###.##" and rounded to D 

 

17

fraction decimals.<BR>

 

18

</P><P>

 

19

<B>RAND([N])</B> Random number on [0,1]; N - specified seed. <I>RAND(1)=RAND(1)</I><BR>

 

20

</P><P>

 

21

<B>LEAST/GREATEST(A,B,...)</B> Returns smallest/greatest argument. Comparing using 

 

22

return value context: REAL,INTEGER,case sensitive STRING, case insensitive STRING<BR>

 

23

</P>

 

 

b'\\ No newline at end of file'

• Older »

Loggerhead is a web-based interface for Breezy
Version: 1.20.0