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 `pegawai` ORDER BY `kota` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id nik nama jk jbtn jnj_jabatan kode_kelompok kode_resiko kode_emergency departemen bidang stts_wp stts_kerja npwp pendidikan gapok tmp_lahir tgl_lahir alamat kota Descending Ascending 1 mulai_kerja ms_kerja indexins bpd rekening stts_aktif wajibmasuk pengurang indek mulai_kontrak cuti_diambil dankes photo no_ktp email password level_approval atasan_langsung_id status_aktif remember_token created_at updated_at
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 4
4 D0000001 dr. Azharul Yusri, Sp.OG Pria dokter umum DIRU KTA II II IGD Dokter Umum K/0 T npwp S1 KEDOKTERAN 0 - 2021-03-19 - kota 1997-04-08 <1 - T rekening KELUAR 0 0 0 1998-07-19 3 1000000 pages/pegawai/photo/akhwat.jpg 121212 D0000001@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 339
339 1207240181 dr. RISDINAR ULYA FAUZIAH Pria DOKTER UMUM - - IV III IGD - - - - S1 KEDOKTERAN 0 JEPARA 1995-12-01 JL. MANDIRI GG. MAWAR DUMAI 1900-01-01 <1 - T - KELUAR 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ 3320084112950003 1207240181@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 303
303 1204230139 dr. MIFTAHULIAH ROHIMA SURURI Wanita DOKTER UMUM - - IV III IGD - - - - S1 KEDOKTERAN 0 AIR MOLEK 1998-08-07 JL. BUMI AYU DUMAI 1900-01-01 <1 - T - AKTIF 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ 1402044708980002 1204230139@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 216
216 1203240026 dr. INGGRIT ANGGRAINI, Sp.A Wanita DOKTER SPESIALIS 03 - - - MED - - - - SPESIALIS 0 SOLOK 1983-01-06 JL. MERDEKA GG. BAHAGIA NO. 21 DUMAI 2024-08-14 <1 - T - AKTIF 0 0 0 2024-08-14 0 0 pages/pegawai/photo/ 1472024601830001 1203240026@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 175
175 1204210010 dr. IRDA PUSPASARI Wanita DOKTER UMUM 04 - IV III MED - - - - S1 KEDOKTERAN 0 DUMAI 1994-04-16 JL. ASRI GG. UTAMA NO. 03 DUMAI 2021-08-14 <1 - T - AKTIF 0 0 0 2021-08-14 0 0 pages/pegawai/photo/ 1472015604940001 1204210010@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 162
162 1203210004 dr. SUPRIADI, Sp.A Pria DOKTER SPESIALIS 03 - - - MED - - - - - 0 MEDAN 1976-10-10 JL. JEND. SUDIRMAN NO. 242 DUMAI 2021-10-29 PT - T - AKTIF 0 0 0 2021-10-29 0 0 pages/pegawai/photo/ 1472021010760021 1203210004@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 161
161 1203210009 dr. IRVAN BAHAR, Sp.OG Pria DOKTER SPESIALIS 03 - - - MED - - - - - 0 WATAMPONE 1975-05-16 JL. ANGGUR BARAT NO. 43A DUMAI 2021-09-24 PT - T - AKTIF 0 0 0 2021-09-24 0 0 pages/pegawai/photo/ 7502041605750001 1203210009@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 160
160 1203210018 dr. RENNY ANGGRAINI, Sp.OG Wanita DOKTER SPESIALIS 03 - IV III MED MEDIS - - - - 0 DUMAI 1983-02-22 JL. ANGGUR BARAT NO. 43A DUMAI 2022-02-01 PT - T - AKTIF 5 0 0 2022-02-01 0 0 pages/pegawai/photo/ 1472016202830041 1203210018@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 156
156 1204210009 dr. MUHAMAD APRIS SETIAWAN Pria DOKTER UMUM 04 - IV III MED MEDIS - - - S1 KEDOKTERAN 0 KUNTO DARUSSALAM 1994-04-24 JL. MERANTI II GG. BERINGIN DUMAI 1900-01-01 <1 - T - AKTIF 5 0 0 2021-08-14 0 0 pages/pegawai/photo/ 1406062404940004 1204210009@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 221
221 0010 Dokter Pria - - - - - - - - - - - 0 D 2023-02-09 D D 1900-01-01 <1 - T - KELUAR 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ - 0010@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 375
375 1203250029 dr. IHSAN, Sp.B Pria - - - - - - - - - - - 0 DURI 1989-10-24 JL. GAJAH MADA - 1900-01-01 <1 - T - AKTIF 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ - 1203250029@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 374
374 1311250227 NADILA PRATIWI UTAMI, S.Tr.Kes Wanita - - - - - - - - - - - 0 RONAH BENGKEK 2002-07-17 JL. RAYA BUKIT DATUK GG. HIKMAH NO.06 - 1900-01-01 <1 - T - AKTIF 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ - 1311250227@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 373
373 1311230137 SITI AMALIA ATIKA SARI, S.Tr.Kes Wanita - - - - - - - - - - - 0 LENGGADAI HULU 2003-11-16 JL. RAYA BUKIT DATUK GG. HIKMAH - 1900-01-01 <1 - T - AKTIF 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ - 1311230137@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 372
372 1207240183 Ns. ARIF SUWONDO, S.Kep Pria - - - - - - - - - - - 0 TALAWI 1993-09-29 JL. SWADAYA GG. SETIA NO. 01 - 1900-01-01 <1 - T - AKTIF 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ - 1207240183@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 371
371 1207240184 Ns. ADE ANDRIYADI, S.Kep Pria - - - - - - - - - - - 0 DUMAI 1992-08-24 JL. SIAK - 1900-01-01 <1 - T - AKTIF 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ - 1207240184@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 370
370 1516250224 ALYA ANANTA Wanita - - - - - - - - - - - 0 DUMAI 2004-03-11 JL. GUNUNG MERBABU NO. 66 - 1900-01-01 <1 - T - AKTIF 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ - 1516250224@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 369
369 1208250226 MONICA SARI, A.Md.Keb Wanita - - - - - - - - - - - 0 DUMAI 2002-08-02 JL. JEND. SUDIRMAN NO. 97 - 1900-01-01 <1 - T - AKTIF 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ - 1208250226@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 368
368 1208250225 DEWI RAHNA ANISA, S.Tr.Keb Wanita - - - - - - - - - - - 0 PEKANBARU 2000-07-18 JL. NELAYAN LAUT - 1900-01-01 <1 - T - AKTIF 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ - 1208250225@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 367
367 1207250229 ELFIKRI AL DUMAINI, Amd.Kep Pria - - - - - - - - - - - 0 DUMAI 2003-06-03 JL. SEI ROKAN NO. 90 - 1900-01-01 <1 - T - AKTIF 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ - 1207250229@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 366
366 1207250228 PUTRI NADILA ULFA, Amd.Kep Wanita - - - - - - - - - - - 0 DUMAI 2002-10-19 JL. SEI SIAK NO. 15 A - 1900-01-01 <1 - T - AKTIF 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ - 1207250228@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 365
365 1207250220 SONIA RAHMAWATI, Amd.Kep Wanita - - - - - - - - - - - 0 DUMAI 2003-03-11 JL. JAYA MUKTI - 1900-01-01 <1 - T - AKTIF 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ - 1207250220@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 364
364 1207250213 ELSA DESMANITA, A.Md.Kep Wanita - - - - - - - - - - - 0 SELAT PANJANG 2003-02-03 JL. JAYA MUKTI - 1900-01-01 <1 - T - AKTIF 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ - 1207250213@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 363
363 1207250209 Ns. JURHAM ZANDROTO, S.Kep Pria - - - - - - - - - - - 0 SAITA GARAMBA 2000-06-16 JL. JEND. SUDIRMAN GG. JAMBU - 1900-01-01 <1 - T - AKTIF 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ - 1207250209@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 362
362 1207250201 IWENI OBMA SABMA, A.Md.Kep Wanita - - - - - - - - - - - 0 PADANG 2002-10-20 JL. TEDUH NO. 27 B - 1900-01-01 <1 - T - AKTIF 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ - 1207250201@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
Edit Edit Copy Copy Delete Delete
DELETE FROM pegawai WHERE `pegawai`.`id` = 360
360 1204250230 dr. ANGGY MIRANDA ZANTIA Wanita - - - - - - - - - - - 0 SUNGAI SEBESI 1999-07-10 JL. BUKIT DATUK LAMA NO. 2 KOST HJ EDWINA - 1900-01-01 <1 - T - AKTIF 0 0 0 1900-01-01 0 0 pages/pegawai/photo/ - 1204250230@graha.com $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2... pegawai 176 1 NULL 2025-11-01 18:29:58 2025-11-01 18:29:58
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