Letakkan berkas disini

SQL upload ( 0 ) x-

Server: localhost »Basis data: sikterbaru »Tabel: rawat_jl_dr
Pengaturan Terkait dengan HalamanKlik pada bar untuk menggulir ke atas halaman
Tekan Ctrl+Enter untuk menjalankan kueri Press Enter to execute query
ascending
descending
Order:
Men-Debug SQL
Jumlah
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Tampilkan Buka Show trace Hide trace Jumlah Time taken
Bookmark
Segarkan
Tambah
Tidak ada penanda
Tambah bookmark
Opsi
Kembalikan nilai bawaan





Tampilkan Buka Kueri ulang Ubah Jelaskan Profil Bookmarks Kueri gagal Basis data : Waktu eksekusi kueri :

Modus jelajah

Atur mode jelajah.

Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya.
Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya.
Dokumentasi Whether a user should be displayed a "show all (rows)" button.
Dokumentasi Jumlah baris yang ditampilkan saat browsing hasil set. Jika hasil set berisi lebih dari satu baris, tautan "Previous" and "Next" akan ditampilkan.
Dokumentasi SMART - yaitu urutan untuk kolom jenis TIME, DATE, DATETIME dan TIMESTAMP, urutan ascending dan sebaliknya.
Dokumentasi Sorot baris yang ditunjuk dengan kursor mouse.
Dokumentasi Sorot baris terpilih.
Dokumentasi
Dokumentasi
Dokumentasi Ulangi header setiap X sel, 0 menonaktifkan fitur ini.
Dokumentasi Jumlah maksimum karakter yang ditunjukkan pada kolom non-angka pada mode jelajah.
Dokumentasi Berikut ini adalah tautan Edit, Salin, dan Hapus.
Dokumentasi Apakah untuk menampilkan link baris bahkan tanpa adanya unique key.
Dokumentasi Urutan default untuk tabel dengan primary key.
Dokumentasi Saat browsing tabel, penyortiran setiap tabel akan diingat.
Dokumentasi Untuk pengaturan tampilan
Menampilkan baris 0 - 24 (total 56, Pencarian dilakukan dalam 0.0011 detik.)
SELECT * FROM `rawat_jl_dr`
[Edit dikotak] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan]
|
|
|
|
Jumlah baris:
Saring baris:
Urut berdasarkan kunci:
Teks penuhno_rawatkd_jenis_prwkd_doktertgl_perawatanjam_rawatmaterialbhptarif_tindakandrksomenejemenbiaya_rawatstts_bayar
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/04/27/000001\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'C038\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-04-27\' AND `rawat_jl_dr`.`jam_rawat` = \'08:36:58\'
2025/04/27/000001 C038 D0000004 2025-04-27 08:36:58 20000 0 100000 0 0 120000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/04/27/000001\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'C039\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-04-27\' AND `rawat_jl_dr`.`jam_rawat` = \'08:36:58\'
2025/04/27/000001 C039 D0000004 2025-04-27 08:36:58 20000 0 50000 0 0 70000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/04/28/000001\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'RJ00002\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-04-28\' AND `rawat_jl_dr`.`jam_rawat` = \'09:16:26\'
2025/04/28/000001 RJ00002 D0000004 2025-04-28 09:16:26 200000 0 0 0 0 200000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/04/28/000003\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'J000473\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-04-28\' AND `rawat_jl_dr`.`jam_rawat` = \'09:44:17\'
2025/04/28/000003 J000473 D0000004 2025-04-28 09:44:17 30000 0 0 0 0 30000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/04/28/000003\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'JP000186\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-04-28\' AND `rawat_jl_dr`.`jam_rawat` = \'09:44:17\'
2025/04/28/000003 JP000186 D0000004 2025-04-28 09:44:17 35000 0 0 0 0 35000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/04/28/000003\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'JP000233\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-04-28\' AND `rawat_jl_dr`.`jam_rawat` = \'09:44:17\'
2025/04/28/000003 JP000233 D0000004 2025-04-28 09:44:17 75000 0 0 0 0 75000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/05/26/000001\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'C370\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-05-26\' AND `rawat_jl_dr`.`jam_rawat` = \'10:28:19\'
2025/05/26/000001 C370 D0000004 2025-05-26 10:28:19 25000 0 75000 0 0 100000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/05/26/000001\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'C515\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-05-26\' AND `rawat_jl_dr`.`jam_rawat` = \'10:28:19\'
2025/05/26/000001 C515 D0000004 2025-05-26 10:28:19 25000 0 125000 0 0 150000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/05/26/000001\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'RJ00002\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-05-26\' AND `rawat_jl_dr`.`jam_rawat` = \'10:28:19\'
2025/05/26/000001 RJ00002 D0000004 2025-05-26 10:28:19 200000 0 0 0 0 200000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/05/26/000001\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'RJ00864\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-05-26\' AND `rawat_jl_dr`.`jam_rawat` = \'10:28:19\'
2025/05/26/000001 RJ00864 D0000004 2025-05-26 10:28:19 40000 20000 60000 0 0 120000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/05/26/000002\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'J000457\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-05-26\' AND `rawat_jl_dr`.`jam_rawat` = \'11:20:40\'
2025/05/26/000002 J000457 D0000004 2025-05-26 11:20:40 26250 0 0 0 0 26250 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/05/26/000002\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'J000477\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-05-26\' AND `rawat_jl_dr`.`jam_rawat` = \'11:20:40\'
2025/05/26/000002 J000477 D0000004 2025-05-26 11:20:40 33000 0 0 0 0 33000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/05/26/000002\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'JP000208\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-05-26\' AND `rawat_jl_dr`.`jam_rawat` = \'11:20:40\'
2025/05/26/000002 JP000208 D0000004 2025-05-26 11:20:40 40000 0 0 0 0 40000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/06/03/000001\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'IGD.004\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-06-03\' AND `rawat_jl_dr`.`jam_rawat` = \'09:05:16\'
2025/06/03/000001 IGD.004 D0000004 2025-06-03 09:05:16 48000 0 32000 0 0 80000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/06/03/000001\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'RJ00001\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-06-03\' AND `rawat_jl_dr`.`jam_rawat` = \'09:05:16\'
2025/06/03/000001 RJ00001 D0000004 2025-06-03 09:05:16 90000 0 0 0 0 90000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/06/03/000002\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'RJ00861\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-06-03\' AND `rawat_jl_dr`.`jam_rawat` = \'08:46:51\'
2025/06/03/000002 RJ00861 D0000004 2025-06-03 08:46:51 50000 0 150000 0 50000 250000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/06/03/000003\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'C001\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-06-03\' AND `rawat_jl_dr`.`jam_rawat` = \'09:34:05\'
2025/06/03/000003 C001 D0000004 2025-06-03 09:34:05 100000 0 325000 0 0 425000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/06/03/000003\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'C102\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-06-03\' AND `rawat_jl_dr`.`jam_rawat` = \'09:34:05\'
2025/06/03/000003 C102 D0000004 2025-06-03 09:34:05 50000 0 50000 0 0 100000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/06/04/000001\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'JP1324565\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-06-04\' AND `rawat_jl_dr`.`jam_rawat` = \'20:37:27\'
2025/06/04/000001 JP1324565 D0000004 2025-06-04 20:37:27 25000 0 75000 0 0 100000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/06/11/000001\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'RJ00861\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-06-11\' AND `rawat_jl_dr`.`jam_rawat` = \'19:12:00\'
2025/06/11/000001 RJ00861 D0000004 2025-06-11 19:12:00 50000 0 150000 0 50000 250000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/06/11/000001\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'RJ00861\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-06-11\' AND `rawat_jl_dr`.`jam_rawat` = \'19:32:54\'
2025/06/11/000001 RJ00861 D0000004 2025-06-11 19:32:54 50000 0 150000 0 50000 250000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/06/20/000001\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'J000454\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-06-20\' AND `rawat_jl_dr`.`jam_rawat` = \'09:13:50\'
2025/06/20/000001 J000454 D0000004 2025-06-20 09:13:50 25000 0 0 0 0 25000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/06/20/000001\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'J000770\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-06-20\' AND `rawat_jl_dr`.`jam_rawat` = \'09:13:50\'
2025/06/20/000001 J000770 D0000004 2025-06-20 09:13:50 4000000 0 0 0 0 4000000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/06/20/000001\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'JP000153\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-06-20\' AND `rawat_jl_dr`.`jam_rawat` = \'09:13:50\'
2025/06/20/000001 JP000153 D0000004 2025-06-20 09:13:50 25000 0 75000 0 0 100000 Belum
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `rawat_jl_dr` WHERE `rawat_jl_dr`.`no_rawat` = \'2025/06/20/000002\' AND `rawat_jl_dr`.`kd_jenis_prw` = \'J000613\' AND `rawat_jl_dr`.`kd_dokter` = \'D0000004\' AND `rawat_jl_dr`.`tgl_perawatan` = \'2025-06-20\' AND `rawat_jl_dr`.`jam_rawat` = \'14:03:02\'
2025/06/20/000002 J000613 D0000004 2025-06-20 14:03:02 200000 0 0 0 0 200000 Belum
Dengan pilihan: Dengan pilihan:

|
|
|
|
Jumlah baris:
Saring baris:
Urut berdasarkan kunci:
Operasi hasil kueriCetak CetakSalin ke clipboard Salin ke clipboardEkspor Ekspor Tampilkan bagan Tampilkan bagan Buat tampilan Buat tampilan

Markahi kueri SQL ini Markahi kueri SQL ini