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 `akun_piutang`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts nama_bayar kd_rek kd_pj
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '16. Piutang AdMedika'
16. Piutang AdMedika 1170 A22
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '17. Piutang Tirta Medical Centre'
17. Piutang Tirta Medical Centre 1170 A23
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '11. Piutang Hutang Pribadi Karyawan'
11. Piutang Hutang Pribadi Karyawan 117001 A14
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '14. Piutang SUNTORY GARUDA'
14. Piutang SUNTORY GARUDA 117001 A19
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '18. Piutang RWII Rajal'
18. Piutang RWII Rajal 117001 A25
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '21. Piutang PT Andalan Fluid'
21. Piutang PT Andalan Fluid 117001 A28
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '22. Piutang PT Agro Abadi'
22. Piutang PT Agro Abadi 117001 A30
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '24. Pengurusan JR BPJS Kesehatan'
24. Pengurusan JR BPJS Kesehatan 117001 A31
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '30. Piutang Pasien'
30. Piutang Pasien 117001 A34
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '32. Piutang PT Mutiara Rimbo Engineering'
32. Piutang PT Mutiara Rimbo Engineering 117001 A35
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '34. Piutang Adi Nagasindo'
34. Piutang Adi Nagasindo 117001 A36
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '36. Piutang PT Agro pangan maju'
36. Piutang PT Agro pangan maju 117001 A38
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '3. Piutang BP-JAMSOSTEK'
3. Piutang BP-JAMSOSTEK 117001 BP2
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '6. Piutang ANGGUN BUSANA'
6. Piutang ANGGUN BUSANA 117001 CB1
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '12. Piutang Indofood'
12. Piutang Indofood 117001 IF1
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '4.Jasa Raharja'
4.Jasa Raharja 117001 JRH
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '10. Putang LABERSA HUTAHEAN ( HOTEL )'
10. Putang LABERSA HUTAHEAN ( HOTEL ) 117001 LH1
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '8. Piutang LABERSA HUTAHAEAN ( WATERPARK )'
8. Piutang LABERSA HUTAHAEAN ( WATERPARK ) 117001 LH2
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '9. Piutang LABERSA HUTAHEAN ( GOLF )'
9. Piutang LABERSA HUTAHEAN ( GOLF ) 117001 LH3
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '7. Piutang TASPEN'
7. Piutang TASPEN 117001 TSP
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '2. Piutang UNIVERSITAS ISLAM RIAU'
2. Piutang UNIVERSITAS ISLAM RIAU 117001 U01
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '28. Pengurusan BPJS Kes'
28. Pengurusan BPJS Kes 117001 UM1
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '13. Piutang kitabisa.com'
13. Piutang kitabisa.com 117001 UM2
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = 'PIUTANG PT HINDOLI PANUGUAN'
PIUTANG PT HINDOLI PANUGUAN 1170018 A49
Edit Edit Copy Copy Delete Delete
DELETE FROM akun_piutang WHERE `akun_piutang`.`nama_bayar` = '19. Piutang RWII Ranap'
19. Piutang RWII Ranap 117002 A25
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