sgpc1346.tail33e774.ts.net / 127.0.0.1 / phc / login

There are no favourite tables.

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

Customise 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 :

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

Customise 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 (3114 total, Query took 0.0036 seconds.) [k_laluan: FFDAB8BCAC5AE51462F36B41E4143F6E... - F605287CE3DA829125C07CF3DC6C1216...]

SELECT * FROM `login` ORDER BY `k_laluan` DESC

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

Filter rows:

			mykad	k_laluan 1	level	peg_kemaskini	masa_kemaskini
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '800116025062'	800116025062	ffdab8bcac5ae51462f36b41e4143f6e	1		2020-04-07 15:12:05
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '770216026068'	770216026068	ff793bd97151e21c792aa6ad1b1bdacb	1		2015-06-11 10:13:37
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '890208075464'	890208075464	feb68fdc3b2226cd18aad2484b653f99	1		2015-06-11 10:13:37
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '750108086399'	750108086399	fe854a5d8f1941fb70e566e285c4d601	1		2015-09-30 20:27:44
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '851204075166'	851204075166	fd487378d46fd33f8e5390d601db4b90	1		2015-10-27 16:43:00
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '751126025244'	751126025244	fd2fe536c2cd4690987479b48960b338	1	751126025244	2015-06-11 10:13:37
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '930917026036'	930917026036	fce2cf325ea281cdafdd0f85ecfa187a	1		2024-08-17 16:09:48
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '850205025836'	850205025836	fc7fb7a87fb8f9c17cb56e0152cab9d9	1		2015-06-11 10:13:37
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '960814085292'	960814085292	fc6b4025149924e9beeddea5482a82c0	1		2023-02-21 17:11:13
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '790419086528'	790419086528	fc6b4025149924e9beeddea5482a82c0	1	790419086528	2015-06-11 10:13:37
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '940115085308'	940115085308	fba443a3c534fc482f9c63702c45964e	1		2019-10-22 14:40:44
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '921023025849'	921023025849	fb3c3acf4e0a0092bc4595b90057ad62	1		2020-10-06 10:57:50
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '800314075220'	800314075220	fb2d77d36fb31dc3c2b6bbd240f967a1	1	800314075220	2015-06-11 10:13:37
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '901201015427'	901201015427	fb25c63140fa5cba9920cbe5a771d7aa	1	901201015427	2018-12-19 16:22:27
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '870922085469'	870922085469	fb1ea337866ec89b3ff8230b36def41c	1	870922085469	2021-09-19 11:36:47
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '960430075298'	960430075298	faa6a2bb4f65a308152524bcd3c77e4e	1		2022-04-12 08:44:46
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '730403025718'	730403025718	fa76457b792a300709f44ddef0e9de53	1	730403025718	2015-06-11 10:13:37
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '921119025886'	921119025886	f96c2da9454d826f3e5e665e265aa709	1		2022-04-10 10:27:33
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '950306086134'	950306086134	f901c4123f013d6a57bf01589cadb2a6	1		2021-08-03 10:10:03
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '920226016278'	920226016278	f8c9412b9dd3075632dc1a3e487486e2	1		2021-10-05 10:36:23
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '910322025802'	910322025802	f7b0cb657d094077562b24e760fe68e7	1	910322025802	2018-04-03 09:20:28
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '910913075318'	910913075318	f7957155d13d7884e7197e5b0f4fe071	1		2019-11-27 10:27:43
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '850906715047'	850906715047	f73659890c1e4caa254b59bd13f6c99e	1		2015-06-11 10:13:37
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '770227025212'	770227025212	f6e5af1ccbf46ebc8e2da1ffca73af02	1	770227025212	2016-12-20 11:52:30
Edit	Copy	Delete DELETE FROM login WHERE `login`.`mykad` = '850115145121'	850115145121	f605287ce3da829125c07cf3dc6c1216	1		2015-06-11 10:13:37

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view