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 :
Customise 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 `dperibadi` ORDER BY `icpp` DESC
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
|
|
|
Filter rows:
Sort by key:
Full texts id Nama ic kumpulan kumpulan2 jawatan gred unit sambungan telbimbit TLapor NoAPC TLuput lembaga nopendaftaran icpp Descending Ascending 1 status peg_kemaskini masa_kemaskini
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '700506115006'
 		389 ZALILAWATI BINTI ABD RAHMAN 700506115006 P1 P1 9 4 20 2111 019-4446886 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 700506115006 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '700918025242'
 		1193 FAUZIAH BINTI AHMAD 700918025242 P1 P1 81 7 129 8110 0174231691 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 810630075731 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '710910025730'
 		1185 ANBARESI A/P ARUNASALAM 710910025730 P1 P1 81 11 129 6300 0194352916 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 710910025730 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '711211025314'
 		399 ANITA BINTI AHMAD 711211025314 P1 P1 9 7 22 2500 0125109401 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 711211025314 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '720926015544'
 		651 ZURIDAH BINTI SULONG 720926015544 P1 P1 9 7 41 7306 0135880431 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 720926015544 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '730617025596'
 		615 RODZIAH BT MAT SHAH 730617025596 P1 P1 9 7 55 7107 0132408472 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 730617025596 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '731217025348'
 		764 NORHAYATI BINTI ABU SEMAN 731217025348 P1 P1 9 7 73 6208 0164261073 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 731217025348 2026-04-02 11:23:49
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '740129025270'
 		621 ROSLIZA BINTI MD ISA 740129025270 P1 P1 9 7 95 2111 010-8701808 1998-12-16 0000-00-00 Sila Pilih 1 740129025270 2026-07-02 10:40:26
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '750916106001'
 		1298 MOHD FISAL BIN HAMID 750916106001 P1 P1 51 4 20 5001 0000-00-00 0000-00-00 Sila Pilih 1 750916106001 2026-03-24 18:58:12
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '760102037616'
 		3381 SHABIBAH BINTI MUHAMMAD 760102037616 P1 P1 5 7 28 3239 0199711203 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 0 760102037616 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '761203025790'
 		2658 KHAIRIZA BINTI IDRUS 761203025790 P1 P1 9 4 22 7003 0125517853 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 0 761203025790 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '761225025214'
 		582 HAMURI BINTI MURIDUN 761225025214 P1 P1 9 7 22 7400 0135216547 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 761225025214 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '770102085086'
 		906 ZANARIAH BINTI AHMAD 770102085086 P1 P1 9 7 8 4401 0135085086 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 770102085086 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '780401035846'
 		2699 KARTINI BINTI IBRAHIM 780401035846 P1 P1 9 4 22 7303 0134849445 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 780401035846 2026-08-14 23:44:27
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '780713086052'
 		2845 LEE SEOK HONG 780713086052 P1 P1 9 4 3 8109 0123178802 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 780713086052 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '780725115332'
 		2018 SITI KHADIJAH BINTI JAAFAR 780725115332 P1 P1 9 7 55 7400 01118601978 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 780725115332 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '791228025882'
 		4054 ZUHALIZA BINTI ZULKIPLE 791228025882 P1 P1 2 13 22 2307 0142372611 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 791228025882 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '810123025772'
 		3444 SITI SURIANA BT MOHD NASIR 810123025772 P1 P1 9 289 39 4601 0195895772 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 810123025772 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '810531065474'
 		3772 RINA BINTI MAT ZAIN 810531065474 P1 P1 9 7 15 4301 0133807856 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 810531065474 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '810723065532'
 		513 RAFIDAH BINTI SEMAN 810723065532 P1 P1 9 7 9 2312 0134327980 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 810723065532 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '810727026004'
 		936 ZOHRAH BINTI OTHMAN 810727026004 P1 P1 9 4 53 NULL NULL 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 810727026004 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '810730085654'
 		4287 BEH HUI CHIEN 810730085654 P&P NULL 24 42 33 3600 0164408518 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 810730085654 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '810816025214'
 		1714 SITI HAJAR BT AWANG KECHIK 810816025214 P2 P2 47 2 81 2307 0195050883 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 810816025214 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '811206086292'
 		4494 ZULYANI BT ZULKEPLE 811206086292 P1 NULL 9 7 112 3509 0104050509 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 811206086292 0000-00-00 00:00:00
Edit Edit Copy Copy Delete Delete
DELETE FROM dperibadi WHERE `dperibadi`.`ic` = '820311025437'
 		1974 AMINUDDIN BIN SULAIMAN 820311025437 P1 P1 9 289 73 6208 0194322432 0000-00-00 NULL 0000-00-00 NULL NULL Sila Pilih 1 820311025437 0000-00-00 00:00:00
With selected: With selected:
|
|
|
Filter rows:
Sort by key:
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