Letakkan berkas disini

SQL upload ( 0 ) x-

Server: localhost »Basis data: sikterbaru »Tabel: detail_pemberian_obat
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 49, Pencarian dilakukan dalam 0.0008 detik.)
SELECT * FROM `detail_pemberian_obat`
[Edit dikotak] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan]
|
|
|
|
Jumlah baris:
Saring baris:
Urut berdasarkan kunci:
Teks penuhtgl_perawatanjamno_rawatkode_brngh_belibiaya_obatjmlembalasetuslahtotalstatuskd_bangsalno_batchno_faktur
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-04-26\' AND `detail_pemberian_obat`.`jam` = \'09:26:01\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/04/26/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000556\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-04-26 09:26:01 2025/04/26/000001 B000000556 1138 1367 10 0 0 13670 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-04-27\' AND `detail_pemberian_obat`.`jam` = \'08:42:17\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/04/27/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000790\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-04-27 08:42:17 2025/04/27/000001 B000000790 4991 5989 10 0 0 59890 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-04-28\' AND `detail_pemberian_obat`.`jam` = \'09:17:28\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/04/28/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000791\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-04-28 09:17:28 2025/04/28/000001 B000000791 1110 1332 10 0 0 13320 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-04-28\' AND `detail_pemberian_obat`.`jam` = \'09:17:28\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/04/28/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000965\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-04-28 09:17:28 2025/04/28/000001 B000000965 333 400 10 0 0 4000 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-04-28\' AND `detail_pemberian_obat`.`jam` = \'09:23:14\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/04/28/000002\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000557\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-04-28 09:23:14 2025/04/28/000002 B000000557 926 1111 10 0 0 11110 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-04-28\' AND `detail_pemberian_obat`.`jam` = \'09:23:14\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/04/28/000002\' AND `detail_pemberian_obat`.`kode_brng` = \'B000001704\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-04-28 09:23:14 2025/04/28/000002 B000001704 69340 83208 1 0 0 83208 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-05-22\' AND `detail_pemberian_obat`.`jam` = \'11:28:50\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/05/22/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B000001294\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-05-22 11:28:50 2025/05/22/000001 B000001294 10688 17569 10 0 0 175690 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-05-26\' AND `detail_pemberian_obat`.`jam` = \'10:36:43\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/05/26/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000556\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-05-26 10:36:43 2025/05/26/000001 B000000556 1138 1367.121312 9 0 0 12304 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-05-26\' AND `detail_pemberian_obat`.`jam` = \'10:36:43\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/05/26/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000791\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-05-26 10:36:43 2025/05/26/000001 B000000791 1110 1332 10 0 0 13320 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-05-26\' AND `detail_pemberian_obat`.`jam` = \'10:36:43\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/05/26/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B000001207\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-05-26 10:36:43 2025/05/26/000001 B000001207 2078 3300 8 0 0 26400 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-05-26\' AND `detail_pemberian_obat`.`jam` = \'10:36:43\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/05/26/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B00001000\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-05-26 10:36:43 2025/05/26/000001 B00001000 5550 6660 10 0 0 66600 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-06-03\' AND `detail_pemberian_obat`.`jam` = \'08:51:00\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/06/03/000002\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000575\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-06-03 08:51:00 2025/06/03/000002 B000000575 3223 4835 10 0 0 48350 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-06-03\' AND `detail_pemberian_obat`.`jam` = \'08:51:00\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/06/03/000002\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000791\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-06-03 08:51:00 2025/06/03/000002 B000000791 1110 1332 10 0 0 13320 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-06-03\' AND `detail_pemberian_obat`.`jam` = \'09:05:34\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/06/03/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000694\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-06-03 09:05:34 2025/06/03/000001 B000000694 1815 2178 10 0 0 21780 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-06-04\' AND `detail_pemberian_obat`.`jam` = \'20:38:11\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/06/04/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000789\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-06-04 20:38:11 2025/06/04/000001 B000000789 15400 18480 1 0 0 18480 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-06-04\' AND `detail_pemberian_obat`.`jam` = \'20:38:11\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/06/04/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B00001000\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-06-04 20:38:11 2025/06/04/000001 B00001000 5550 6660 10 0 0 66600 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-06-11\' AND `detail_pemberian_obat`.`jam` = \'19:33:47\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/06/11/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000965\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-06-11 19:33:47 2025/06/11/000001 B000000965 333 400 10 0 0 4000 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-06-18\' AND `detail_pemberian_obat`.`jam` = \'11:04:44\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/04/25/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000791\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-06-18 11:04:44 2025/04/25/000001 B000000791 1110 1332 20 0 0 26640 Ranap AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-06-18\' AND `detail_pemberian_obat`.`jam` = \'11:04:44\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/04/25/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000965\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-06-18 11:04:44 2025/04/25/000001 B000000965 333 400 10 0 0 4000 Ranap AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-06-25\' AND `detail_pemberian_obat`.`jam` = \'09:03:22\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/06/25/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000003\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-06-25 09:03:22 2025/06/25/000001 B000000003 40040 68640 10 0 0 686400 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-06-25\' AND `detail_pemberian_obat`.`jam` = \'09:03:22\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/06/25/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000556\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-06-25 09:03:22 2025/06/25/000001 B000000556 1138 1367 10 0 0 13670 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-06-28\' AND `detail_pemberian_obat`.`jam` = \'10:07:01\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/06/28/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000789\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-06-28 10:07:01 2025/06/28/000001 B000000789 15400 18480 1 0 0 18480 Ranap AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-06-30\' AND `detail_pemberian_obat`.`jam` = \'09:44:14\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/06/30/000003\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000305\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-06-30 09:44:14 2025/06/30/000003 B000000305 133 160 7 0 0 1120 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-06-30\' AND `detail_pemberian_obat`.`jam` = \'09:44:14\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/06/30/000003\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000554\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-06-30 09:44:14 2025/06/30/000003 B000000554 11000 13200 7 0 0 92400 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2025-06-30\' AND `detail_pemberian_obat`.`jam` = \'09:44:14\' AND `detail_pemberian_obat`.`no_rawat` = \'2025/06/30/000003\' AND `detail_pemberian_obat`.`kode_brng` = \'B000000791\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2025-06-30 09:44:14 2025/06/30/000003 B000000791 1110 1332 10 0 0 13320 Ralan AP
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