Letakkan berkas disini

SQL upload ( 0 ) x-

Server: localhost »Basis data: sik »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 157624, Pencarian dilakukan dalam 0.0014 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` = \'2019-12-26\' AND `detail_pemberian_obat`.`jam` = \'12:01:18\' AND `detail_pemberian_obat`.`no_rawat` = \'2019/12/26/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'OPTIK00002\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2019-12-26 12:01:18 2019/12/26/000001 OPTIK00002 200000 450000 1 0 0 450000 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2019-12-26\' AND `detail_pemberian_obat`.`jam` = \'12:23:23\' AND `detail_pemberian_obat`.`no_rawat` = \'2019/12/26/000002\' AND `detail_pemberian_obat`.`kode_brng` = \'OPTIK00001\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2019-12-26 12:23:23 2019/12/26/000002 OPTIK00001 225000 500000 1 0 0 500000 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2019-12-26\' AND `detail_pemberian_obat`.`jam` = \'12:23:23\' AND `detail_pemberian_obat`.`no_rawat` = \'2019/12/26/000002\' AND `detail_pemberian_obat`.`kode_brng` = \'OPTIK00002\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2019-12-26 12:23:23 2019/12/26/000002 OPTIK00002 200000 450000 1 0 0 450000 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2019-12-26\' AND `detail_pemberian_obat`.`jam` = \'12:44:08\' AND `detail_pemberian_obat`.`no_rawat` = \'2019/12/26/000002\' AND `detail_pemberian_obat`.`kode_brng` = \'OPTIK00001\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2019-12-26 12:44:08 2019/12/26/000002 OPTIK00001 225000 500000 1 0 0 500000 Ralan B0026
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'12:52:07\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000018\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000143\' AND `detail_pemberian_obat`.`no_batch` = \'-\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 12:52:07 2020/01/02/000018 A000000143 99 400 10 500 1500 6000 Ralan AP -
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'12:57:50\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000015\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000202\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 12:57:50 2020/01/02/000015 A000000202 76175 91500 1 0 1500 93000 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'12:57:50\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000015\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000211\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 12:57:50 2020/01/02/000015 A000000211 28875 34700 1 0 1500 36200 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'12:57:50\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000015\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000241\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 12:57:50 2020/01/02/000015 A000000241 50875 61100 1 700 1500 63300 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:14:33\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000012\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000206\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:14:33 2020/01/02/000012 A000000206 24750 27300 1 0 1500 28800 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:14:33\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000012\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000241\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:14:33 2020/01/02/000012 A000000241 50875 61100 1 0 1500 62600 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:16:44\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000016\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000143\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:16:44 2020/01/02/000016 A000000143 99 400 10 0 1500 5500 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:19:29\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000010\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000231\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:19:29 2020/01/02/000010 A000000231 18329 26680 1 0 1500 28180 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:25:14\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000011\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000052\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:25:14 2020/01/02/000011 A000000052 2363 3812 10 0 1500 39620 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:25:14\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000011\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000160\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:25:14 2020/01/02/000011 A000000160 33687 40500 1 0 1500 42000 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:37:20\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000009\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000211\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:37:20 2020/01/02/000009 A000000211 28875 34700 1 0 1500 36200 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:37:20\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000009\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000241\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:37:20 2020/01/02/000009 A000000241 50875 61100 1 0 1500 62600 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:41:28\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000006\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000052\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:41:28 2020/01/02/000006 A000000052 2363 3812 10 0 1500 39620 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:41:28\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000006\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000160\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:41:28 2020/01/02/000006 A000000160 33687 40500 1 0 1500 42000 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:45:52\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000013\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000180\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:45:52 2020/01/02/000013 A000000180 33577 40300 1 0 1500 41800 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:45:52\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000013\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000210\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:45:52 2020/01/02/000013 A000000210 21862 26300 1 0 1500 27800 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:46:55\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000014\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000180\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:46:55 2020/01/02/000014 A000000180 33577 40300 1 0 1500 41800 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:46:55\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000014\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000211\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:46:55 2020/01/02/000014 A000000211 28875 34700 1 0 1500 36200 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:47:57\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000003\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000206\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:47:57 2020/01/02/000003 A000000206 24750 27300 1 0 1500 28800 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:47:57\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000003\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000241\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:47:57 2020/01/02/000003 A000000241 50875 61100 1 0 1500 62600 Ralan AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:52:20\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000008\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000049\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:52:20 2020/01/02/000008 A000000049 2721 3266 5 0 1500 17830 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