Letakkan berkas disini

SQL upload ( 0 ) x -

Pengaturan Terkait dengan Halaman Klik 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.
Modus jelajah
Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya. Kembalikan nilai bawaan
Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya. Kembalikan nilai bawaan
Dokumentasi Whether a user should be displayed a "show all (rows)" button. Kembalikan nilai bawaan
Dokumentasi Jumlah baris yang ditampilkan saat browsing hasil set. Jika hasil set berisi lebih dari satu baris, tautan "Previous" and "Next" akan ditampilkan. Kembalikan nilai bawaan
Dokumentasi SMART - yaitu urutan untuk kolom jenis TIME, DATE, DATETIME dan TIMESTAMP, urutan ascending dan sebaliknya. Kembalikan nilai bawaan
Dokumentasi Sorot baris yang ditunjuk dengan kursor mouse. Kembalikan nilai bawaan
Dokumentasi Sorot baris terpilih. Kembalikan nilai bawaan
Dokumentasi Kembalikan nilai bawaan
Dokumentasi Kembalikan nilai bawaan
Dokumentasi Ulangi header setiap X sel, 0 menonaktifkan fitur ini. Kembalikan nilai bawaan
Dokumentasi Jumlah maksimum karakter yang ditunjukkan pada kolom non-angka pada mode jelajah. Kembalikan nilai bawaan
Dokumentasi Berikut ini adalah tautan Edit, Salin, dan Hapus. Kembalikan nilai bawaan
Dokumentasi Apakah untuk menampilkan link baris bahkan tanpa adanya unique key. Kembalikan nilai bawaan
Dokumentasi Default sort order for tables with a primary key. Kembalikan nilai bawaan
Dokumentasi Saat browsing tabel, penyortiran setiap tabel akan diingat. Kembalikan nilai bawaan
Dokumentasi Untuk pengaturan tampilan Kembalikan nilai bawaan
SELECT * FROM `aturan_pakai`
Edit dikotak ] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan ]
Teks penuh tgl_perawatan jam no_rawat kode_brng aturan
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0002-01-16' AND `aturan_pakai`.`jam` = '23:38:49' AND `aturan_pakai`.`no_rawat` = '2023/01/13/000193' AND `aturan_pakai`.`kode_brng` = 'B000000393'
0002-01-16 23:38:49 2023/01/13/000193 B000000393 1 X 1 TABLET/KAPSUL, SEBELUM MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0002-03-26' AND `aturan_pakai`.`jam` = '17:55:11' AND `aturan_pakai`.`no_rawat` = '2023/03/26/000028' AND `aturan_pakai`.`kode_brng` = 'B000000128'
0002-03-26 17:55:11 2023/03/26/000028 B000000128 3 X 1 SENDOK MAKAN, SEBELUM MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0002-03-26' AND `aturan_pakai`.`jam` = '17:55:11' AND `aturan_pakai`.`no_rawat` = '2023/03/26/000028' AND `aturan_pakai`.`kode_brng` = 'B000000298'
0002-03-26 17:55:11 2023/03/26/000028 B000000298 2 X 1 TABLET/KAPSUL, SETELAH MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0002-03-26' AND `aturan_pakai`.`jam` = '17:55:11' AND `aturan_pakai`.`no_rawat` = '2023/03/26/000028' AND `aturan_pakai`.`kode_brng` = 'B000000393'
0002-03-26 17:55:11 2023/03/26/000028 B000000393 1 X 1 TABLET/KAPSUL, SEBELUM MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0002-03-26' AND `aturan_pakai`.`jam` = '17:55:11' AND `aturan_pakai`.`no_rawat` = '2023/03/26/000028' AND `aturan_pakai`.`kode_brng` = 'B000000497'
0002-03-26 17:55:11 2023/03/26/000028 B000000497 2 X 1 TABLET/KAPSUL, SEBELUM MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0002-03-26' AND `aturan_pakai`.`jam` = '17:55:11' AND `aturan_pakai`.`no_rawat` = '2023/03/26/000028' AND `aturan_pakai`.`kode_brng` = 'B000001119'
0002-03-26 17:55:11 2023/03/26/000028 B000001119 3 X 1 TABLET/KAPSUL, SETELAH MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0002-07-17' AND `aturan_pakai`.`jam` = '08:40:03' AND `aturan_pakai`.`no_rawat` = '2023/07/14/001389' AND `aturan_pakai`.`kode_brng` = 'B000000095'
0002-07-17 08:40:03 2023/07/14/001389 B000000095 1 X 1 SENDOK TAKAR (5ML), SETELAH MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0020-01-12' AND `aturan_pakai`.`jam` = '14:43:07' AND `aturan_pakai`.`no_rawat` = '2023/01/12/000667' AND `aturan_pakai`.`kode_brng` = 'B000000246'
0020-01-12 14:43:07 2023/01/12/000667 B000000246 2 X 1 SETELAH MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0020-05-23' AND `aturan_pakai`.`jam` = '22:03:03' AND `aturan_pakai`.`no_rawat` = '2023/05/22/000645' AND `aturan_pakai`.`kode_brng` = 'B000000208'
0020-05-23 22:03:03 2023/05/22/000645 B000000208 3X1 SETELAH MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0020-05-23' AND `aturan_pakai`.`jam` = '22:03:03' AND `aturan_pakai`.`no_rawat` = '2023/05/22/000645' AND `aturan_pakai`.`kode_brng` = 'B000000251'
0020-05-23 22:03:03 2023/05/22/000645 B000000251 2X1 SETELAH MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0020-05-23' AND `aturan_pakai`.`jam` = '22:03:03' AND `aturan_pakai`.`no_rawat` = '2023/05/22/000645' AND `aturan_pakai`.`kode_brng` = 'B000000393'
0020-05-23 22:03:03 2023/05/22/000645 B000000393 2X1 SEBELUM MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0020-05-23' AND `aturan_pakai`.`jam` = '22:03:03' AND `aturan_pakai`.`no_rawat` = '2023/05/22/000645' AND `aturan_pakai`.`kode_brng` = 'B000001127'
0020-05-23 22:03:03 2023/05/22/000645 B000001127 2X1 SETELAH MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0020-06-29' AND `aturan_pakai`.`jam` = '17:34:59' AND `aturan_pakai`.`no_rawat` = '2023/06/26/000453' AND `aturan_pakai`.`kode_brng` = 'B000000042'
0020-06-29 17:34:59 2023/06/26/000453 B000000042 3 X 1 SENDOK TAKAR ( 5 ML ), SEBELUM MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0020-08-21' AND `aturan_pakai`.`jam` = '14:52:18' AND `aturan_pakai`.`no_rawat` = '2023/08/18/000488' AND `aturan_pakai`.`kode_brng` = 'B000000222'
0020-08-21 14:52:18 2023/08/18/000488 B000000222 3 X 1 TABLET/KAPSUL, SETELAH MAKAN. JIKA PUSING
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0020-08-21' AND `aturan_pakai`.`jam` = '14:52:18' AND `aturan_pakai`.`no_rawat` = '2023/08/18/000488' AND `aturan_pakai`.`kode_brng` = 'B000001371'
0020-08-21 14:52:18 2023/08/18/000488 B000001371 1 X 1 TABLET/KAPSUL, SETELAH MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0020-08-21' AND `aturan_pakai`.`jam` = '14:52:18' AND `aturan_pakai`.`no_rawat` = '2023/08/18/000488' AND `aturan_pakai`.`kode_brng` = 'B000001372'
0020-08-21 14:52:18 2023/08/18/000488 B000001372 1 X 1 TABLET/KAPSUL, SEBELUM MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0020-08-21' AND `aturan_pakai`.`jam` = '14:52:18' AND `aturan_pakai`.`no_rawat` = '2023/08/18/000488' AND `aturan_pakai`.`kode_brng` = 'B000001423'
0020-08-21 14:52:18 2023/08/18/000488 B000001423 2 X 1 TABLET/KAPSUL SETELAH MAKAN, PAGI - MALAM ( ...
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0020-09-04' AND `aturan_pakai`.`jam` = '12:09:03' AND `aturan_pakai`.`no_rawat` = '2023/09/04/000295' AND `aturan_pakai`.`kode_brng` = 'B000000498'
0020-09-04 12:09:03 2023/09/04/000295 B000000498 -
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0202-01-14' AND `aturan_pakai`.`jam` = '01:32:49' AND `aturan_pakai`.`no_rawat` = '2023/01/13/000107' AND `aturan_pakai`.`kode_brng` = 'B000000959'
0202-01-14 01:32:49 2023/01/13/000107 B000000959 1 X 1 BUNGKUS, SEBELUM MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0202-02-02' AND `aturan_pakai`.`jam` = '23:51:30' AND `aturan_pakai`.`no_rawat` = '2023/02/02/001367' AND `aturan_pakai`.`kode_brng` = 'B000000291'
0202-02-02 23:51:30 2023/02/02/001367 B000000291 -
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0202-02-02' AND `aturan_pakai`.`jam` = '23:51:30' AND `aturan_pakai`.`no_rawat` = '2023/02/02/001367' AND `aturan_pakai`.`kode_brng` = 'B000000461'
0202-02-02 23:51:30 2023/02/02/001367 B000000461 K/P
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0202-02-07' AND `aturan_pakai`.`jam` = '12:45:18' AND `aturan_pakai`.`no_rawat` = '2024/02/06/001854' AND `aturan_pakai`.`kode_brng` = 'B000000250'
0202-02-07 12:45:18 2024/02/06/001854 B000000250 2 X 1 TABLET/KAPSUL, SETELAH MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0202-02-07' AND `aturan_pakai`.`jam` = '12:45:18' AND `aturan_pakai`.`no_rawat` = '2024/02/06/001854' AND `aturan_pakai`.`kode_brng` = 'B000000286'
0202-02-07 12:45:18 2024/02/06/001854 B000000286 3 X 1 TABLET/KAPSUL, SETELAH MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0202-02-07' AND `aturan_pakai`.`jam` = '12:45:18' AND `aturan_pakai`.`no_rawat` = '2024/02/06/001854' AND `aturan_pakai`.`kode_brng` = 'B000001530'
0202-02-07 12:45:18 2024/02/06/001854 B000001530 3 X 1 TABLET/KAPSUL, SETELAH MAKAN
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM aturan_pakai WHERE `aturan_pakai`.`tgl_perawatan` = '0202-04-16' AND `aturan_pakai`.`jam` = '11:49:30' AND `aturan_pakai`.`no_rawat` = '2023/04/13/000748' AND `aturan_pakai`.`kode_brng` = 'B000000208'
0202-04-16 11:49:30 2023/04/13/000748 B000000208 3 X 1 TABLET/KAPSUL, SETELAH MAKAN
Dengan pilihan: Dengan pilihan:
Operasi hasil kueri Salin ke clipboard Salin ke clipboard Ekspor Ekspor Tampilkan bagan Tampilkan bagan Buat tampilan Buat tampilan
Markahi kueri SQL ini Markahi kueri SQL ini