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`
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 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` = '000001'
000001 POB 1422124552 L DUMAI 2021-08-14 - JL. MARLAN JAYA - - MENIKAH ISLAM 2021-09-22 085271374874 4 Th 1 Bl 9 Hr S3 SAUDARA - 001 - 24 25 1402 - JL. MARLAN JAYA BUKIT DATUK DUMAI SELATAN KOTA DUMAI - 1 1 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000002'
000002 RIZKI MEILINDA 3216194305800013 P DUMAI 1980-05-03 - TAMAN SENTOSA BLOK J-19 NO 6 - KARYAWAN SWASTA MENIKAH ISLAM 2023-03-02 081212071208 43 Th 3 Bl 5 Hr S1 SAUDARA - 001 - 1 1 9999 - TAMAN SENTOSA BLOK J-19 NO 6 - - - - 1 5 1 - - 99 -
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000003'
000003 ADITYA NANDA 1472011112920061 L DUMAI 1992-12-11 ROSNAWATI JL. SOEKARNO-HATTA O PEGAWAI SWASTA BELUM MENIKAH ISLAM 2021-10-16 085264312020 32 Th 10 Bl 27 Hr SMA IBU ROSNAWATI BPJ 0001268410544 23 26 1402 IRT JL. P. DIPONEGORO GG. SAWO NO. 12 RIMBA SEKAMPUNG DUMAI KOTA KOTA DUMAI I0007 3 5 1 - 1121210004 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000004'
000004 DION INDRAWAN 1403091712906401 L DURI 1990-12-17 - JL. SIDOMULYO NO.16 - KARYAWAN SWASTA BELUM MENIKAH ISLAM 2021-09-07 082219760469 32 Th 7 Bl 22 Hr D3 SAUDARA MUHAMMAD IKBAL 001 0 1 1 9999 KARYAWAN SWASTA JL. SIDOMULYO NO.16 - - - - 3 5 5 - - 99 -
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000005'
000005 T SALMAH 04.5201.711253.0025 P TL. BELITUNG 1953-12-31 - JL. SUKAJADI GG. SAWO RT 005 RW 001 - GURU SD MENIKAH ISLAM 2021-09-25 085278752624 69 Th 7 Bl 8 Hr SMA SUAMI SARIAN S 001 - 94 24 1402 IRT JL. SUKAJADI GG. SAWO RT 005 RW 001 SUKAJADI DUMAI KOTA KOTA DUMAI - 3 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000006'
000006 ARDYA PURWANTI 1471096706950067 P PEKANBARU 1995-06-27 SUSILAWATI JL. SAIL NO 52 RT 004/023 - PNS MENIKAH ISLAM 2021-09-25 085274553901 28 Th 1 Bl 12 Hr - AYAH SUAMI 001 11 1 1 9999 PNS JL. SAIL NO 52 RT 004/023 - - - I0001 2 5 5 - - 99 -
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000007'
000007 AUFA MARZA GUNAWAN - P BAGAN SIAPI-API 2006-05-19 NORMALINA JL.SILIWANGI GG. MUKMIN - SISWA BELUM MENIKAH ISLAM 2021-10-03 082392026470 17 Th 2 Bl 20 Hr SMA IBU NORMALINA 001 - 112 26 1402 IRT JL.SILIWANGI GG. MUKMIN TELUK BINJAI DUMAI TIMUR KOTA DUMAI - 3 5 5 - 0123 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` = '000009'
000009 IRMA IMRAN 1472021508670041 L LUBUK BASUNG 1967-08-15 RUJASMI JL. MERDEKA GG. JAMIK RT 018 KEL. SUKAJADI KEC. DU... - PEDAGANG MENIKAH ISLAM 2021-10-10 081268746665 55 Th 11 Bl 24 Hr - ANAK CAHYA RIFTA YANI 001 - 94 24 1402 - SUKAJADI SUKAJADI DUMAI KOTA KOTA DUMAI - 8 5 5 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000010'
000010 SRI MULYATI 1472014402950002 P DUMAI 1995-02-04 MOZILA JL. SUKOSARI NO 6 RT 011 - HONORER CAPIL MENIKAH ISLAM 2021-10-12 085375577795 28 Th 6 Bl 4 Hr - SUAMI GUSRIANTONI 001 - 24 25 1402 WIRASWASTA JL. SUKOSARI NO 6 RT 011 BUKIT DATUK DUMAI SELATAN KOTA DUMAI - 3 5 5 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000011'
000011 JOSUA 1472026912910002 L PEKANBARU 2019-06-21 FRISKA SRI RAHAYU JL. AIR BERSIH GG. TENGGIRI - - BELUM MENIKAH KRISTEN 2021-10-17 082289843701 4 Th 1 Bl 18 Hr - IBU FRISKA SRI RAHAYU 001 - 112 26 1402 IRT JL. AIR BERSIH GG. TENGGIRI TELUK BINJAI DUMAI TIMUR KOTA DUMAI - 5 5 5 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000012'
000012 MARISA 1472016301980005 P DUMAI 1998-01-23 - JL. PROF.M.YAMIN - IRT MENIKAH BUDHA 2021-10-17 081371197446 25 Th 6 Bl 16 Hr - SUAMI AGUS SUSANTO 001 - 9 23 1402 WIRASWASTA JL. PROF.M.YAMIN BAGAN KELADI DUMAI BARAT KOTA DUMAI - 1 5 1 - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000013'
000013 MUHAMMAD FATAHANGI 31710802119200 L JAMBI 1992-11-02 - JAMBI - PELAUT BELUM MENIKAH ISLAM 2021-10-25 081313361684 30 Th 9 Bl 6 Hr SMA SAUDARA - 001 - 1 1 9999 - - - - - - 1 1 1 - 99 -
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000014'
000014 PUTRI APRYYANI 1472025804950003 P MEDAN 1995-04-18 - JL. A. SAMAD - IRT MENIKAH ISLAM 2021-10-27 082169889695 28 Th 3 Bl 21 Hr - SUAMI MUHAMMAD FIRDAUS 001 - 24 25 1402 - JL. A. SAMAD 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` = '000015'
000015 DEDI CANDRA 1472020109810001 L DUMAI 1981-09-01 NURJANI JL. NASIONAL RT/RW 007/000 - WIRASWASTA MENIKAH ISLAM 2021-10-29 081371999181 41 Th 11 Bl 7 Hr - SAUDARA MULYADI - - 30 26 1402 - JL. JENDRAL SUDIRMAN - - KOTA DUMAI - 1 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000016'
000016 ANDHIKA ANUGRAH AZHAR 1472011407920007 L BANDUNG 1992-07-14 - JL.MAHITAM BLOK E4 - WIRASWASTA BELUM MENIKAH ISLAM 2021-10-31 082285125849 31 Th 0 Bl 25 Hr - SAUDARA - 001 - 113 44 1402 - JL.MAHITAM BLOK E4 TELUK MAKMUR MEDANG KAMPAI KOTA DUMAI - 1 1 1 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000017'
000017 RESMAWATI LUMBANGAOL - P DOLOK SANGGUL 1962-05-27 - JL. DIPONEGORO GANG SALAK 1 RT 020 - WIRASWASTA JANDA KRISTEN 2021-11-03 082274476814 61 Th 2 Bl 12 Hr - SAUDARA - 001 - 84 24 1402 - - - - - - 5 5 5 - - 14 -
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000018'
000018 MONIKA LEONARTI - P DUMAI 1994-07-25 RESMAWATI JL. DIPONEGORO GANG SALAK 1 RT 020 - GURU BELUM MENIKAH KRISTEN 2021-11-03 082274476814 29 Th 0 Bl 14 Hr D3 IBU - 001 - 84 24 1402 - JL. DIPONEGORO GANG SALAK 1 RT 020 RIMBA SEKAMPUNG DUMAI KOTA KOTA DUMAI - 5 5 5 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000019'
000019 DESTYA ANGGRAINI 1472025912970002 P DUMAI 1997-12-19 - JL. SILIWANGI GG. MUKMIN - KARYAWAN SWASTA BELUM MENIKAH ISLAM 2021-11-03 085271566485 27 Th 9 Bl 16 Hr S1 IBU - BPJ 0001189751106 45 26 1402 - JL. SILIWANGI GG. MUKMIN JAYA MUKTI DUMAI TIMUR KOTA DUMAI - 3 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000020'
000020 ESRIDA - P DUMAI 1971-03-27 - JL P. DIPONEGORO GG SEMANGKA - Pedagang MENIKAH ISLAM 2021-11-16 081363666217 52 Th 4 Bl 12 Hr SMA SAUDARA Dahlia - - 84 24 1402 IRT - - - - - 5 5 5 14 -
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000021'
000021 MUHAMMAD ZULVY NURZAL 2171032611970005 L BATAM 1997-11-26 - RM. DEDI DATUK JL.SUDIRMAN - SWASTA MENIKAH ISLAM 2021-11-04 081371999181 25 Th 8 Bl 13 Hr - SAUDARA DEDY CANDRA 001 - 30 26 1402 SWASTA RM. DEDI DATUK JL.SUDIRMAN BULUH KASAP DUMAI TIMUR KOTA DUMAI - 8 5 5 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000022'
000022 IWAN TAMPUBOLON 1472036001950002 L KISARAN 1975-10-10 SALMI JL. BARU BUKIT ABBAS - WIRASWASTA MENIKAH ISLAM 2021-11-12 082268118932 47 Th 9 Bl 29 Hr - ANAK SRI ATUN TAMPUBOLON 001 - 49 15 1402 - JL. BARU BUKIT ABBAS KAMPUNG BARU BUKIT KAPUR KOTA DUMAI - 5 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000023'
000023 M. RAJIB - L DUMAI 1985-01-10 NUR AINI PURNAMA - WIRASWASTA MENIKAH ISLAM 2021-11-13 085263949596 38 Th 6 Bl 29 Hr SMA SAUDARA ANDRI PERWIRA 001 - 80 23 1402 WIRASWASTA CENDRAWASIH - - KOTA DUMAI - 3 5 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000024'
000024 WELLY SYAHYUDAR 1371071801770003 L PADANG 1977-01-18 JURNI JL. RAJA ALI HAJI GG SEKOLAH RT/RW 023/000 - KARYAWAN SWASTA MENIKAH ISLAM 2021-11-14 081364317465 46 Th 6 Bl 21 Hr - ISTRI EVA ARISUSVITA - - 80 23 1402 IBU RUMAH TANGG JL. RAJA ALI HAJI GG SEKOLAH RT/RW 023/000 PURNAMA DUMAI BARAT KOTA DUMAI - 1 1 1 - - 14 RIAU
Edit Edit Copy Copy Delete Delete
DELETE FROM pasien WHERE `pasien`.`no_rkm_medis` = '000025'
000025 ANDI SAPUTRA   1472010407820062 L SUNGAI APIT 1982-07-04 NURBAITI GG.STEEL - BHL MENIKAH ISLAM 2021-11-17 085271104300 41 Th 1 Bl 4 Hr SMP ISTRI ERMA 001 - 80 23 1402 IRT GG.STEEL PURNAMA DUMAI BARAT KOTA DUMAI - 1 1 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