OPERASI RELASI PADA DATABASE

 BLOM DI RAPIHIN IMTEENET PUTUS"

(c) Microsoft Corporation. All rights reserved.

C:\Users\Bahtra-14>cd C:\xampp\mysql\bin

C:\xampp\mysql\bin>mysql -u root -p

Enter password:

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 8

Server version: 10.4.27-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use db_smk;

Database changed

MariaDB [db_smk]> select*from tb_siswa;

+-------+--------------+---------------+--------------+---------------+-----------------+

| nis   | nama         | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |

+-------+--------------+---------------+--------------+---------------+-----------------+

|   123 | Jaka Jampang | Laki-laki     | Makasar      | 2000-05-02    | Ajeng           |

|   124 | Iin          | Perempuan     | Pandeglang   | 2012-10-25    | Ani             |

|   126 | Jeky         | Laki-laki     | Batavia      | 2007-03-12    | Sinnu           |

|   234 | ryhan        | Laki-Laki     | mekah        | 2025-11-18    | saa             |

| 43321 | ryhankmil    | Laki-Laki     | madinnah     | 2007-11-07    | Aurora          |

+-------+--------------+---------------+--------------+---------------+-----------------+

5 rows in set (0.055 sec)

MariaDB [db_smk]> select*from tb_siswa WHERE nama='ryhankmil';

+-------+-----------+---------------+--------------+---------------+-----------------+

| nis   | nama      | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |

+-------+-----------+---------------+--------------+---------------+-----------------+

| 43321 | ryhankmil | Laki-Laki     | madinnah     | 2007-11-07    | Aurora          |

+-------+-----------+---------------+--------------+---------------+-----------------+

1 row in set (0.003 sec)

MariaDB [db_smk]> select*from tb_siswa WHERE nis>126;

+-------+-----------+---------------+--------------+---------------+-----------------+

| nis   | nama      | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |

+-------+-----------+---------------+--------------+---------------+-----------------+

|   234 | ryhan     | Laki-Laki     | mekah        | 2025-11-18    | saa             |

| 43321 | ryhankmil | Laki-Laki     | madinnah     | 2007-11-07    | Aurora          |

+-------+-----------+---------------+--------------+---------------+-----------------+

2 rows in set (0.004 sec)

MariaDB [db_smk]> select*from tb_siswa WHERE nis>=126;

+-------+-----------+---------------+--------------+---------------+-----------------+

| nis   | nama      | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |

+-------+-----------+---------------+--------------+---------------+-----------------+

|   126 | Jeky      | Laki-laki     | Batavia      | 2007-03-12    | Sinnu           |

|   234 | ryhan     | Laki-Laki     | mekah        | 2025-11-18    | saa             |

| 43321 | ryhankmil | Laki-Laki     | madinnah     | 2007-11-07    | Aurora          |

+-------+-----------+---------------+--------------+---------------+-----------------+

3 rows in set (0.001 sec)

MariaDB [db_smk]> select*from tb_siswa WHERE nama LIKE "%J";

Empty set (0.001 sec)

MariaDB [db_smk]> select*from tb_siswa WHERE nama LIKE "%j";

Empty set (0.000 sec)

MariaDB [db_smk]> select*from tb_siswa WHERE nama LIKE "J%";

+-----+--------------+---------------+--------------+---------------+-----------------+

| nis | nama         | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |

+-----+--------------+---------------+--------------+---------------+-----------------+

| 123 | Jaka Jampang | Laki-laki     | Makasar      | 2000-05-02    | Ajeng           |

| 126 | Jeky         | Laki-laki     | Batavia      | 2007-03-12    | Sinnu           |

+-----+--------------+---------------+--------------+---------------+-----------------+

2 rows in set (0.000 sec)

MariaDB [db_smk]> select*from tb_siswa WHERE nama LIKE "n%";

Empty set (0.000 sec)

MariaDB [db_smk]> select*from tb_siswa WHERE nama LIKE "%n";

+-----+-------+---------------+--------------+---------------+-----------------+

| nis | nama  | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |

+-----+-------+---------------+--------------+---------------+-----------------+

| 124 | Iin   | Perempuan     | Pandeglang   | 2012-10-25    | Ani             |

| 234 | ryhan | Laki-Laki     | mekah        | 2025-11-18    | saa             |

+-----+-------+---------------+--------------+---------------+-----------------+

2 rows in set (0.000 sec)

Untuk...nis dri angka awal sampai mana gtu terserah

MariaDB [db_smk]> select*from tb_siswa WHERE nis BETWEEN 123 AND 126;

+-----+--------------+---------------+--------------+---------------+-----------------+

| nis | nama         | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |

+-----+--------------+---------------+--------------+---------------+-----------------+

| 123 | Jaka Jampang | Laki-laki     | Makasar      | 2000-05-02    | Ajeng           |

| 124 | Iin          | Perempuan     | Pandeglang   | 2012-10-25    | Ani             |

| 126 | Jeky         | Laki-laki     | Batavia      | 2007-03-12    | Sinnu           |

+-----+--------------+---------------+--------------+---------------+-----------------+

3 rows in set (0.002 sec)

untuk daerah yang smaa

MariaDB [db_smk]> select*from tb_siswa WHERE jenis_kelamin='laki-laki' AND tempat_lahir='Makasar';

+-----+--------------+---------------+--------------+---------------+-----------------+

| nis | nama         | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |

+-----+--------------+---------------+--------------+---------------+-----------------+

| 123 | Jaka Jampang | Laki-laki     | Makasar      | 2000-05-02    | Ajeng           |

+-----+--------------+---------------+--------------+---------------+-----------------+

1 row in set (0.005 sec)