Letakkan berkas disini

SQL upload ( 0 ) x-

Server: localhost »Basis data: sik2 »Tabel: aturan_pakai
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 114433, Pencarian dilakukan dalam 0.0008 detik.)
SELECT * FROM `aturan_pakai`
[Edit dikotak] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan]
|
|
|
Jumlah baris:
Saring baris:
Urut berdasarkan kunci:
Teks penuhtgl_perawatanjamno_rawatkode_brngaturan
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-03-20\' AND `aturan_pakai`.`jam` = \'11:17:48\' AND `aturan_pakai`.`no_rawat` = \'2020/03/20/000033\' AND `aturan_pakai`.`kode_brng` = \'A000000052\'
2020-03-20 11:17:48 2020/03/20/000033 A000000052 1x1
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-03-20\' AND `aturan_pakai`.`jam` = \'11:17:48\' AND `aturan_pakai`.`no_rawat` = \'2020/03/20/000033\' AND `aturan_pakai`.`kode_brng` = \'A000000137\'
2020-03-20 11:17:48 2020/03/20/000033 A000000137 prn
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-03-20\' AND `aturan_pakai`.`jam` = \'11:17:48\' AND `aturan_pakai`.`no_rawat` = \'2020/03/20/000033\' AND `aturan_pakai`.`kode_brng` = \'A000000180\'
2020-03-20 11:17:48 2020/03/20/000033 A000000180 6x1
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-03-20\' AND `aturan_pakai`.`jam` = \'11:18:33\' AND `aturan_pakai`.`no_rawat` = \'2020/03/20/000034\' AND `aturan_pakai`.`kode_brng` = \'A000000232\'
2020-03-20 11:18:33 2020/03/20/000034 A000000232 6x1
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-03-20\' AND `aturan_pakai`.`jam` = \'11:19:46\' AND `aturan_pakai`.`no_rawat` = \'2020/03/20/000032\' AND `aturan_pakai`.`kode_brng` = \'A000000198\'
2020-03-20 11:19:46 2020/03/20/000032 A000000198 2x1
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-03-20\' AND `aturan_pakai`.`jam` = \'11:21:35\' AND `aturan_pakai`.`no_rawat` = \'2020/03/20/000031\' AND `aturan_pakai`.`kode_brng` = \'A000000040\'
2020-03-20 11:21:35 2020/03/20/000031 A000000040 prn
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-03-20\' AND `aturan_pakai`.`jam` = \'11:21:35\' AND `aturan_pakai`.`no_rawat` = \'2020/03/20/000031\' AND `aturan_pakai`.`kode_brng` = \'A000000202\'
2020-03-20 11:21:35 2020/03/20/000031 A000000202 tiap 2 jam
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-03-20\' AND `aturan_pakai`.`jam` = \'11:21:35\' AND `aturan_pakai`.`no_rawat` = \'2020/03/20/000031\' AND `aturan_pakai`.`kode_brng` = \'A000000206\'
2020-03-20 11:21:35 2020/03/20/000031 A000000206 tiap 1 jam
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-03-20\' AND `aturan_pakai`.`jam` = \'11:23:44\' AND `aturan_pakai`.`no_rawat` = \'2020/03/20/000029\' AND `aturan_pakai`.`kode_brng` = \'A000000220\'
2020-03-20 11:23:44 2020/03/20/000029 A000000220 tiap 2 jam
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-03-20\' AND `aturan_pakai`.`jam` = \'11:23:44\' AND `aturan_pakai`.`no_rawat` = \'2020/03/20/000029\' AND `aturan_pakai`.`kode_brng` = \'A000000232\'
2020-03-20 11:23:44 2020/03/20/000029 A000000232 tiap 1 jam
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-05-08\' AND `aturan_pakai`.`jam` = \'10:50:04\' AND `aturan_pakai`.`no_rawat` = \'2020/05/08/000015\' AND `aturan_pakai`.`kode_brng` = \'A000000206\'
2020-05-08 10:50:04 2020/05/08/000015 A000000206 6 x 1 mata kiri
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-05-08\' AND `aturan_pakai`.`jam` = \'10:50:04\' AND `aturan_pakai`.`no_rawat` = \'2020/05/08/000015\' AND `aturan_pakai`.`kode_brng` = \'A000000241\'
2020-05-08 10:50:04 2020/05/08/000015 A000000241 6 x 1 mata kiri
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-05-08\' AND `aturan_pakai`.`jam` = \'10:56:43\' AND `aturan_pakai`.`no_rawat` = \'2020/05/08/000008\' AND `aturan_pakai`.`kode_brng` = \'A000000220\'
2020-05-08 10:56:43 2020/05/08/000008 A000000220 per 2 jam
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-05-08\' AND `aturan_pakai`.`jam` = \'10:56:43\' AND `aturan_pakai`.`no_rawat` = \'2020/05/08/000008\' AND `aturan_pakai`.`kode_brng` = \'A000000232\'
2020-05-08 10:56:43 2020/05/08/000008 A000000232 per 2 jam
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-05-08\' AND `aturan_pakai`.`jam` = \'10:58:58\' AND `aturan_pakai`.`no_rawat` = \'2020/05/08/000022\' AND `aturan_pakai`.`kode_brng` = \'A000000252\'
2020-05-08 10:58:58 2020/05/08/000022 A000000252 3 x 1 mata kanan&kiri
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-05-11\' AND `aturan_pakai`.`jam` = \'14:02:12\' AND `aturan_pakai`.`no_rawat` = \'2020/05/11/000003\' AND `aturan_pakai`.`kode_brng` = \'A000000040\'
2020-05-11 14:02:12 2020/05/11/000003 A000000040 3 x 1
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-05-11\' AND `aturan_pakai`.`jam` = \'14:02:12\' AND `aturan_pakai`.`no_rawat` = \'2020/05/11/000003\' AND `aturan_pakai`.`kode_brng` = \'A000000141\'
2020-05-11 14:02:12 2020/05/11/000003 A000000141 2 X 1
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-11-20\' AND `aturan_pakai`.`jam` = \'12:04:06\' AND `aturan_pakai`.`no_rawat` = \'2020/11/20/000019\' AND `aturan_pakai`.`kode_brng` = \'A000000220\'
2020-11-20 12:04:06 2020/11/20/000019 A000000220 tiap 2 jam od
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-11-20\' AND `aturan_pakai`.`jam` = \'12:06:07\' AND `aturan_pakai`.`no_rawat` = \'2020/11/20/000017\' AND `aturan_pakai`.`kode_brng` = \'A000000220\'
2020-11-20 12:06:07 2020/11/20/000017 A000000220 6x010od
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-11-20\' AND `aturan_pakai`.`jam` = \'12:07:09\' AND `aturan_pakai`.`no_rawat` = \'2020/11/20/000015\' AND `aturan_pakai`.`kode_brng` = \'A000000143\'
2020-11-20 12:07:09 2020/11/20/000015 A000000143 1x1
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-11-20\' AND `aturan_pakai`.`jam` = \'12:07:09\' AND `aturan_pakai`.`no_rawat` = \'2020/11/20/000015\' AND `aturan_pakai`.`kode_brng` = \'A000000220\'
2020-11-20 12:07:09 2020/11/20/000015 A000000220 6x10os
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-11-20\' AND `aturan_pakai`.`jam` = \'12:07:52\' AND `aturan_pakai`.`no_rawat` = \'2020/11/20/000011\' AND `aturan_pakai`.`kode_brng` = \'A000000220\'
2020-11-20 12:07:52 2020/11/20/000011 A000000220 6x1os
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-11-20\' AND `aturan_pakai`.`jam` = \'12:09:30\' AND `aturan_pakai`.`no_rawat` = \'2020/11/20/000014\' AND `aturan_pakai`.`kode_brng` = \'A000000202\'
2020-11-20 12:09:30 2020/11/20/000014 A000000202 2jam 1os
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-11-20\' AND `aturan_pakai`.`jam` = \'12:09:30\' AND `aturan_pakai`.`no_rawat` = \'2020/11/20/000014\' AND `aturan_pakai`.`kode_brng` = \'A000000206\'
2020-11-20 12:09:30 2020/11/20/000014 A000000206 6x1os
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `aturan_pakai` WHERE `aturan_pakai`.`tgl_perawatan` = \'2020-11-20\' AND `aturan_pakai`.`jam` = \'12:09:30\' AND `aturan_pakai`.`no_rawat` = \'2020/11/20/000014\' AND `aturan_pakai`.`kode_brng` = \'A000000227\'
2020-11-20 12:09:30 2020/11/20/000014 A000000227 4x1os
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