tugas MYSQL

Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.67-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT 10 * 6;
+--------+
10 * 6
+--------+
60
+--------+
1 row in set (0.05 sec)

mysql> SELECT 18 / 3;
+--------+
18 / 3
+--------+
6.0000
+--------+
1 row in set (0.02 sec)

mysql> SELECT 4 + 6;
+-------+
4 + 6
+-------+
10
+-------+
1 row in set (0.00 sec)

mysql> SELECT 10 - 6;
+--------+
10 – 6
+--------+
4
+--------+
1 row in set (0.01 sec)

mysql> SELECT 5 % 2;
+-------+
5 % 2
+-------+
1
+-------+
1 row in set (0.00 sec)

mysql> SELECT RADIANS(30),
-> RADIANS(45),RADIANS(60);
+-----------------+------------------+-----------------+
RADIANS(30) RADIANS(45) RADIANS(60)
+-----------------+------------------+-----------------+
0.5235987755983 0.78539816339745 1.0471975511966
+-----------------+------------------+-----------------+
1 row in set (0.03 sec)

mysql> SELECT COS(RADIANS(45) ),
-> COS(RADIANS(60) );
+-------------------+-------------------+
COS(RADIANS(45) ) COS(RADIANS(60) )
+-------------------+-------------------+
0.70710678118655 0.5
+-------------------+-------------------+
1 row in set (0.00 sec)

mysql> SELECT TAN(RADIANS (30) ),
-> TAN(RADIANS(60) );
ERROR 1305 (42000): FUNCTION RADIANS does not exist
mysql> SELECT TAN(RADIANS(30) ),
-> TAN(RADIANS(60) );
+-------------------+-------------------+
TAN(RADIANS(30) ) TAN(RADIANS(60) )
+-------------------+-------------------+
0.57735026918963 1.7320508075689
+-------------------+-------------------+
1 row in set (0.00 sec)

mysql> SELECT ACOS(1),
-> COS(0);
+---------+--------+
ACOS(1) COS(0)
+---------+--------+
0 1
+---------+--------+
1 row in set (0.00 sec)

mysql> SELECT ASIN(0.5),
-> SIN(0.5235987755983),
-> SIN(RADIANS(30) );
+-----------------+----------------------+-------------------+
ASIN(0.5) SIN(0.5235987755983) SIN(RADIANS(30) )
+-----------------+----------------------+-------------------+
0.5235987755983 0.5 0.5
+-----------------+----------------------+-------------------+
1 row in set (0.00 sec)

mysql> SELECT ATAN(0.5),
-> TAN(0.4636476090081);
+------------------+----------------------+
ATAN(0.5) TAN(0.4636476090081)
+------------------+----------------------+
0.46364760900081 0.50000000000912
+------------------+----------------------+
1 row in set (0.00 sec)

mysql> SELECT ROUND(2.45),
-> ROUND(2.50),
-> ROUND(2.51),
-> ROUND(2.56);
+-------------+-------------+-------------+-------------+
ROUND(2.45) ROUND(2.50) ROUND(2.51) ROUND(2.56)
+-------------+-------------+-------------+-------------+
2 3 3 3
+-------------+-------------+-------------+-------------+
1 row in set (0.00 sec)

mysql> SELECT CEILING(2.23),
-> CEILING(2.55),
-> CEILING(2.90);
+---------------+---------------+---------------+
CEILING(2.23) CEILING(2.55) CEILING(2.90)
+---------------+---------------+---------------+
3 3 3
+---------------+---------------+---------------+
1 row in set (0.00 sec)

mysql> SELECT FLOOR(2.01),
-> FLOOR(2.45),
-> FLOOR(2.95);
+-------------+-------------+-------------+
FLOOR(2.01) FLOOR(2.45) FLOOR(2.95)
+-------------+-------------+-------------+
2 2 2
+-------------+-------------+-------------+
1 row in set (0.00 sec)



mysql> SELECT ABS(3),
-> ABS(-3),
-> ABS(-3.34);
+--------+---------+------------+
ABS(3) ABS(-3) ABS(-3.34)
+--------+---------+------------+
3 3 3.34
+--------+---------+------------+
1 row in set (0.00 sec)

mysql> SELECT 5 DIV 2,
-> 5 DIV 3,
-> 9 DIV 3;
+---------+---------+---------+
5 DIV 2 5 DIV 3 9 DIV 3
+---------+---------+---------+
2 1 3
+---------+---------+---------+
1 row in set (0.00 sec)

mysql> SELECT MOD(5, 2),
-> MOD(5, 3),
-> MOD(9, 3);
+-----------+-----------+-----------+
MOD(5, 2) MOD(5, 3) MOD(9, 3)
+-----------+-----------+-----------+
1 2 0
+-----------+-----------+-----------+
1 row in set (0.00 sec)

mysql> SELECT POW(2, 3),
-> POWER(2, 4),
-> POW(4, 2);
+-----------+-------------+-----------+
POW(2, 3) POWER(2, 4) POW(4, 2)
+-----------+-------------+-----------+
8 16 16
+-----------+-------------+-----------+
1 row in set (0.00 sec)

mysql> SELECT RAND();
+------------------+
RAND()
+------------------+
0.88944339369372
+------------------+
1 row in set (0.00 sec)

mysql> SELECT SQRT(81);
+----------+
SQRT(81)
+----------+
9
+----------+
1 row in set (0.00 sec)

mysql> SELECT LEAST(1, 2, 3, 4, 5, 6, 7, 8, 9, );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ')' at
line 1
mysql> SELECT LEAST(1, 2, 3, 4, 5, 6, 7, 8, 9);
+----------------------------------+
LEAST(1, 2, 3, 4, 5, 6, 7, 8, 9)
+----------------------------------+
1
+----------------------------------+
1 row in set (0.03 sec)

mysql> SELECT GREATEST(1, 2, 3, 4, 5, 6, 7, 8, 9);
+-------------------------------------+
GREATEST(1, 2, 3, 4, 5, 6, 7, 8, 9)
+-------------------------------------+
9
+-------------------------------------+
1 row in set (0.01 sec)

mysql> SELECT TRUNCATE(1.245, 1),
-> TRUNCATE(5.23, 1);
+--------------------+-------------------+
TRUNCATE(1.245, 1) TRUNCATE(5.23, 1)
+--------------------+-------------------+
1.2 5.2
+--------------------+-------------------+
1 row in set (0.00 sec)

mysql> SELECT POWER(2, 4),
-> LOG2(16);
+-------------+----------+
POWER(2, 4) LOG2(16)
+-------------+----------+
16 4
+-------------+----------+
1 row in set (0.00 sec)

mysql>