sgpc1346.tail33e774.ts.net / 127.0.0.1 / elatihanfinal / dperibadi

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.
Favourite tables Maximum number of favourite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

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.

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.

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

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

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 :

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

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

			id	Nama	ic	kumpulan	kumpulan2	jawatan	gred	unit	sambungan	telbimbit	TLapor	NoAPC	TLuput	lembaga	nopendaftaran	icpp	status	peg_kemaskini	masa_kemaskini
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = ' 911212025566'	5126	HANIS HAIFA IZZATY BT MAZLAN	911212025566	P2	NULL	104	65	38	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	2026-05-19 16:56:37
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '000210020772'	4958	CASSANDRA GOEI YEE CING	000210020772	P&P	NULL	94	296	18	2703	0174365152	0000-00-00	NULL	0000-00-00	NULL	NULL	900719145192	1	000210020772	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '000306081596'	4980	NUR AQILAH SYUHADA BINTI BUKHORI	000306081596	P&P	NULL	37	296	18	3403	NULL	0000-00-00	NULL	0000-00-00	NULL	NULL	900719145192	1	000306081596	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '000407070538'	4848	NUR AMILIA BINTI AMINURASHID	000407070538	P1	NULL	101	290	37	NULL	NULL	0000-00-00	NULL	0000-00-00	NULL	NULL	830212145328	0	000407070538	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '000410020312'	4999	NUR HANIS ADIBAH BINTI JAMALUDIN	000410020312	P&P	NULL	37	296	18	NULL	NULL	0000-00-00	NULL	0000-00-00	NULL	NULL	900719145192	1	000410020312	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '000423020215'	5127	MUHAMMAD FIEZRAL DANIAL BIN HAMIDUN	000423020215	P1	NULL	51	4	20	8812	0175685260	2023-09-16		NULL			NULL	1	000423020215	2026-06-03 14:24:31
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '000507020052'	4953	NURUL NISA IWANA BINTI RIDZUAN	000507020052	P2	NULL	41	65	108	NULL	NULL	0000-00-00	NULL	0000-00-00	NULL	NULL	820909026135	1	000507020052	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '000519090189'	4808	AZRUL ASHRAF BIN GHAZALI	000519090189	P1	NULL	51	4	20	NULL	NULL	0000-00-00	NULL	0000-00-00	NULL	NULL	NULL	1	NULL	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '000621140402'	4563	NURIN HASYA BINTI MOHAMAD ROSHIDIN	000621140402	P1	NULL	5	4	95	3203	01111223605	0000-00-00	NULL	0000-00-00	NULL	NULL	840330085804	1	000621140402	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '000809020306'	5115	NURUL FATIHAH BINTI AMIR	000809020306	P1	NULL	51	4	20	8812		2021-10-21		NULL			NULL	1		2026-04-13 15:44:20
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '000831030658'	4986	PHOON YI JUN	000831030658	P&P	NULL	37	296	18	1600	0162208189	0000-00-00	NULL	0000-00-00	NULL	NULL	840111075067	1	000831030658	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '000902011404'	4557	NURUL SYIFA ADILA BINTI NOR AZMAN	000902011404	P1	NULL	7	4	32	2128	0193085651	0000-00-00	NULL	0000-00-00	NULL	NULL	660504025927	1	000902011404	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '000927020446'	4992	FATIN NABILAH BINTI ABU SEMAN	000927020446	P&P	NULL	37	296	18	1600	01110441223	0000-00-00	NULL	0000-00-00	NULL	NULL	831024075128	1	000927020446	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '001107020090'	4973	NUR ALYAA NAJWA BINTI MOHD KHALIL	001107020090	P&P	NULL	94	296	18	1703	0195492194	0000-00-00	NULL	0000-00-00	NULL	NULL	880618075222	1	001107020090	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '010706090036'	5046	NUR SYAMIMI BINTI ROSZAIDI	010706090036	NULL	NULL	44	68	56	NULL	NULL	0000-00-00	NULL	0000-00-00	NULL	NULL	NULL	1	NULL	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '021202020636'	5153	NUR SHAHMIMI BINTI GHAZALI	021202020636	P1	NULL	101	65	37	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	2026-07-13 16:25:18
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '1111'	5128	TESTING	1111	P1	NULL	41	290	130	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	2026-06-07 13:21:53
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '123456789'	5122	TEST	123456789	P1	NULL	10	311	20	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	2026-04-12 16:37:31
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '3333'	5139	TESTED 3333	3333	P&P	NULL	33	29	130	3333		2026-06-01		NULL			770726036805	0	3333	2026-06-08 12:34:31
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '660310026008'	665	BALKHIS BT ABU BAKAR	660310026008	P1	P1	9	7	6	4100	0194495896	0000-00-00	NULL	0000-00-00	NULL	NULL	820629095080	1	660310026008	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '660322025424'	2186	FARIDAH BT ISMAIL	660322025424	P1	P1	31	59	85	0	NULL	0000-00-00	NULL	0000-00-00	NULL	NULL	840816025174	1	660322025424	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '660402026013'	2970	AZHAR BIN AHMAD	660402026013	P1	P1	52	75	108	3014	0125016991	0000-00-00	NULL	0000-00-00	NULL	NULL	790920026000	0	780319025526	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '660402026208'	1710	SHAHRUL HANIM BT ABD LATIFF	660402026208	P2	P2	47	3	81	2600	0107925174	0000-00-00	NULL	0000-00-00	NULL	NULL	871214075192	0	660402026208	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '660408026495'	3068	ABDULLAH BIN KASSIM	660408026495	P1	P1	41	64	108	3004	0134516495	0000-00-00	NULL	0000-00-00	NULL	NULL	790923025820	0	660408026495	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '660421086505'	1837	SHAHIDAN BIN YUSUF	660421086505	P2	P2	43	287	83	NULL	NULL	0000-00-00	NULL	0000-00-00	NULL	NULL	821117025550	1	821117025550	0000-00-00 00:00:00

Customise appearance of the navigation panel.

Customise the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

Customise browse mode.

Navigation panel

Customise appearance of the navigation panel.

Navigation tree

Customise the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

Browse mode

Customise browse mode.