Letakkan berkas disini

SQL upload ( 0 ) x -

Pengaturan Terkait dengan Halaman Klik pada bar untuk menggulir ke atas halaman
Tekan Ctrl+Enter untuk menjalankan kueri Press Enter to execute query
ascending
descending
Order:
Men-Debug SQL
Jumlah
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Tampilkan Buka Show trace Hide trace Jumlah : Time taken :
Bookmark
Segarkan
Tambah
Tidak ada penanda
Tambah bookmark
Opsi
Kembalikan nilai bawaan





Tampilkan Buka Kueri ulang Ubah Jelaskan Profil Bookmarks Kueri gagal Basis data : Waktu eksekusi kueri :
Modus jelajah
Atur mode jelajah.
Modus jelajah
Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya. Kembalikan nilai bawaan
Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya. Kembalikan nilai bawaan
Dokumentasi Whether a user should be displayed a "show all (rows)" button. Kembalikan nilai bawaan
Dokumentasi Jumlah baris yang ditampilkan saat browsing hasil set. Jika hasil set berisi lebih dari satu baris, tautan "Previous" and "Next" akan ditampilkan. Kembalikan nilai bawaan
Dokumentasi SMART - yaitu urutan untuk kolom jenis TIME, DATE, DATETIME dan TIMESTAMP, urutan ascending dan sebaliknya. Kembalikan nilai bawaan
Dokumentasi Sorot baris yang ditunjuk dengan kursor mouse. Kembalikan nilai bawaan
Dokumentasi Sorot baris terpilih. Kembalikan nilai bawaan
Dokumentasi Kembalikan nilai bawaan
Dokumentasi Kembalikan nilai bawaan
Dokumentasi Ulangi header setiap X sel, 0 menonaktifkan fitur ini. Kembalikan nilai bawaan
Dokumentasi Jumlah maksimum karakter yang ditunjukkan pada kolom non-angka pada mode jelajah. Kembalikan nilai bawaan
Dokumentasi Berikut ini adalah tautan Edit, Salin, dan Hapus. Kembalikan nilai bawaan
Dokumentasi Apakah untuk menampilkan link baris bahkan tanpa adanya unique key. Kembalikan nilai bawaan
Dokumentasi Default sort order for tables with a primary key. Kembalikan nilai bawaan
Dokumentasi Saat browsing tabel, penyortiran setiap tabel akan diingat. Kembalikan nilai bawaan
Dokumentasi Untuk pengaturan tampilan Kembalikan nilai bawaan
SELECT * FROM `dt01_gen_user_data`
Edit dikotak ] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan ]
Teks penuh ORG_ID USER_ID USERNAME USER_IDENTIFIER PASSWORD NIK
Nomor Induk Kepegawaian
NIP
NIP PNS Jika DiPerlukan
NAME SEX_ID EMAIL IDENTITY_NO
No KTP
NPWP_NO ADDRESS POSITION_ID SUSPENDED REGISTER_ID TILAKA_ID REVOKE_ID ISSUE_ID CERTIFICATE ACTIVE CREATED_BY CREATED_DATE PLACE_BIRTH IMAGE_PROFILE IMAGE_IDENTITY LEVEL_USER
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '006f8f10-aa25-44b5-a78b-10abb2b26359'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 006f8f10-aa25-44b5-a78b-10abb2b26359 2106363 3832333435363731 2106363 NULL Niken Putri Nielta A.md P NULL 1 NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '00b66cf1-2b63-4e57-8a49-7bd639811f73'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 00b66cf1-2b63-4e57-8a49-7bd639811f73 0601002 3832333435363731 0601002 NULL dr. Rakhma Trin Suciati Sp.A P rtrincsuciati@rsumutiasari.com 1403094406741563 NULL Field Alamat Dalam Maintenance NULL N 1b7ed170-1884-43ff-b9a2-463399fb3067 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:07 NULL N Y a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '00f8ca4d-a52c-417e-8dcb-c2b4231f46ec'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 00f8ca4d-a52c-417e-8dcb-c2b4231f46ec 2203505 3832333435363731 2203505 NULL Defry Boby Welldy, A.Md.Kep L NULL 0 NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '013f9e9e-5b29-4375-884f-b2b724ed19b5'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 013f9e9e-5b29-4375-884f-b2b724ed19b5 1301033 3832333435363731 1301033 NULL dr. Darwin NA. Sp.OG L darwinna@rsumutiasari.com 1471103010570001 NULL Field Alamat Dalam Maintenance NULL N b1ccc3d8-2a56-44a0-9829-cfca051c9ea5 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:07 NULL N Y a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '014d7b68-6917-4429-a30c-bd6fa15a60fd'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 014d7b68-6917-4429-a30c-bd6fa15a60fd 2305569 3832333435363731 2305569 NULL Sarmila Erbina Ginting S.Kes P NULL 1403096212760003 NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '01efa257-7112-4666-aea1-b36becb4fb20'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 01efa257-7112-4666-aea1-b36becb4fb20 2303584 3832333435363731 2303584 NULL Ns Tiara Indah Permata S.Kep P NULL 0 NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '02a4fc89-5beb-4201-bdd7-6b5ac3740da4'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 02a4fc89-5beb-4201-bdd7-6b5ac3740da4 2304547 3832333435363731 2304547 NULL Afrida Ariani A.Md.Keb P NULL - NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '03c88e53-8543-4cc7-8590-912837193c9a'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 03c88e53-8543-4cc7-8590-912837193c9a 2305559 3832333435363731 2305559 NULL Miftahul Mubaraq L NULL 1403092402020001 NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '044e4e51-31f5-4773-a0fa-4f00071e8205'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 044e4e51-31f5-4773-a0fa-4f00071e8205 2203398 3832333435363731 2203398 NULL Ns. Dewi Anggrainy Putri S. Kep P NULL 1375017008970002 NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:07 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '046a0ae2-be6b-4d01-a340-3c091952a041'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 046a0ae2-be6b-4d01-a340-3c091952a041 1905291 3832333435363731 1905291 NULL Utami Pratiwi, SKM P NULL 1403094307962448 NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '04add30b-4268-4f18-b985-c158497234cb'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 04add30b-4268-4f18-b985-c158497234cb 2203429 3832333435363731 2203429 NULL Trivani Febiola, A. Md. Kep P NULL 1302106602000001 NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:07 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '056dc0ba-c17c-4fee-845e-3aa51ee100fc'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 056dc0ba-c17c-4fee-845e-3aa51ee100fc 2306634 3832333435363731 2306634 NULL Reyda Fauziah S.Tr.T P NULL 1403094507011578 NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '05be2d4b-bf12-4f59-a130-9c8f877d655e'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 05be2d4b-bf12-4f59-a130-9c8f877d655e 2203474 3832333435363731 2203474 NULL Ns. Zahwa Ayunda Salsabilla S. Kep P NULL 1403094811000009 NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:07 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '064e8a5a-42b6-4e8e-be98-5452e63fda4c'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 064e8a5a-42b6-4e8e-be98-5452e63fda4c 2306598 3832333435363731 2306598 NULL ABDUL KARIM SITORUS L NULL 1209260104040003 NULL Field Alamat Dalam Maintenance NULL Y 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '06cc4288-29a1-4a52-9b62-b3643ed5e4f3'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 06cc4288-29a1-4a52-9b62-b3643ed5e4f3 2305568 3832333435363731 2305568 NULL Santi Fitria S.Kes P NULL 1403097107814936 NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '06d4c5d6-b590-41a0-b562-7838fa4089aa'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 06d4c5d6-b590-41a0-b562-7838fa4089aa 2303562 3832333435363731 2303562 NULL SESNITA A.Md.KEP P NULL 1305064710960001 NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '07f1c8bc-e092-413f-9f21-5501ded456a7'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 07f1c8bc-e092-413f-9f21-5501ded456a7 2203395 3832333435363731 2203395 NULL Miftahul Khairani, A. Md. Kep P NULL 1306076708990003 NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:07 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '07f81210-23f5-45bf-a951-2f952c6a0245'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 07f81210-23f5-45bf-a951-2f952c6a0245 2306620 3832333435363731 2306620 NULL Faisal Abid L NULL 1403132801040005 NULL Jln. Gajah Mada NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '0a2d058d-2d7b-4c08-a49f-a96a2053257d'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 0a2d058d-2d7b-4c08-a49f-a96a2053257d 2005320 3832333435363731 2005320 NULL Sukma Wanita Siregar, S. Farm P NULL 1222046311930002 NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '0ad8ffc1-a59a-4ef7-be84-79475ed71b8b'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 0ad8ffc1-a59a-4ef7-be84-79475ed71b8b 2406650 3832333435363731 2406650 NULL Al Hidayat, SE L NULL 1403091405000005 NULL bathin Salopan NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '0b9eca6b-df6c-4731-8d4b-789cea5b8888'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 0b9eca6b-df6c-4731-8d4b-789cea5b8888 2302590 3832333435363731 2302590 NULL dr. Martiana Fahriah P NULL 0 NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '0bda1b36-938a-4175-98a8-52d86424eb16'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 0bda1b36-938a-4175-98a8-52d86424eb16 2303551 3832333435363731 2303551 NULL Berlian Vallencia Mutiara Bonita A.Md.Kep P NULL 3171074908010001 NULL Field Alamat Dalam Maintenance NULL Y 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '0ca4d783-2765-4fec-8937-877bcc289a11'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 0ca4d783-2765-4fec-8937-877bcc289a11 2205390 3832333435363731 2205390 NULL Silvi Widya Syafitri, S. Farm P NULL 1403094503958407 NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '0ddd8475-bd29-4f67-a227-8654f2bb577b'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 0ddd8475-bd29-4f67-a227-8654f2bb577b 2206504 3832333435363731 2206504 NULL Fadhila Rahman L NULL 12 NULL Field Alamat Dalam Maintenance NULL Y 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:08 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM dt01_gen_user_data WHERE `dt01_gen_user_data`.`USER_ID` = '0e8a69d6-8a9b-4f9b-a54d-276f041bbcf1'
10c84edd-500b-49e3-93a5-a2c8cd2c8524 0e8a69d6-8a9b-4f9b-a54d-276f041bbcf1 1704102 3832333435363731 1704102 NULL Winda Nilam Sari, Amd. Keb P NULL 1406015605890004 NULL Field Alamat Dalam Maintenance NULL N 1 ab24ee31-f74c-4f86-a07b-27196b57e7a6 2024-05-08 15:18:07 NULL N N a3b109d6-b792-4883-b176-31bc762de98d
Dengan pilihan: Dengan pilihan:
Operasi hasil kueri Salin ke clipboard Salin ke clipboard Ekspor Ekspor Tampilkan bagan Tampilkan bagan Buat tampilan Buat tampilan
Markahi kueri SQL ini Markahi kueri SQL ini