Utuk membaca reakaman menggunakan perintah SELECT kolom1, kolom2, ... FROM nama_tabel1, nama_tabel2 WHERE ...
Contoh:
MariaDB [db1]> SELECT * FROM propinsi;
+----+-----------------+------------+------------+
| id | propinsi | created_at | updated_at |
+----+-----------------+------------+------------+
| 1 | D.I. Yogyakarta | NULL | NULL |
| 2 | Jawa Tengah | NULL | NULL |
| 3 | Jawa Timur | NULL | NULL |
+----+-----------------+------------+------------+
3 rows in set (0.071 sec)
Menampilkan rekaman tabel propinsi kriteria id=2
MariaDB [db1]> SELECT * FROM propinsi WHERE id=2;
+----+-------------+------------+------------+
| id | propinsi | created_at | updated_at |
+----+-------------+------------+------------+
| 2 | Jawa Tengah | NULL | NULL |
+----+-------------+------------+------------+
1 row in set (0.001 sec)
Menampilkan kolom id dan propinsi, dari tabel propinsi
MariaDB [db1]> SELECT id,propinsi FROM propinsi;
+----+-----------------+
| id | propinsi |
+----+-----------------+
| 1 | D.I. Yogyakarta |
| 2 | Jawa Tengah |
| 3 | Jawa Timur |
+----+-----------------+
3 rows in set (0.001 sec)