Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `detail_piutang_pasien`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts no_rawat nama_bayar kd_pj totalpiutang sisapiutang tgltempo
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/06/000007' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/06/000007 PIUTANG BPJS BPJ 8198070 8198070 2023-10-16
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/11/000001' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/11/000001 PIUTANG BPJS BPJ 203468 0 2023-10-11
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/16/000003' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/16/000003 PIUTANG BPJS BPJ 10443 10443 2023-10-16
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/20/000026' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/20/000026 PIUTANG BPJS BPJ 2435419 2435419 2024-01-19
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000001' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000001 PIUTANG BPJS BPJ 221156 221156 2023-10-29
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000002' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000002 PIUTANG BPJS BPJ 221156 221156 2023-10-29
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000004' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000004 PIUTANG BPJS BPJ 177027 177027 2023-10-30
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000005' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000005 PIUTANG BPJS BPJ 285276 285276 2023-10-29
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000006' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000006 PIUTANG BPJS BPJ 224601 224601 2023-10-29
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000007' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000007 PIUTANG BPJS BPJ 221885 221885 2023-10-29
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000008' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000008 PIUTANG BPJS BPJ 147541 147541 2023-10-30
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000009' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000009 PIUTANG BPJS BPJ 133988 133988 2023-11-14
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000010' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000010 PIUTANG BPJS BPJ 223024 223024 2023-10-29
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000011' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000011 PIUTANG BPJS BPJ 176751 176751 2023-10-29
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000012' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000012 PIUTANG BPJS BPJ 203489 203489 2023-10-29
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000013' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000013 PIUTANG BPJS BPJ 156978 156978 2023-10-30
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000016' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000016 PIUTANG BPJS BPJ 193514 193514 2023-10-30
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000017' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000017 PIUTANG BPJS BPJ 221156 221156 2023-10-29
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000018' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000018 PIUTANG BPJS BPJ 223290 223290 2023-10-29
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000019' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000019 PIUTANG BPJS BPJ 217558 217558 2023-10-30
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000020' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000020 PIUTANG BPJS BPJ 208816 208816 2023-10-30
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000021' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000021 PIUTANG BPJS BPJ 311782 311782 2023-10-28
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000022' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000022 PIUTANG BPJS BPJ 174262 174262 2023-10-29
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000023' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000023 PIUTANG BPJS BPJ 443620 443620 2023-10-29
Edit Edit Copy Copy Delete Delete
DELETE FROM detail_piutang_pasien WHERE `detail_piutang_pasien`.`no_rawat` = '2023/10/26/000024' AND `detail_piutang_pasien`.`nama_bayar` = 'PIUTANG BPJS'
2023/10/26/000024 PIUTANG BPJS BPJ 229310 229310 2023-10-29
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query