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 `jurnal_detail` ORDER BY `jurnal_id` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id jurnal_id Descending Ascending 1 coa_id debit credit keterangan_detail created_at
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3491
3491 1673 26 1006919.00 0.00 Beban PENGELUARAN_LAIN_LAIN 2026-08-31 17:02:42
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3492
3492 1673 1 0.00 1006919.00 Pembayaran Kas 2026-08-31 17:02:42
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3489
3489 1672 12 170000.00 0.00 Pelunasan Utang Vendor 2026-08-31 16:41:25
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3490
3490 1672 1 0.00 170000.00 Pembayaran Kas dari Akun: DANA 2026-08-31 16:41:25
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3487
3487 1671 12 4205000.00 0.00 Pelunasan Utang Vendor 2026-08-31 16:40:37
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3488
3488 1671 1 0.00 4205000.00 Pembayaran Kas dari Akun: DANA 2026-08-31 16:40:37
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3485
3485 1670 28 10000.00 0.00 Beban BIAYA_MAKAN 2026-08-31 16:38:31
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3486
3486 1670 1 0.00 10000.00 Pembayaran Kas 2026-08-31 16:38:31
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3483
3483 1669 1 1774998.00 0.00 Mutasi Kas - Penerimaan 2026-08-31 16:36:46
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3484
3484 1669 1 0.00 1774998.00 Mutasi Kas - Pengeluaran 2026-08-31 16:36:46
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3481
3481 1668 26 40000.00 0.00 Beban OPERASIONAL_AYYUB 2026-08-31 16:34:50
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3482
3482 1668 1 0.00 40000.00 Pembayaran Kas 2026-08-31 16:34:50
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3479
3479 1667 26 2000000.00 0.00 Beban PENGELUARAN_LAIN_LAIN 2026-08-31 16:34:22
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3480
3480 1667 1 0.00 2000000.00 Pembayaran Kas 2026-08-31 16:34:22
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3477
3477 1666 26 51500.00 0.00 Beban OPERASIONAL_TOKO 2026-08-31 16:33:37
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3478
3478 1666 1 0.00 51500.00 Pembayaran Kas 2026-08-31 16:33:37
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3475
3475 1665 26 205350.00 0.00 Beban OPERASIONAL_TOKO 2026-08-31 16:33:20
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3476
3476 1665 1 0.00 205350.00 Pembayaran Kas 2026-08-31 16:33:20
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3473
3473 1664 26 109490.00 0.00 Beban OPERASIONAL_TOKO 2026-08-31 16:33:00
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3474
3474 1664 1 0.00 109490.00 Pembayaran Kas 2026-08-31 16:33:00
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3471
3471 1663 26 23900.00 0.00 Beban OPERASIONAL_TOKO 2026-08-31 16:32:31
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3472
3472 1663 1 0.00 23900.00 Pembayaran Kas 2026-08-31 16:32:31
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3469
3469 1662 26 51500.00 0.00 Beban OPERASIONAL_TOKO 2026-08-31 16:32:04
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3470
3470 1662 1 0.00 51500.00 Pembayaran Kas 2026-08-31 16:32:04
Edit Edit Copy Copy Delete Delete
DELETE FROM jurnal_detail WHERE `jurnal_detail`.`id` = 3467
3467 1661 26 13000.00 0.00 Beban OPERASIONAL_TOKO 2026-08-31 16:31:47
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