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 `alamatpj` 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 Descending Ascending 1 kelurahanpj kecamatanpj kabupatenpj 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` = '009443'
009443 HERLINA 1472015010650041 P TANJUNG PINANG 1965-10-10 ROSNA YAKTA PENA - IRT MENIKAH ISLAM 2024-04-30 082170790279 58 Th 6 Bl 20 Hr SMA ANAK NURUL  DELANI OSCAR 012 0001733660368 29 25 12122541 DOKTER UMUM YAKTA PENA BUKIT TIMAH DUMAI SELATAN KOTA D U M A I - 8 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '012330'
012330 WIRA 3209282807890003 L CIREBON 1989-07-29 NATIMI WISMA CEMARA - KARYAWAN SWASTA MENIKAH ISLAM 2024-10-14 087821461043 35 Th 2 Bl 15 Hr SMA SAUDARA NABILA 001 - 45 26 12122541 KARYAWAN SWASTA WISMA CEMARA JAYA MUKTI DUMAI TIMUR KOTA D U M A I - 2 1 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '013763'
013763 MUHAMMAD IQBAL 1371092504990014 L PADANG 1999-04-25 MUHAMMAD IQBAL WISMA - PELAJAR MENIKAH ISLAM 2025-01-07 - 25 Th 8 Bl 13 Hr - DIRI SENDIRI MUHAMMAD IQBAL 001 0000015933363 25711 111115662 1302 PELAJAR WISMA KALUMBUK KURANJI KOTA PADANG - 8 5 1 - - 115114 SUMATERA BARAT
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '011816'
011816 HERMAN 1472021704810001 L T.BALAI 1981-04-17 PEK LI WANZEN GG MULTAZAH - WIRASWASTA MENIKAH KONG HU CHU 2024-09-19 082384015325 43 Th 5 Bl 7 Hr SD ISTRI YANTI 001 - 108 26 12122541 IRT WANZEN GG MULTAZAH TANJUNG PALAS DUMAI TIMUR KOTA D U M A I - 4 5 1 - - 14 RIAU
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` = '006005'
006005 DARYONO HARSYAH 1671070807790006 L PALEMBANG 1979-07-08 CIK NING VILLA GARDENA 4 BLOK G. NO 10 - KARYAWAN BUMN MENIKAH ISLAM 2023-11-16 081367779709 44 Th 4 Bl 8 Hr - DIRI SENDIRI DARYONO HARSYAH 002 1101424470707 12526 111118690 1703 KARYAWAN BUMN VILLA GARDENA 4 BLOK G. NO 10 ALANG-ALANG LEBAR ALANG-ALANG LEBAR KOTA PALEMBANG - 3 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000171'
000171 SIDDIQ ZAHIRA ADILA 1472011203020001 L DUMAI 2002-03-12 LILA KUMALASARI VILLA BUKIT TIMAH PERMAI B19 - MAHASISWA BELUM MENIKAH ISLAM 2022-02-03 08127676797 21 Th 4 Bl 27 Hr - IBU LALI KUMALASARI - - 29 25 1402 KARYAWAN SWASTA VILLA BUKIT TIMAH PERMAI B19 BUKIT TIMAH DUMAI SELATAN KOTA DUMAI - 8 5 5 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '007324'
007324 MARYATI 1472015304840001 P CILACAP 1984-04-13 NAFIAH VILLA BUKIT TIMAH PERMAI - IRT MENIKAH ISLAM 2024-01-02 085246531784 39 Th 11 Bl 13 Hr SMA DIRI SENDIRI MARYATI BPJ 0003298954926 29 25 12122541 IRT VILLA BUKIT TIMAH PERMAI BUKIT TIMAH DUMAI SELATAN KOTA D U M A I - 2 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '010558'
010558 AGUST KARUNDENG HUMBAS 1472012208680002 L SAWANGAN 1968-08-22 - VILLA BUKIT TIMAH - PEGAWAI SWASTA MENIKAH ISLAM 2024-07-09 - 55 Th 10 Bl 17 Hr SMA DIRI SENDIRI AGUST KARUNDENG HUMBAS BPJ 0001134203051 29 25 12122541 KARYAWAN SWASTA VILLA BUKIT TIMAH BUKIT TIMAH DUMAI SELATAN KOTA D U M A I - 3 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '008098'
008098 NETTY JASMAN 1472015403720021 P INDARUNG 1972-03-14 MUHARNI VILLA B.TIMAH PERMNAI C/3 - PNS DAERAH MENIKAH ISLAM 2024-02-06 081268779071 51 Th 10 Bl 23 Hr S1 DIRI SENDIRI NETTY JASMAN BPJ 0000022274954 29 25 12122541 GURU VILLA B.TIMAH PERMNAI C/3 BUKIT TIMAH DUMAI SELATAN KOTA D U M A I - 8 5 1 - - 14 RIAU
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` = '008029'
008029 WIWIK DWI NURHISTRI 1472017110650001 P KUOK 1965-10-31 DASRI VILA BUKIT TIMAH PERMAI BLOK E NO.01 JL CAHAYA - IRT MENIKAH ISLAM 2024-02-01 082284592096 58 Th 4 Bl 2 Hr S1 SUAMI TOMMY TANAKA BPJ 0001341866261 29 25 12122541 WIRASWASTA VILA BUKIT TIMAH PERMAI BLOK E NO.01 JL CAHAYA BUKIT TIMAH DUMAI SELATAN KOTA D U M A I - 3 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000533'
000533 SAHROMI 1407034312590002 P RANTAU BAIS 1959-12-03 NY. UJUNG TANJUNG, RT.013/ RW.005 - IRT MENIKAH ISLAM 2022-06-10 081276234990 63 Th 8 Bl 6 Hr - ANAK MELATI 001 - 121 71 1410 DOKTER UJUNG TANJUNG, RT.013/ RW.005 UJUNG TANJUNG TANAH PUTIH KAB. ROKAN HILIR - 3 5 5 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '001577'
001577 LIKA NUR UTAMI - P TANAH PUTIH TL 2007-11-08 MULIANI UJUNG TANJUNG - PELAJAR BELUM MENIKAH ISLAM 2023-03-09 081365738222 15 Th 11 Bl 2 Hr SMA AYAH KANANG PRAYOGI 001 - 63 71 1410 WIRASWASTA UJUNG TANJUNG MELAYU BESAR KOTA ZZZZ TANAH PUTIH KAB. ROKAN HILIR - 2 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '009862'
009862 SYAHRUDDIN 1407030603600001 L BENGKALIS 1960-03-06 JALIAH DITIK UJUNG TANJUNG - PENERIMA PENSIUN PNS MENIKAH ISLAM 2024-05-28 085263334248 64 Th 2 Bl 22 Hr S1 ANAK ARI SYAPUTRA 001 - 121 71 12125208 EDITOR UJUNG TANJUNG UJUNG TANJUNG TANAH PUTIH KABUPATEN ROKAN HILIR - 3 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '012581'
012581 BUDIMAN 1407031210840010 L SEKELADI 1982-08-10 ZAMZIMA UJUNG TANJUNG - KARYAWAN SWASTA MENIKAH ISLAM 2024-10-27 082172022829 42 Th 2 Bl 17 Hr SMA ISTRI YULISNI BPJ 0000291863788 121 71 12125208 IRT UJUNG TANJUNG UJUNG TANJUNG TANAH PUTIH KABUPATEN ROKAN HILIR - 3 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '004920'
004920 YAYAN 1503090101930003 L PERDAMAIAN 1993-01-01 NURHAYATI TUNAS MULIA UJUNG - WIRASWASTA BELUM MENIKAH ISLAM 2023-11-10 085324012709 30 Th 10 Bl 9 Hr - DIRI SENDIRI YAYAN 001 - 82 25 12122541 WIRASWASTA TUNAS MULIA UJUNG RATU SIMA DUMAI SELATAN KOTA D U M A I - 11 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '014608'
014608 SALMAN 1472021706800021 L GASAN GADANG 1980-06-17 ELIZAM TUNAS MUDA BTN RAWASARI A-05 - PNS DAERAH MENIKAH ISLAM 2025-03-08 081365201034 44 Th 8 Bl 19 Hr S1 ISTRI ELENA NOVIANDARI BPJ 0000022299298 24 25 12122541 PNS TUNAS MUDA BTN RAWASARI D-07 BUKIT DATUK DUMAI SELATAN KOTA D U M A I - 8 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000008'
000008 DEVAN SIHOTANG - L PARLILITAN 1995-04-19 - TUNAS MUDA - WIRASWASTA BELUM MENIKAH KRISTEN 2021-10-08 081268911875 28 Th 3 Bl 20 Hr - SAUDARA RINTO 001 - 24 25 1402 WIRASWASTA TUNAS MUDA BUKIT DATUK DUMAI SELATAN KOTA DUMAI - 5 5 5 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '011217'
011217 SALSABILA GHANIYYAH NEFENI 1472014808060025 P DUMAI 2006-08-08 GUSTI ENI TUNAS KARYA - PELAJAR MENIKAH ISLAM 2024-08-15 082288260288 18 Th 0 Bl 7 Hr SMA IBU GUSTI ENI 001 0001164288262 24 25 12122541 IRT TUNAS KARYA BUKIT DATUK DUMAI SELATAN KOTA D U M A I - 8 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '011001'
011001 SURATI 1608084504860004 P OKU TIMUR 1986-05-15 - TRIMOHARJO - IRT MENIKAH ISLAM 2024-08-03 085278717808 38 Th 2 Bl 19 Hr - LAIN-LAIN DARMINTO 001 0003380574554 20178 111126322 12136290 SWASTA TRIMOHARJO TRIMO HARJO SEMENDAWAI SUKU III KABUPATEN OGAN KOMERING ULU TIMUR - 2 5 1 - - 117515 SUMATERA SELATAN
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '015903'
015903 REZA AZHARAH 1212076504020002 L PEKANBARU 2002-04-25 NURLAILY ALISYAR TOWN SITE 8 47 - PEGAWAI SWASTA BELUM MENIKAH ISLAM 2025-06-18 +62 822-8748-0500 23 Th 1 Bl 29 Hr - AYAH SUDIRMAN DARWIS 001 0002071655098 29883 111136028 12145981 KARYAWAN SWASTA TOWN SITE 8 47 BANJAR GANJANG PARMAKSIAN KABUPATEN TOBA SAMOSIR - 1 5 1 - - 111223 SUMATERA UTARA
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '016541'
016541 SUDARTI 1110066007800001 P BLOK 1985-04-21 TASUMI TITIAN RESAK - IRT MENIKAH ISLAM 2025-08-13 085336499313 40 Th 3 Bl 23 Hr SD SUAMI AMINUDIN 001 0002754848237 31066 111137208 12140655 SUPIR TITIAN RESAK TITIAN RESAK SEBERIDA KABUPATEN INDRAGIRI HULU - 2 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '016848'
016848 EKA MAWARDAHNI 1103076804000001 P TANJUNG BALAI 2002-04-28 MAWARDHAH TEMIANG - IRT MENIKAH ISLAM 2025-09-09 085265818135 23 Th 4 Bl 12 Hr SD SUAMI TAHAJUL ASRI BPJ 0000213998591 29514 3 12124190 PETANI TEMIANG TEMIANG BANDAR LAKSAMANA KABUPATEN BENGKALIS - 3 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '010898'
010898 ICAK 1403024907035016 P BANTAN TENGAH 2003-07-09 CABO TELUK RHU - IRT MENIKAH BUDHA 2024-07-28 085355565557 21 Th 0 Bl 19 Hr SD SUAMI EKO PRAMONO 001 0000292444839 5778 58 12124190 WIRASWASTA TELUK RHU TELUK RHU RUPAT UTARA KABUPATEN BENGKALIS - 4 5 1 - - 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