oprasi Relasi
C:\Users\A-05>cd C:\xampp\mysql\bin
c:\xampp\mysql\bin>mysql -u root -p
MariaDB [(none)]> use db_smk;
1. UNTUK MENAMPILKAN SELURUH DATA SISWA PADA TABEL tb_siswa.
MariaDB [db_smk]> select * from tb_siswa;
+----------+----------------+---------------+--------------+---------------+-----------------+
| nis | nama | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |
+----------+----------------+---------------+--------------+---------------+-----------------+
| 0 | | | | 0000-00-00 | |
| 123 | ahmad encuk | Laki-Laki | Banten | 2005-07-17 | maryam |
| 125 | Imang setiawan | Laki-Laki | Surabaya | 2006-12-30 | minah |
| 127 | cengboy | Laki-Laki | jakarta | 2005-09-25 | wati |
| 128 | Serli | perempuan | Bandung | 2009-04-29 | munaroh |
| 129 | deden | Laki-Laki | lebak | 2008-10-04 | sarmin |
| 130 | Johary | Laki-Laki | Tangerang | 2009-06-25 | fulan |
| 131 | fadlah | perempuan | bandung | 2005-07-22 | nipah |
| 2324 | ambihi | Laki-Laki | TANGERANG | 2025-12-02 | joki |
| 23545637 | | | TANGERANG | 2009-06-25 | |
+----------+----------------+---------------+--------------+---------------+-----------------+
10 rows in set (0.000 sec)
2. Tampilkan data siswa yang memiliki nama ahmad encuk
MariaDB [db_smk]> select * from tb_siswa WHERE nama='ahmad encuk';
+-----+-------------+---------------+--------------+---------------+-----------------+
| nis | nama | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |
+-----+-------------+---------------+--------------+---------------+-----------------+
| 123 | ahmad encuk | Laki-Laki | Banten | 2005-07-17 | maryam |
+-----+-------------+---------------+--------------+---------------+-----------------+
1 row in set (0.000 sec)
MariaDB [db_smk]> select * from tb_siswa WHERE nis>128;
+----------+--------+---------------+--------------+---------------+-----------------+
| nis | nama | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |
+----------+--------+---------------+--------------+---------------+-----------------+
| 129 | deden | Laki-Laki | lebak | 2008-10-04 | sarmin |
| 130 | Johary | Laki-Laki | Tangerang | 2009-06-25 | fulan |
| 131 | fadlah | perempuan | bandung | 2005-07-22 | nipah |
| 2324 | ambihi | Laki-Laki | TANGERANG | 2025-12-02 | joki |
| 23545637 | | | TANGERANG | 2009-06-25 | |
+----------+--------+---------------+--------------+---------------+-----------------+
5 rows in set (0.000 sec)
2. Tampilkan data siswa yang memiliki nis lebih besar dari 128
MariaDB [db_smk]> select * from tb_siswa WHERE nis>=128;
+----------+--------+---------------+--------------+---------------+-----------------+
| nis | nama | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |
+----------+--------+---------------+--------------+---------------+-----------------+
| 128 | Serli | perempuan | Bandung | 2009-04-29 | munaroh |
| 129 | deden | Laki-Laki | lebak | 2008-10-04 | sarmin |
| 130 | Johary | Laki-Laki | Tangerang | 2009-06-25 | fulan |
| 131 | fadlah | perempuan | bandung | 2005-07-22 | nipah |
| 2324 | ambihi | Laki-Laki | TANGERANG | 2025-12-02 | joki |
| 23545637 | | | TANGERANG | 2009-06-25 | |
+----------+--------+---------------+--------------+---------------+-----------------+
6 rows in set (0.000 sec)
2. Tampilkan data siswa yang memiliki nama awalan huruf "i"
MariaDB [db_smk]> select*from tb_siswa WHERE nama LIKE "%i";
+------+--------+---------------+--------------+---------------+-----------------+
| nis | nama | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |
+------+--------+---------------+--------------+---------------+-----------------+
| 128 | Serli | perempuan | Bandung | 2009-04-29 | munaroh |
| 2324 | ambihi | Laki-Laki | TANGERANG | 2025-12-02 | joki |
+------+--------+---------------+--------------+---------------+-----------------+
2 rows in set (0.000 sec)
MariaDB [db_smk]> select*from tb_siswa WHERE nama LIKE "i%";
+-----+----------------+---------------+--------------+---------------+-----------------+
| nis | nama | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |
+-----+----------------+---------------+--------------+---------------+-----------------+
| 125 | Imang setiawan | Laki-Laki | Surabaya | 2006-12-30 | minah |
+-----+----------------+---------------+--------------+---------------+-----------------+
1 row in set (0.000 sec)
Tidak ada komentar:
Posting Komentar