Microsoft Windows [Version 10.0.19045.6332]
(c) Microsoft Corporation. All rights reserved.
C:\Users\A-20>cd C://xampp2/mysql/bin
C:\xampp2\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.32-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.
1. UNTUK MENAMPILKAN SELURUH DATA SISWA PADA TABEL tb_siswa
MariaDB [(none)]> use db_smk;
Database changed
MariaDB [db_smk]> select*from tb_siswa;
+------------+---------------------+---------------+--------------+---------------+-----------------+
| nis | nama | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |
+------------+---------------------+---------------+--------------+---------------+-----------------+
| 126 | Abyan Nadif | Laki-laki | Jakarta | 2012-11-19 | Ina |
| 127 | Jaka | Laki-laki | Pandeglang | 2008-12-08 | Inu |
| 2024010020 | Muhammmad Priambudi | Laki-laki | Jakarta | 2007-12-01 | Shofiyah |
| 2147483647 | bedul | Laki-laki | Tangerang | 2025-11-03 | dd |
+------------+---------------------+---------------+--------------+---------------+-----------------+
4 rows in set (0.040 sec)
2. Tampilkan data siswa yang memiliki nama "bedul"
MariaDB [db_smk]> select*from tb_siswa WHERE nama='bedul';
+------------+-------+---------------+--------------+---------------+-----------------+
| nis | nama | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |
+------------+-------+---------------+--------------+---------------+-----------------+
| 2147483647 | bedul | Laki-laki | Tangerang | 2025-11-03 | dd |
+------------+-------+---------------+--------------+---------------+-----------------+
1 row in set (0.000 sec)
2. Tampilkan data siswa yang memiliki nis lebih besar atau sama dengan dari 126
MariaDB [db_smk]> select*from tb_siswa WHERE nis>=126;
+------------+---------------------+---------------+--------------+---------------+-----------------+
| nis | nama | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |
+------------+---------------------+---------------+--------------+---------------+-----------------+
| 126 | Abyan Nadif | Laki-laki | Jakarta | 2012-11-19 | Ina |
| 127 | Jaka | Laki-laki | Pandeglang | 2008-12-08 | Inu |
| 2024010020 | Muhammmad Priambudi | Laki-laki | Jakarta | 2007-12-01 | Shofiyah |
| 2147483647 | bedul | Laki-laki | Tangerang | 2025-11-03 | dd |
+------------+---------------------+---------------+--------------+---------------+-----------------+
4 rows in set (0.000 sec)
2. Tampilkan data siswa yang memiliki nama akhiran huruf "l"
MariaDB [db_smk]> select*from tb_siswa WHERE nama LIKE "%l";
+------------+-------+---------------+--------------+---------------+-----------------+
| nis | nama | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |
+------------+-------+---------------+--------------+---------------+-----------------+
| 2147483647 | bedul | Laki-laki | Tangerang | 2025-11-03 | dd |
+------------+-------+---------------+--------------+---------------+-----------------+
1 row in set (0.000 sec)
2. Tampilkan data siswa yang memiliki nama awalan huruf "b"
MariaDB [db_smk]> select*from tb_siswa WHERE nama LIKE "b%";
+------------+-------+---------------+--------------+---------------+-----------------+
| nis | nama | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |
+------------+-------+---------------+--------------+---------------+-----------------+
| 2147483647 | bedul | Laki-laki | Tangerang | 2025-11-03 | dd |
+------------+-------+---------------+--------------+---------------+-----------------+
1 row in set (0.000 sec)
3. Tampilkan data siswa yang memiliki nis dari 126 sampai 127
MariaDB [db_smk]> select*from tb_siswa WHERE nis BETWEEN 126 AND 127;
+-----+-------------+---------------+--------------+---------------+-----------------+
| nis | nama | jenis_kelamin | tempat_lahir | tanggal_lahir | nama_ibukandung |
+-----+-------------+---------------+--------------+---------------+-----------------+
| 126 | Abyan Nadif | Laki-laki | Jakarta | 2012-11-19 | Ina |
| 127 | Jaka | Laki-laki | Pandeglang | 2008-12-08 | Inu |
+-----+-------------+---------------+--------------+---------------+-----------------+
2 rows in set (0.001 sec)
Tidak ada komentar:
Posting Komentar