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 `referensi_mobilejkn_bpjs_batal`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts no_rkm_medis no_rawat_batal nomorreferensi tanggalbatal keterangan statuskirim nobooking
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20231104000001'
004722 2023/11/04/000032 0071B0311123P000327 2023-11-04 21:41:47 Dibatalkan Oleh Admin Belum 20231104000001
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20231107000001'
004698 2023/11/07/000001 0071B0301123P000036 2023-11-07 21:18:11 Dibatalkan Oleh Admin Belum 20231107000001
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20231107000002'
004723 2023/11/07/000002 040803011123Y000149 2023-11-07 07:25:58 re-schedule Belum 20231107000002
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20231128000001'
006160 2023/11/28/000001 040307011023P000085 2023-11-22 21:47:03 karena dapat antrian nya min Belum 20231128000001
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20231128000002'
006160 2023/11/28/000001 040307011023P000085 2023-11-22 23:01:37 antrian nya min Belum 20231128000002
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20231219000001'
006765 2023/12/19/000001 0408B0281223P000615 2023-12-14 17:09:38 salah tgl Belum 20231219000001
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240608000001'
010071 2024/06/08/000005 0071B0300624P000324 2024-06-07 20:35:51 tidak ada alasan. maaf Belum 20240608000001
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240619000001'
010250 2024/06/19/000016 0071B0310624P001391 2024-06-19 20:02:52 Dibatalkan Oleh Admin Belum 20240619000001
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240625000002'
008529 2024/06/25/000002 040802010624P000867 2024-06-25 10:40:04 Belum 20240625000002
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240628000001'
010370 2024/06/28/000001 006408050624P000973 2024-06-27 08:34:32 salah tanggal Belum 20240628000001
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240628000002'
010370 2024/06/28/000001 006408050624P000973 2024-06-28 12:45:09 Dibatalkan Oleh Admin Belum 20240628000002
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240701000006'
007576 2024/07/01/000025 0071B1040624P001656 2024-07-01 20:08:19 Dibatalkan Oleh Admin Belum 20240701000006
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240705000001'
010364 2024/07/05/000001 0071R0030624K000387 2024-07-05 15:30:48 Dibatalkan Oleh Admin Belum 20240705000001
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240706000001'
010526 2024/07/06/000001 040806010724Y000723 2024-07-05 12:13:26 salah tanggal Belum 20240706000001
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240708000001'
002468 2024/07/08/000001 0071R0030724K000020 2024-07-08 08:55:50 dokter tidak ada Belum 20240708000001
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240712000004'
010439 2024/07/12/000004 0071R0030724K000086 2024-07-12 13:27:38 udah mendingan kesehatannya Belum 20240712000004
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240713000002'
004369 2024/07/13/000002 0071R0030724K000100 2024-07-13 08:28:17 sedang dirawat Belum 20240713000002
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240713000006'
010497 2024/07/13/000008 0071R0030724K000097 2024-07-13 11:19:10 Dibatalkan Oleh Admin Sudah 20240713000006
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240715000003'
010439 2024/07/15/000009 0071R0030724K000086 2024-07-15 14:53:03 Dibatalkan Oleh Admin Belum 20240715000003
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240716000010'
010425 2024/07/16/000025 0071R0030724K000202 2024-07-16 17:16:24 Dibatalkan Oleh Admin Belum 20240716000010
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240717000001'
006385 2024/07/17/000001 0071R0030724K000145 2024-07-15 11:23:40 ada acara Belum 20240717000001
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240717000003'
010537 2024/07/17/000003 0071R0030724K000161 2024-07-17 17:18:05 Dibatalkan Oleh Admin Belum 20240717000003
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240717000004'
010070 2024/07/17/000004 0071R0030724K000149 2024-07-15 11:19:31 ganti hari selasa Belum 20240717000004
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240724000002'
010450 2024/07/24/000002 0071R0030724K000271 2024-07-24 16:55:44 ada hal lain Belum 20240724000002
Edit Edit Copy Copy Delete Delete
DELETE FROM referensi_mobilejkn_bpjs_batal WHERE `referensi_mobilejkn_bpjs_batal`.`nobooking` = '20240724000004'
010809 2024/07/24/000004 0071B1080724P000113 2024-07-24 12:16:00 karna sudah masuk di rawat inap Belum 20240724000004
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