simrs.mesujihealthcarecenter.id / localhost / baripro1 / pegawai

Navigation panel
Navigation tree
Servers
Databases
Tables

Navigation panel

Customize appearance of the 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.	Not a non-negative number!

Navigation tree

Customize the 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

Servers display options.

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

Databases display options.

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

Tables

Tables display options.

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

No bookmarks

Label: Target database: Share this bookmark

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 Bookmark Query failed Database : Queried time :

Browse mode

Browse mode

Customize 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 (180 total, Query took 0.0201 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	007	RITA OKTAVIANI	Wanita	BENDAHARA	PLSN	SDB	-	-	MEN	Manajemen	K/1	T	-	D2 KOMPUTER	0	TAMBAHSARI	1993-12-06	SIMPANG MESUJI KEC. SIMPANG PEMATANG	MESUJI	2017-10-27	<1	RJ	MANDIRI	4090304011953	AKTIF	26	0	0	2017-10-27	0	0	NULL	1810024612930002
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 2	2	1801018002	dr. LUSI FERIYANI	Wanita	KEPALA BAGIAN ADM & KEU	-	KBG	-	-	dr	Manajemen	K/1	PI	-	DOKTER UMUM	0	TANJUNG KARANG	1972-03-20	SIMPANG MESUJI RT/RW 002/007 KEC. SIMPANG PEMATANG	MESUJI	2017-10-23	<1	CS	MANDIRI	-	AKTIF	58	0	0	2017-10-23	0	0	-	1811055003720001
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 4	4	1801018060	Erwin Tri Rahayu	Wanita	Petugas Kasir	01	-	-	-	-	-	TK/0	CK	-	D3 KEPERAWATAN	0	Metro	2020-06-05	Wirabangun RT 003, RW 006 Simpang Pematang	Mesuji	0000-00-00	<1	CS	MANDIRI	-	KELUAR	-2	0	0	0000-00-00	0	0	pages/pegawai/photo/	181105
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 5	5	1801018003	Yasep Sudiarto	Pria	Kabid Adm Umum dan Keuang	PJBU	-	-	-	MEN	Non Medis	K/2	T	-	OUT	0	Kotabumi	2020-06-15	Simpang Pematang	Mesuji	0000-00-00	PT	CS	MANDIRI	4090304012009	KELUAR	-5	0	0	0000-00-00	0	0	NULL	1811051909850002
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 6	6	1801018029	Finah	Wanita	Staf Gizi	PLSN	-	-	-	-	Non Medis	K/2	T	-	OUT	0	Tanjung Harta	0000-00-00	Simpang Pematang	Mesuji	0000-00-00	<1	CS	MANDIRI	4090304012025	KELUAR	0	0	0	0000-00-00	0	0	NULL	1811054503890001
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 7	7	1801018032	AGUS TRIYONO	Pria	PETUGAS IPRS	PLSN	AG	-	-	IPRS	Non Medis	K/1	T	-	SMA	0	JAYA SAKTI	1984-12-01	JAYA SAKTI RT 003/RW 004 KEC. SIMPANG PEMATANG	MESUJI	2017-10-23	<1	CS	MANDIRI	4090304012057	KELUAR	-5	0	0	2017-10-23	0	0	NULL	1811061201840002
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 9	9	016	LANTASI	Wanita	PETUGAS LAUNDRY	PLSN	AG	-	-	LAU	Non Medis	K/2	T	-	SMA	0	LAMPUNG TENGAH	1979-02-07	BUDI AJI RK 5 KEC. SIMPANG PEMATANG	MESUJI	2017-10-23	<1	CS	MANDIRI	4090304012037	AKTIF	-5	0	0	2017-10-23	0	0	NULL	1811054207790001
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 10	10	1801018001	dr. HERMAN SUSILO, SpB., M.Kes	Pria	SPESIALIST BEDAH	-	-	-	-	dr	Medis	K/1	-	-	DOKTER SPESIALIS	0	Pekalongan	1971-12-05	Jl. JENDRAL SUDIRMAN SIMPANG MESUJI, SP. PEMATANG	MESUJI	2017-10-23	<1	CS	MANDIRI	-	AKTIF	-5	0	0	2017-10-23	0	0	NULL	1811051205710001
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 11	11	1801018010	dr. Yohanes Didik Purwo Saputro, Sp.OG	Pria	Ketua Komite Medik	01	-	-	-	-	-	K/3	PT	-	DOKTER SPESIALIS	0	Mengandung Sari	0000-00-00	Mengandung Sari	-	0000-00-00	<1	CS	MANDIRI	-	KELUAR	0	0	0	0000-00-00	0	0	NULL	1671080702740000
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 12	12	1801018065	APRI RATNA SARI A. Md. AK	Wanita	ANALIS KESEHATAN	PLSN	AG	-	-	LAB	Medis	K/0	FT	-	D3 ANALIS	0	BRABASAN	1998-04-04	BERASAN MAKMUR RT 006 RW 004 TANJUNG RAYA	MESUJI	2019-04-23	<1	CS	MANDIRI	-	KELUAR	-5	0	0	2019-04-23	0	0	NULL	1811074404980002
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 13	13	1801018007	dr. Dina Martina	Wanita	-	-	-	-	-	-	Dokter Umum	TK/0	-	-	DOKTER UMUM	0	Tj. Karang	0000-00-00	Jl. H. Said Gang Kadu Pedang 10A Kotabaru Bandar L...	Bandar Lampung	0000-00-00	<1	CS	MANDIRI	4090304012196	KELUAR	-5	0	0	0000-00-00	0	0	NULL	1871054803850002
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 17	17	1801018055	drg. ALIF CHANDRA ARYONO	Pria	DOKTER GIGI	DIRU	-	-	-	dr	Medis	K/2	FT	-	DOKTER UMUM	0	MULYA JAYA	1987-08-22	PERUM BPK BLOK C NO.12 GEDONG MENENG KEC.RAJABASA	BANDAR LAMPUNG	2018-08-21	<1	CS	MANDIRI	-	KELUAR	26	0	0	2018-08-21	0	0	NULL	3515122208870001
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 19	19	1801018015	AMELIA WAHYU UTARI S.ST	Wanita	BIDAN	-	AG	-	-	PAR	Medis	K/1	T	-	D4 KEBIDANAN	0	SIMPANG PEMATANG	1991-06-07	SIMPANG MESUJI RK. 10 KEC. SIMPANG PEMATANG	MESUJI	2017-10-23	<1	CS	MANDIRI	4090304011981	AKTIF	0	0	0	2017-10-23	0	0	NULL	1811055706910002
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 20	20	1801018014	Desi Ratna Sary, S.Kep.Ns	Wanita	Perawat	01	-	-	-	-	Medis	K/1	CT	-	D3 PERAWAT	0	Harapan Jaya	2022-01-31	Aji Jaya	Mesuji	0000-00-00	<1	CS	MANDIRI	4090304011857	KELUAR	0	0	0	0000-00-00	0	0	NULL	1811057108910001
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 21	21	1801018024	DIAN RATNA SEPTIYANI Amd.Rad	Wanita	RADIOGRAFER	PLSN	KRU	-	-	RAD	Medis	K/1	FT	-	D3 RADIOLOGY	0	SIMPANG PEMATANG	1992-09-01	SIMPANG MESUJI SIMPANG PEMATANG	MESUJI	2017-10-23	<1	CS	MANDIRI	4090304011900	AKTIF	-5	0	0	2017-10-23	0	0	NULL	1811054109920001
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 22	22	1801018016	ENDANG MARYANI, A.Md.Keb	Wanita	BIDAN	PLSN	KRU	-	-	PAR	Medis	TK/0	FT	-	D3 KEBIDANAN	0	SIMPANG PEMATANG	1992-01-12	SIMPANG MESUJI RT.001/RW.003 KEC. SIMPANG PEMATANG	MESUJI	2017-10-23	<1	CS	MANDIRI	4090304011964	AKTIF	-5	0	0	2017-10-23	0	0	NULL	3505145201920003
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 27	27	1801018021	SEVTI ALBED TRIYANA S.Far.Apt	Wanita	KEPALA APOTEK	PJBd	KBG	-	-	APT	Medis	K/1	FT	-	APOTEKER	0	Metro	1983-09-11	BRABASAN RT 3 RW 3 KEC. TANJUNG RAYA	KOTA BUMI	2017-10-23	<1	CS	MANDIRI	4090304012208	KELUAR	0	0	0	2017-10-23	0	0	NULL	180310510980002
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 30	30	1801018020	DEDI RUSTIAWAN A.md.Kep	Pria	PERAWAT	PLSN	AG	-	-	-	Medis	TK/0	T	-	D3 PERAWAT2	0	LABUHAN JAYA	0000-00-00	Harapan Jaya	OKI	2018-10-23	<1	CS	MANDIRI	4090304011829	KELUAR	-5	0	0	2018-10-23	0	0	NULL	1811042104960002
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 31	31	1801018027	INTAN PERMATA SARI Amd Ak	Wanita	ANALIS KESEHATAN	PLSN	AG	-	-	LAB	Medis	K/1	FT	-	D3 ANALIS	0	Bukit Kemuning	1996-11-27	SIMPANG MESUJI RT 001/RW 005 SIMPANG PEMATANG	MESUJI	2017-10-23	<1	CS	MANDIRI	4090304011832	KELUAR	-5	0	0	2017-10-23	0	0	NULL	1811056711960001
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 33	33	1801018017	Ns. WITRIYANTO, S.Kep	Pria	PERAWAT	KASI	KRU	-	-	PAR	Medis	K/1	T	-	S1 PERAWAT	0	HARAPAN JAYA	1991-07-27	HARAPAN JAYA RT/RW, 001/003. KEC. SIMPANG PEMATANG	MESUJI	2017-10-23	<1	CS	MANDIRI	4090304011949	AKTIF	-5	0	0	2017-10-23	0	0	NULL	1811052707910001
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 34	34	1801018064	Hardiya Pratiwi	Wanita	Kasir	01	-	-	-	-	-	K/1	CK	-	OUT	0	Bangkalis	0000-00-00	Gedung Ram RT 017, RW 004 Gedung Ram Tanjung Raya	Mesuji	0000-00-00	<1	CS	MANDIRI	-	KELUAR	-5	0	0	0000-00-00	0	0	NULL	1811076404970001
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 37	37	1801018008	dr. MIRAWATI	Wanita	KATIM DOKTER	-	-	-	-	dr	Dokter Umum	K/0	FT	-	DOKTER UMUM	0	MARTA PURA	1991-01-15	PEMATANG PANGGANG BLOK A SURYA ADI KEC. MESUJI	OOGAN KOMERING ILIR	2017-10-23	<1	CS	MANDIRI	4090304012168	AKTIF	-5	0	0	2017-10-23	0	0	NULL	1602045501910003
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 38	38	1801018006	dr. HERI MARDIANTO	Pria	KASIE PENUNJANG MEDIS	-	KSI	-	-	dr	Dokter Umum	-	-	-	DOKTER UMUM	0	PURBA SAKTI	1990-01-25	DS. BUKOPOSO RT.02 KEC.WAY SERDANG KAB.MESUJI	MESUJI	2017-10-23	<1	CS	MANDIRI	4090304011669	AKTIF	-5	0	0	2017-10-23	0	0	NULL	1871102501900002
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 40	40	1801018051	AMIN FAUZI A.Md	Pria	KASUBAG KEU & AKUNTANSI	PLSN	KSB	-	-	MEN	Non Medis	K/1	T	-	D3 KOMPUTER	0	SIMPANG PEMATANG	1991-07-18	DS. SIMPANG PEMATANG KEC. SIMPANG PEMATANG	MESUJI	2018-10-23	<1	CS	MANDIRI	4090304013527	KELUAR	-5	0	0	2018-10-23	0	0	NULL	1805051807910003
Edit	Copy	Delete DELETE FROM `pegawai` WHERE `pegawai`.`id` = 41	41	1801018057	NASIKHIN	Pria	PERAWAT PELAKSANA	PLSN	AG	-	-	-	Medis	K/1	FT	-	D3 KEPERAWATAN	0	WIRA BANGUN	1988-07-21	SIMPANG MESUJI RK.04/RW.06 KEC. SIMPANG PEMATANG	MESUJI	2018-10-21	<1	CS	MANDIRI	-	AKTIF	0	0	0	2018-10-21	0	0	NULL	181105

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view