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 `pasien` ORDER BY `kabupatenpj` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts no_rkm_medis nm_pasien no_ktp jk tmp_lahir tgl_lahir nm_ibu alamat gol_darah pekerjaan stts_nikah agama tgl_daftar no_tlp umur pnd keluarga namakeluarga kd_pj no_peserta kd_kel kd_kec kd_kab pekerjaanpj alamatpj kelurahanpj kecamatanpj kabupatenpj Descending Ascending 1 perusahaan_pasien suku_bangsa bahasa_pasien cacat_fisik email nip kd_prop propinsipj
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '001758'
001758 YUNI MUHAROMAH 6402035906940001 P LOA JANAN 1994-06-19 TASRINI JL KAMPUNG JAWA - IRT MENIKAH ISLAM 2023-05-01 081515582742 29 Th 1 Bl 20 Hr D3 SUAMI MUAFA 001 - 5191 111111548 12121479 WIRASWATA JL KAMPUNG JAWA LOA DURI ILIR LOA JANAN KUTAI KARTANEGARA - 2 5 1 - - 29 KALIMANTAN TIMUR
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '001600'
001600 THEODORA RIRIK BUDI 3401126903760002 P YOGYAKARTA 1976-03-29 - PANGUKAN - PNS MENIKAH KATOLIK 2023-03-16 - 47 Th 4 Bl 11 Hr - SAUDARA - 001 - 119 67 2501 - PANGUKAN TRIDADI SLEMAN KOTA YOGYAKARTA - 1 5 1 - 24 JAWA TENGAH
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000050'
000050 TAUFIK 6473020404840002 L MANADO 1984-04-04 - SELUMIT PANTAI - PELAUT BELUM MENIKAH ISLAM 2021-12-02 081374433130 39 Th 4 Bl 4 Hr - SAUDARA AGUS RIFAI - - 87 73 3101 PELAUT SELUMIT PANTAI SELUMIT PANTAI TARAKAN TENGAH KOTA TARAKAN - 1 5 1 - - 31 KALIMANTAN UTARA
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '002171'
002171 CHEN HONGBO EJ8355676 L SICHUAN 1992-10-25 - PERUM. GRIYA HANG TUAH PERMAI BLOK L NO. 33 - WNA MENIKAH ISLAM 2023-07-14 081270099939 30 Th 9 Bl 14 Hr - SAUDARA HARTONO 001 - 5727 111111919 1502 BURUH HARIAN PERUM. GRIYA HANG TUAH PERMAI BLOK L NO. 33 PINANG KENCANA TANJUNG PINANG TIMUR KOTA TANJUNG PINANG - 1 5 1 - - 15 KEPULAUAN RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '013167'
013167 CANDRA AGUSTIAN 1472030608860001 L BAGAN BESAR 1986-08-06 - JL. PRAMUKA LR TANAMA - PEGAWAI BUMN MENIKAH ISLAM 2024-11-28 - 38 Th 3 Bl 22 Hr SMA DIRI SENDIRI CANDRA AGUSTIAN 001 0001370382197 24544 111130683 1502 PEGAWAI BUMN JL. PRAMUKA LR TANAMA TANJUNG AYUN SAKTI BUKIT BESTARI KOTA TANJUNG PINANG - 1 5 1 - - 15 KEPULAUAN RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '014576'
014576 MUHAMMAT JUMADI FATTAHILAH RAMSID PUTRA 2105042007030001 L TANJUNG PINANG 2003-07-20 RAHMAH KAMPUNG BANJAR AIR RAJA - KARYAWAN SWASTA BELUM MENIKAH ISLAM 2025-03-06 085264991971 21 Th 7 Bl 14 Hr SMA LAIN-LAIN RAHMAH SUCI 001 0001684357536 27319 111120963 1502 IRT KAMPUNG BANJAR AIR RAJA AIR RAJA TANJUNGPINANG TIMUR KOTA TANJUNG PINANG - 3 5 1 - - 15 KEPULAUAN RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '007892'
007892 SURYA DARMA KESUMA 1274032704960001 L TANJUNG BALAI 1996-04-27 - JL. BENTENG LK III - WIRASWASTA MENIKAH ISLAM 2024-01-24 082272610879 27 Th 8 Bl 28 Hr - DIRI SENDIRI SURYA DARMA KESUMA BPJ 0000263164803 15130 111121286 1207 WIRASWASTA JL. BENTENG LK III PASAR BARU SEI TUALANG RASO KOTA TANJUNG BALAI - 3 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '013450'
013450 BY.YONNA MONICA - P DUMAI 2024-12-13 YONNA MONICA JL. DUKU LK. II - - BELUM MENIKAH ISLAM 2024-12-13 085362782309 0 Th 0 Bl 0 Hr - DIRI SENDIRI HENDRA KURNIA BPJ - 25121 111131258 1207 WIRASWASTA JL. DUKU LK. II TANJUNG BALAI KOTA II TANJUNG BALAI SELATAN KOTA TANJUNG BALAI - 3 5 1 - - 111223 SUMATERA UTARA
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '001155'
001155 TN. ADAM PRABOWO 3674062503730003 L JAKARTA 1973-03-25 - VILA PERSADA BLOK D 11 NO 1 - PEGAWAI BUMN MENIKAH ISLAM 2022-11-16 08111727386 50 Th 3 Bl 6 Hr - IBU NY. TUTI 002 - 71 46 2304 IRT VILA PERSADA BLOK D 11 NO 1 PAMULANG TIMUR PAMULANG KOTA TANGERANG SELATAN - 2 5 1 - - 23 BANTEN
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '002064'
002064 JAVI AKBAR PRABOWO 3674061508030006 L JAKARTA 2003-08-15 TUTI VILLA INTI PERSADA D-11/1 RT 004/ RW 019 - PELAJAR BELUM MENIKAH ISLAM 2023-06-30 081371237571 19 Th 11 Bl 24 Hr SMA AYAH ADAM PRABOWO 002 - 71 46 2304 KARYAWAN BUMN VILLA INTI PERSADA D-11/1 RT 004/ RW 019 PAMULANG TIMUR PAMULANG KOTA TANGERANG SELATAN - 2 5 1 - - 23 BANTEN
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '015132'
015132 TIAMIN PANGARIBUAN 1572014111550001 P LARAS 1955-02-18 - KOTO PANDAN - IRT JANDA KRISTEN 2025-04-22 085266001772 70 Th 2 Bl 4 Hr SMA ANAK MAMPE 001 0001685888313 28408 111134551 1602 WIRAUSAHA KOTO PANDAN PELAYANG RAYA SUNGAI BUNGKAL KOTA SUNGAI PENUH - 5 5 1 - - 16 JAMBI
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '017342'
017342 ABIYAN ZAYYAN MALIK 1302111403250001 L SOLOK 2025-03-14 SUCI AFNESYA PUTRI JL MERANTI LAUT ,PERUMH MUTIARA RECIDENCE TAHAP V - - BELUM MENIKAH ISLAM 2025-10-11 081267247646 0 Th 7 Bl 2 Hr - IBU SUCI AFNESYA PUTRI 011 0003752069084 82 25 12122541 BIDAN BALAI SENIN JORONG KOTO PANJANG TANJUNG HARAPAN KOTA SOLOK - 8 1 1 - - 14 SUMATERA BARAT
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000815'
000815 MONA TASISELA 6107026101930001 P SINGKAWANG 1993-01-21 - JL. A. YANI GG.PERSATUAN - IRT MENIKAH KATOLIK 2022-09-07 085951381988 30 Th 6 Bl 22 Hr - SUAMI REJEKI PUTRA GINTING 001 0 76 66 2702 - JL. A. YANI GG.PERSATUAN PASIRAN SINGKAWANG BARAT KOTA SINGKAWANG - 1 5 1 27 KALIMANTAN BARAT
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '002584'
002584 MARTA ERINDA SARAGIH 2171095109879008 P SIMALUNGUN 1987-09-11 - JL WONOMULYO MUKTI TIMUR 1 - WIRASWASTA MENIKAH KRISTEN 2023-08-11 081263295102 35 Th 11 Bl 0 Hr - DIRI SENDIRI LETNAN SIMANJUNTAK BPJ 0003259934739 8060 111114235 2405 WIRASWASTA JL WONOMULYO MUKTI TIMUR 1 TLOGOMULYO PEDURUNGAN KOTA SEMARANG - 5 5 1 - - 24 JAWA TENGAH
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '013741'
013741 ZAHRA AULIYA MAHARANI SUGANDA 3374105609990008 P SEMARANG 1999-09-16 WAHYUNI PERUMAHAN BUKIT QUARY BLOK MAWAR NO.07 - PEGAWAI SWASTA BELUM MENIKAH ISLAM 2025-01-06 085326666699 25 Th 6 Bl 27 Hr D3 SUAMI FITRA ADAMI 001 0001531321672 69 44 12122541 KARYAWAN SWASTA PERUM KAMPOENG SEMAWIS  RT 09 ROWOSARI TEMBALANG KOTA SEMARANG - 2 5 1 - - 14 JAWA TENGAH
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '006485'
006485 MUSTAKIM 16020412018000004 L JAYA BHAKTI 1960-03-12 - JL. NGAMPEL - - MENIKAH ISLAM 2023-12-05 085322691465 63 Th 8 Bl 23 Hr - DIRI SENDIRI MUSTAKIM 001 - 13362 111119522 2404 - JL. NGAMPEL BLOTONGAN SIDOREJO KOTA SALATIGA - 1 5 1 - - 24 JAWA TENGAH
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000081'
000081 HANGGRAINI SARI 1472025804900021 P DUMAI 1990-04-18 - JL. PEPAYA GG DAMAI 004/003 - PERAWAT MENIKAH ISLAM 2021-12-18 085265739522 33 Th 3 Bl 21 Hr S1 SUAMI RINO - - 43 68 1401 KARAYAWAN JL. PEPAYA GG DAMAI 004/003 JADIREJO SUKAJADI KOTA PEKANBARU - 3 5 1 - 1 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000129'
000129 ARFAN RITONGA - L PEKANBARU 2008-10-01 - JL. YUNGTIAR PRM MUTIARA TENAYAN RAYA B/277 RT/RW ... - - BELUM MENIKAH ISLAM 2022-01-01 082389881423 14 Th 6 Bl 6 Hr - AYAH RIDWAN RITONGA - - 64 33 1401 - JL. YUNGTIAR PRM MUTIARA TENAYAN RAYA B/277 RT/RW ... MENTANGOR KULIM KOTA PEKANBARU - 5 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000174'
000174 ALESHA HIDAYAH RAHMAN - P PEKANBARU 2018-07-18 MUHAJJIRAH JL. GARUDA SAKTI GG DAHLIA - - BELUM MENIKAH ISLAM 2022-01-30 08127575155 5 Th 0 Bl 21 Hr - AYAH HASMAN - - 91 70 1401 PNS JL. GARUDA SAKTI GG DAHLIA SIMPANG BARU TAMPAN KOTA PEKANBARU - 1 5 5 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000251'
000251 HENDRA PANGIHUTAN PARDEDE 1471072707820101 L PEKANBARU 1982-07-27 - JL. UTAMA SARI NO 13 - WIRASWASTA MENIKAH ISLAM 2022-02-27 081365543599 41 Th 0 Bl 12 Hr - SAUDARA WAHYU - - 102 16 1401 WIRASWASTA JL. UTAMA SARI NO 13 TANGKERANG SELATAN BUKIT RAYA KOTA PEKANBARU - 5 1 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000269'
000269 IRWANSYAH PUTRA 1401062208870002 L PASIR PUTIH 1985-08-22 ANIMAR JL. BANANA GG. BANANA 2 - PEGAWAI SWASTA MENIKAH ISLAM 2022-03-04 081378041031 37 Th 11 Bl 17 Hr - SAUDARA - 003 - 103 37 1401 - JL. BANANA GG. BANANA 2 TANGKERANG TENGAH MARPOYAN DAMAI KOTA PEKANBARU - 3 5 5 - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000294'
000294 HARUN ATHARIZ AHMAD - L UJUNG BATU 2017-05-15 LAILA KUSMIATI JL. HANGTUAH NO 261 - - BELUM MENIKAH ISLAM 2022-03-15 085356445813 6 Th 2 Bl 24 Hr - AYAH RIO PRIANGGA UTAMA ACHMADI - - 83 75 1401 KARYAWAN SWASTA JL. HANGTUAH NO 261 REJOSARI TENAYAN RAYA KOTA PEKANBARU - 2 5 1 - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000295'
000295 UFAIRA ARUNIKA AHMAD - P PEKANBARU 2021-05-27 LAILA KUSMIATI JL. HANGTUAH NO 261 - - BELUM MENIKAH ISLAM 2022-03-15 085356445813 2 Th 2 Bl 12 Hr - AYAH RIO PRIANGGA UTAMA ACHMADI - - 83 75 1401 KARYAWAN SWASTA JL. HANGTUAH NO 261 REJOSARI TENAYAN RAYA KOTA PEKANBARU - 2 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000356'
000356 JESSLYN WIJAYA 1471046008960021 P MEDAN 1996-08-20 - JL. ROKAN - IRT MENIKAH BUDHA 2022-04-05 081372147221 27 Th 8 Bl 9 Hr S1 SUAMI WILSON 001 - 111 35 1401 WIRASWASTA JL. ROKAN TANJUNG RHU LIMA PULUH KOTA PEKANBARU - 4 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000568'
000568 M. ICHSAN MULYADI 1472010312950021 L DUMAI 1995-12-03 DONNA SASMITA JL. MARLAN JAYA - HONORER BELUM MENIKAH ISLAM 2022-06-20 082386270745 27 Th 8 Bl 6 Hr S1 IBU DONNA SASMITA 001 - 24 25 1402 IRT JL. GUNUNG RAYA REJOSARI TENAYAN RAYA KOTA PEKANBARU - 8 5 5 - - 14 RIAU
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