CONSULTA_3CORTE_CRISTIANALBERTOSALGADO

Funciones Matematicas
Funcion
Descripcion
Ejemplo
ABS
Devuelve el valor absoluto
ABS(X)
mysql> SELECT ABS(2);
+--------+
| ABS(2) |
+--------+
| 2 |
+--------+
1 row in set (0.00 sec)
EXP
Cálculode potencias de e
EXP(X) mysql> SELECT EXP(2);
+----------+
| EXP(2) |
+----------+
| 7.389056 |
+----------+
1 row in set (0.00 sec)
LN
Logaritmo natural
mysql> SELECT LN(2);
+----------+
| LN(2)|
+----------+
| 0.693147 |
+----------+
1 row in set (0.00 sec)
LOG
Logaritmo en base arbitraria
mysql> SELECT LOG(2);
+----------+
| LOG(2) |
+----------+
| 0.693147 |
+----------+
1 row in set(0.00 sec)
MOD o %
Resto de una división entera
mysql> SELECT MOD(234, 10);
+--------------+
| MOD(234, 10) |
+--------------+
| 4 |
+--------------+
1 row in set (0.00 sec)
PI
Valor del número mysql> SELECT PI();
+----------+
| PI() |
+----------+
| 3.141593 |
+----------+
1 row in set (0.00 sec)
RADIANS
Conversión de radianes a grados
mysql> SELECT RADIANS(90);
+-----------------+
|RADIANS(90) |
+-----------------+
| 1.5707963267949 |
+-----------------+
1 row in set (0.00 sec)
SIGN
Devuelve el signo
mysql> SELECT SIGN(-32);
+-----------+
| SIGN(-32) |
+-----------+
| -1 |+-----------+
1 row in set (0.00 sec)
SQRT
Cálculo de la raíz cuadrada
mysql> SELECT SQRT(4);
+----------+
| SQRT(4) |
+----------+
| 2.000000 |
+----------+
1 row in set (0.00
FUNCIONES DE CADENA
FUNCIONDESCRIPCION
EJEMPLO
ASCII
Valor de código ASCII de un carácter
mysql> SELECT ASCII('2');
+------------+
| ASCII('2') |
+------------+
| 50 |
+------------+
1 row in set (0.03 sec)
BIN
Converión abinario
mysql> SELECT BIN(12);
+---------+
| BIN(12) |
+---------+
| 1100 |
+---------+
1 row in set (0.01 sec)
CHAR
Convierte de ASCII a carácter
mysql> SELECT CHAR(77,121,83,81,'76');+-------------------------+
| CHAR(77,121,83,81,'76') |
+-------------------------+
| MySQL |
+-------------------------+
1 row in set (0.03 sec)
COMPRESS
Comprime una cadena de caracteres
mysql> SELECT LENGTH...