Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »Table: registration_numbers
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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:

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (257300 total, Query took 0.0049 seconds.)
SELECT * FROM `registration_numbers`

Full texts id uno uid type created_date created_by locationname
1 MR/18/000001 NULLREG 2018-01-30 10:26:59 000159 AHB
2 MR/18/000002 NULLREG 2018-01-30 10:40:34 000159 AHB
3 MR/18/000003 NULLREG 2018-01-30 10:59:31 000159 AHB
4 MR/18/000004 NULLREG 2018-01-30 11:01:02 000159 AHB
5 MR/18/000005 NULLREG 2018-01-30 12:29:30 000159 AHB
6 MR/18/000006 NULLREG 2018-01-30 12:50:19 000159 AHB
7 MR/18/000007 NULLREG 2018-01-30 12:55:08 000159 AHB
8 MR/18/000008 NULLREG 2018-01-30 12:57:25 000159 AHB
9 MR/18/000009 NULLREG 2018-01-30 13:02:16 000159 AHB
10 MR/18/000010 NULLREG 2018-01-30 13:04:10 000159 AHB
11 MR/18/000011 NULLREG 2018-01-30 13:11:40 000159 AHB
12 MR/18/000012 NULLREG 2018-01-30 15:46:25 000159 AHB
13 MR/18/000013 NULLREG 2018-01-30 15:48:36 000159 AHB
14 MR/18/000014 NULLREG 2018-01-30 15:53:06 000159 AHB
15 MR/18/000015 NULLREG 2018-01-30 15:58:31 000159 AHB
16 MR/18/000016 NULLREG 2018-01-30 16:00:36 000159 AHB
17 MR/18/000017 NULLREG 2018-01-31 11:08:51 000159 AHB
18 MR/18/000018 NULLREG 2018-01-31 11:37:10 000159 AHB
19 MR/18/000019 NULLREG 2018-01-31 11:38:37 000159 AHB
20 MR/18/000020 NULLREG 2018-01-31 11:39:49 000159 AHB
21 MR/18/000021 NULLREG 2018-01-31 11:41:32 000159 AHB
22 MR/18/000022 NULLREG 2018-01-31 11:45:54 000159 AHB
23 MR/18/000023 NULLREG 2018-01-31 11:47:47 000159 AHB
24 MR/18/000024 NULLREG 2018-01-31 11:50:34 000159 AHB
25 MR/18/000025 NULLREG 2018-01-31 11:52:37 000159 AHB