Letakkan berkas disini

SQL upload ( 0 ) x-

Server: localhost »Basis data: sikterbaru »Tabel: opname
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 125, Pencarian dilakukan dalam 0.0014 detik.)
SELECT * FROM `opname`
[Edit dikotak] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan]
|
|
|
|
Jumlah baris:
Saring baris:
Urut berdasarkan kunci:
Teks penuhkode_brngh_belitanggalstokrealselisihnomihilanglebihnomilebihketerangankd_bangsalno_batchno_faktur
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'2018001\' AND `opname`.`tanggal` = \'2023-03-07\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
2018001 21259 2023-03-07 108 90 18 382662 0 0 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'2018001\' AND `opname`.`tanggal` = \'2024-06-03\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
2018001 16518 2024-06-03 30 80 0 0 50 825900 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'2018003\' AND `opname`.`tanggal` = \'2025-01-24\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
2018003 237857 2025-01-24 322.0333333333333 200 1192 283525544 0 0 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000001\' AND `opname`.`tanggal` = \'2021-03-22\' AND `opname`.`kd_bangsal` = \'GD\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000001 17569 2021-03-22 0 100 0 0 100 1756900 - GD
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000002\' AND `opname`.`tanggal` = \'2021-05-20\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000002 12100 2021-05-20 0 100 0 0 100 1210000 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000003\' AND `opname`.`tanggal` = \'2020-03-10\' AND `opname`.`kd_bangsal` = \'GD\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000003 45000 2020-03-10 0 400 0 0 400 18000000 penambahan GD
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000143\' AND `opname`.`tanggal` = \'2025-06-30\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000143 34081 2025-06-30 100 100 0 0 0 0 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000156\' AND `opname`.`tanggal` = \'2020-11-23\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000156 9350 2020-11-23 0 100 0 0 100 935000 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000156\' AND `opname`.`tanggal` = \'2022-06-09\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000156 9350 2022-06-09 0 100 0 0 100 935000 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000157\' AND `opname`.`tanggal` = \'2020-11-23\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000157 100650 2020-11-23 0 200 0 0 200 20130000 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000167\' AND `opname`.`tanggal` = \'2021-04-06\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000167 175 2021-04-06 0 1000 0 0 1000 175000 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000218\' AND `opname`.`tanggal` = \'2023-10-11\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000218 797 2023-10-11 0 100 0 0 100 79700 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000271\' AND `opname`.`tanggal` = \'2022-06-09\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000271 88000 2022-06-09 0 100 0 0 100 8800000 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000280\' AND `opname`.`tanggal` = \'2020-10-21\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000280 2090 2020-10-21 0 127 0 0 127 265430 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000287\' AND `opname`.`tanggal` = \'2025-08-26\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000287 360525 2025-08-26 0 100 0 0 100 36052500 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000305\' AND `opname`.`tanggal` = \'2021-05-23\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000305 14960 2021-05-23 0 100 0 0 100 1496000 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000305\' AND `opname`.`tanggal` = \'2022-06-17\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000305 20570 2022-06-17 995.4 1000 0 0 4.600000000000023 94622.00000000047 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000340\' AND `opname`.`tanggal` = \'2024-01-11\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000340 7150 2024-01-11 0 100 0 0 100 715000 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000376\' AND `opname`.`tanggal` = \'2022-09-07\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000376 3497 2022-09-07 95 100 0 0 5 17485 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000396\' AND `opname`.`tanggal` = \'2021-09-08\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000396 69300.456 2021-09-08 0 70 0 0 70 4851031.92 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000481\' AND `opname`.`tanggal` = \'2021-05-27\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000481 23788 2021-05-27 0 100 0 0 100 2378800 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000482\' AND `opname`.`tanggal` = \'2021-04-08\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000482 27637 2021-04-08 0 10 0 0 10 276370 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000552\' AND `opname`.`tanggal` = \'2020-09-11\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000552 13310 2020-09-11 10 100 0 0 90 1197900 tes AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000552\' AND `opname`.`tanggal` = \'2021-05-28\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000552 13310 2021-05-28 0 100 0 0 100 1331000 - AP
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `opname` WHERE `opname`.`kode_brng` = \'B000000553\' AND `opname`.`tanggal` = \'2020-07-07\' AND `opname`.`kd_bangsal` = \'AP\' AND `opname`.`no_batch` = \'\' AND `opname`.`no_faktur` = \'\'
B000000553 51244 2020-07-07 0 89 0 0 89 4560716 - 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