rspermatamadinasibuhuan.rumah-sakit.online / 127.0.0.1 / sik / pegawai

There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (199 total, Query took 0.0010 seconds.)

SELECT * FROM `pegawai`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

Sort by key:

			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	mulai_kerja	ms_kerja	indexins	bpd	rekening	stts_aktif	wajibmasuk	pengurang	indek	mulai_kontrak	cuti_diambil	dankes	photo	no_ktp
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 1	1	20010005	Ade Yanti Nasution	Wanita	-	-	-	-	-	-	-	-	-	-	-	0	TANGGA BOSI	1997-02-27	LUBUK BARUMUN	PADANG LAWAS	2020-01-26	<1	-	BPD	-	AKTIF	0	0	0	2024-08-27	0	0	-	1203276702970003
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 2	2	23040124	Adian Soleh	Pria	-	-	-	-	-	OPS	ADM UMUM DAN IT	-	-	-	-	0	SIBUHUAN	1996-04-24	LINGKUNGAN I	PADANG LAWAS	2023-04-12	<1	-	BPD	-	AKTIF	0	0	0	2024-08-27	0	0	-	1221072407950003
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 4	4	23090148	Ameliah Saputri	Wanita	-	-	-	-	-	-	-	-	-	-	-	0	SIBUHUAN	2003-03-06	LK. VI PASAR SIBUHUAN	PADANG LAWAS	2023-09-18	<1	-	BPD	-	KELUAR	0	0	0	2024-08-27	0	0	-	1221075212020006
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 5	5	13120056	Arifah Fitria Daulay	Wanita	-	-	-	-	-	VK	BIDAN	-	T	-	-	0	PARINGGONAN	1992-04-07	LINGKUNGAN VII	PADANG LAWAS	2013-12-28	<1	-	BPD	-	AKTIF	0	0	0	2024-08-27	0	0	-	1221064704920000
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 8	8	19060041	Atika Nopiana Hasibuan	Wanita	-	-	-	-	-	BADM	ADM UMUM DAN IT	-	-	-	-	0	PARINGGONAN	1989-11-11	PARINGGONAN	PADANG LAWAS	2019-06-26	<1	-	BPD	-	AKTIF	0	0	0	2024-08-27	0	0	-	1221065111890001
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 9	9	23060137	Desi Annasari Nasution	Wanita	KEPALA UNIT	-	-	-	-	RNAP	BIDAN	-	-	-	-	0	BATANG BULU TANGGAL	2000-11-10	BATANG BULU TANGGAL	PADANG LAWAS	2023-06-13	<1	-	BPD	-	KELUAR	0	0	0	2024-08-27	0	0	-	1221045011000002
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 10	10	2022022040	Desi Ratna Sari Juned	Wanita	-	-	-	-	-	-	-	-	-	-	-	0	PASAR UJUNG BATU	1996-01-04	TANJUNG BOTUNG	PADANG LAWAS	2022-02-15	<1	-	BPD	-	KELUAR	0	0	0	2024-08-27	0	0	-	1203134601960002
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 11	11	23030135	Devi Wulandari	Wanita	-	-	-	-	-	VK	BIDAN	-	-	-	-	0	SIBUHUAN	1996-01-25	LINGKUNGAN I PASAR SIBUHUAN	PADANG LAWAS	2023-03-26	<1	-	BPD	-	KELUAR	0	0	0	2024-08-27	0	0	-	1221076501960001
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 12	12	23120156	Dian Taufik	Pria	-	-	-	-	-	IGD	-	-	-	-	-	0	SIBUHUAN	1994-03-20	LINGKUNGAN I PASAR SIBUHUAN	PADANG LAWAS	2023-12-01	<1	-	BPD	-	AKTIF	0	0	0	2024-08-27	0	0	-	1921072003940001
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 13	13	23050128	Eka Wartati Nasution	Wanita	-	-	-	-	-	FAR	PENUNJANG MEDIS	-	-	-	-	0	MEDAN	1999-01-10	LING VI PASAR SIBUHUAN	PADANG LAWAS	2023-05-17	<1	-	BPD	-	AKTIF	0	0	0	2024-08-27	0	0	-	1221065001990002
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 14	14	20080021	Elna Kholija Nasution	Wanita	-	-	-	-	-	KPU	TENAGA NON MEDI	-	-	-	-	0	SIBUHUAN JULU	1991-01-01	SIBUBHUAN JULU	PADANG LAWAS	2020-08-05	<1	-	BPD	-	AKTIF	0	0	0	2024-08-27	0	0	-	1221074101910004
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 15	15	22110117	Emi Ruwanda Hasibuan	Wanita	-	-	-	-	-	KPU	TENAGA NON MEDI	-	-	-	-	0	SIMANULDANG JULU	2002-05-25	SIMANULDANG JULU	PADANG LAWAS	2022-11-08	<1	-	BPD	-	AKTIF	0	0	0	2024-08-27	0	0	-	1221066505020001
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 16	16	11070024	Emmi Novida Nasution	Wanita	-	-	-	-	-	PERI	PERAWAT	-	T	-	-	0	PADANG SIDIMPUAN	1977-10-11	LINGKUNGAN IV PASAR SIBUHUAN	PADANG LAWAS	2011-07-11	<1	-	BPD	-	AKTIF	0	0	0	2025-07-14	0	0	-	3376015110770003
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 18	18	2001025	Fitri Amani Siregar	Wanita	-	-	-	-	-	RNAP	PERAWAT SARJANA	-	-	-	-	0	PASAR UJUNG BATU	1995-10-26	PASAR UJUNG BATU	PADANG LAWAS	2020-01-26	<1	-	BPD	-	AKTIF	0	0	0	2024-08-27	0	0	-	1221086610950002
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 19	19	23100165	Guntur Kurniawan Hasibuan	Pria	-	-	-	-	-	HMS	TENAGA NON MEDI	-	-	-	-	0	PASAR SIBUHUAN	1991-03-29	SIOLIP	PADANG LAWAS	2023-10-22	<1	-	BPD	-	AKTIF	0	0	0	2025-01-03	0	0	-	1203122903910001
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 20	20	22030107	Hadisah Lubis	Wanita	-	-	-	-	-	LT 2	BIDAN	-	-	-	-	0	PASIR JAE	1997-09-24	PASIR JAE	PADANG LAWAS	2022-03-28	<1	-	BPD	-	AKTIF	0	0	0	2024-07-11	0	0	-	1221086409970002
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 21	21	2023051060	Hendra Muda Hasibuan	Pria	-	-	-	-	-	-	-	-	-	-	-	0	SIBUHUAN	1997-01-01	LINGKUNGAN I PASAR SIBUHUAN	PADANG LAWAS	2023-05-29	<1	-	BPD	-	KELUAR	0	0	0	2024-08-27	0	0	-	1203120101970002
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 22	22	2023112070	Irma Yanti Daulay	Wanita	-	-	-	-	-	-	-	-	-	-	-	0	SIUNDOL JULU	1999-11-24	SIUNDOL JULU	PADANG LAWAS	2023-11-09	<1	-	BPD	-	KELUAR	0	0	0	2024-08-27	0	0	-	1203116411990001
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 23	23	11070045	Jonni Irsan Harahap	Pria	KA.UNIT	-	-	-	-	UGD	PERAWAT	-	-	-	D3 PERAWAT	0	PADANG SIDIMPUAN	1982-01-14	SIBUHUAN	PADANG LAWAS	2011-07-11	<1	-	BPD	-	AKTIF	0	0	0	2025-07-14	0	0	-	1221071401820002
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 24	24	20070006	Khairani Rizkiah Hasibuan	Wanita	-	-	-	-	-	PBK	TENAGA NON MEDI	-	-	-	-	0	HUTA RAJA LAMA	2000-09-05	HUTA RAJA LAMA, SOSA	PADANG LAWAS	2020-07-13	<1	-	BPD	-	AKTIF	0	0	0	2025-08-27	0	0	-	1221084509000002
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 25	25	21080079	Lanna Sari Parinduri	Wanita	-	-	-	-	-	KEU	KEUANGAN	-	-	-	-	0	HUTADANGKA	1997-05-22	HUTADANGKA	MANDAILING NATAL	2021-08-30	<1	-	BPD	-	AKTIF	0	0	0	2025-06-12	0	0	-	1213086205970004
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 26	26	16010020	Lanni Masitoh Nasution	Wanita	-	-	-	-	-	GIZ	TENAGA NON MEDI	-	-	-	-	0	SIBUHUAN JULU	1996-12-15	SIBUHUAN	PADANG LAWAS	2016-01-26	<1	-	BPD	-	AKTIF	0	0	0	2025-07-25	0	0	-	1203125512960002
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 27	27	23120175	Linda Permatasari Simamora	Wanita	-	-	-	-	-	PRJ	TENAGA NON MEDI	-	-	-	-	0	SIBUHUAN	2002-10-10	LINGK I PASAR SIBUHUAN	PADANG LAWAS	2023-12-20	<1	-	BPD	-	AKTIF	0	0	0	2024-07-09	0	0	-	1203125010000003
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 28	28	19080036	Lusi Winayati Pulungan	Wanita	-	-	-	-	-	RJL	PERAWAT	-	-	-	-	0	PIR TRANS SOSA II A	1996-09-03	PIR TRANS SOSA I A	PADANG LAWAS	2019-08-26	<1	-	BPD	-	AKTIF	0	0	0	2024-12-12	0	0	-	1203194309960001
Edit	Copy	Delete DELETE FROM pegawai WHERE `pegawai`.`id` = 29	29	23100151	Mahmudin Nasution	Pria	-	-	-	-	-	IT	ADM UMUM DAN IT	-	-	-	-	0	PARMOMPANG	1996-10-02	LING. KUBANG WELINGI	KOTA CILEGON	2023-10-05	<1	-	BPD	-	AKTIF	0	0	0	2024-12-18	0	0	-	3603020210960004

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view