Tutorial Belajar Program Lengkap: Pengenalan Operator Aritmatika Pada MySQL

Jumat, 25 Desember 2015

Pengenalan Operator Aritmatika Pada MySQL

Pada tutorial MySQL kali ini, kita akan belajar tentang Pengenalan Operator Aritmatika. Operator Aritmatika digunakan untuk melakukan operasi matematika. Operator aritmatika dapat Anda gunakan pada Select statement, Update statement, Insert statement, dan Delete statement.

Macam-Macam Operator Aritmatika

Berikut ini tabel macam-macam operator aritmatika yang terdapat pada MySQL:

Operator	Deskripsi	Contoh
+	Operator penambahan	30 + 20
-	Operator pengurangan	30 - 20
*	Operator perkalian	30 * 20
/	Operator pembagian	30 / 20
%	Operator modulus (sisa bagi)	30 % 20

Contoh

Berikut ini contoh implementasi operator aritmatika pada Select statement:

Contoh #1

mysql> SELECT 30+20;
+-------+
| 30+20 |
+-------+
|    50 |
+-------+
1 row in set (0.04 sec)

mysql> SELECT 30-20;
+-------+
| 30-20 |
+-------+
|    10 |
+-------+
1 row in set (0.06 sec)

mysql> SELECT 30*20;
+-------+
| 30*20 |
+-------+
|   600 |
+-------+
1 row in set (0.00 sec)

mysql> SELECT 30/20;
+--------+
| 30/20  |
+--------+
| 1.5000 |
+--------+
1 row in set (0.00 sec)

mysql> SELECT 30%20;
+-------+
| 30%20 |
+-------+
|    10 |
+-------+
1 row in set (0.00 sec)

Contoh #2

Misalkan Anda memiliki sebuah table "tbl_employee" dengan data-data sebagai berikut:

mysql> SELECT * FROM tbl_employee;
+-------------+---------------+------------+-------------+------------+------------+--------+
| employee_id | employee_name | birth_date | birth_place | salary     | department | gender |
+-------------+---------------+------------+-------------+------------+------------+--------+
|           1 | Ahmad Sofyan  | 1990-01-01 | Bandung     | 1750000.00 | IT         | L      |
|           2 | Ismail Saleh  | 1986-12-12 | Pandeglang  | 5000000.00 | ACC        | L      |
|           3 | Ferry Subekti | 1987-06-06 | Purwakarta  | 4500000.00 | HRD        | P      |
|           4 | Iskiyati      | 1988-07-07 | Brebes      | 7500000.00 | FIN        | P      |
|           5 | Nurul Hikmah  | 1989-08-08 | Purwokerto  | 3750000.00 | FIN        | P      |
|           6 | Riyanto       | 1983-02-02 | Subang      | 4000000.00 | IT         | L      |
|           7 | Azka Nurul    | 1984-03-03 | Bandung     | 5000000.00 | HRD        | P      |
|           8 | Venny Maya    | 1989-04-04 | Jakarta     | 6500000.00 | IT         | P      |
|           9 | Ana Fauziyah  | 1989-05-05 | Bekasi      | 3700000.00 | ACC        | P      |
|          10 | Arya Adhi     | 1980-09-09 | Magelang    | 8000000.00 | FIN        | P      |
+-------------+---------------+------------+-------------+------------+------------+--------+
10 rows in set (0.00 sec)

Dari data diatas, untuk pegawai yang berada di department 'IT', tambahkan gajinya sebesar 500 ribu. dan Tampikan kembali data dari table diatas.

Untuk menyelesaikan soal diatas, Anda dapat menggunakan operator aritmatika "+" pada Update statement seperti berikut ini:

mysql> UPDATE tbl_employee
    -> SET salary = salary + 500000
    -> WHERE department = 'IT';
Query OK, 3 rows affected (0.10 sec)
Rows matched: 3  Changed: 3  Warnings: 0

mysql> SELECT * FROM tbl_employee;
+-------------+---------------+------------+-------------+------------+------------+--------+
| employee_id | employee_name | birth_date | birth_place | salary     | department | gender |
+-------------+---------------+------------+-------------+------------+------------+--------+
|           1 | Ahmad Sofyan  | 1990-01-01 | Bandung     | 2250000.00 | IT         | L      |
|           2 | Ismail Saleh  | 1986-12-12 | Pandeglang  | 5000000.00 | ACC        | L      |
|           3 | Ferry Subekti | 1987-06-06 | Purwakarta  | 4500000.00 | HRD        | P      |
|           4 | Iskiyati      | 1988-07-07 | Brebes      | 7500000.00 | FIN        | P      |
|           5 | Nurul Hikmah  | 1989-08-08 | Purwokerto  | 3750000.00 | FIN        | P      |
|           6 | Riyanto       | 1983-02-02 | Subang      | 4500000.00 | IT         | L      |
|           7 | Azka Nurul    | 1984-03-03 | Bandung     | 5000000.00 | HRD        | P      |
|           8 | Venny Maya    | 1989-04-04 | Jakarta     | 7000000.00 | IT         | P      |
|           9 | Ana Fauziyah  | 1989-05-05 | Bekasi      | 3700000.00 | ACC        | P      |
|          10 | Arya Adhi     | 1980-09-09 | Magelang    | 8000000.00 | FIN        | P      |
+-------------+---------------+------------+-------------+------------+------------+--------+
10 rows in set (0.00 sec)