Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »View: ERwe
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
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation
Showing rows 0 - ... This view has at least this number of rows. Please refer to documentation. (Query took 0.8589 seconds.)
SELECT * FROM `ERwe`

id patient_no mrno
29586 IP/21/011301 MR/21/035627
29587 IP/21/011302 MR/21/031153
29588 IP/21/011303 MR/21/031189
29589 IP/21/011304 MR/21/036543
29590 IP/21/011305 MR/21/036431
29591 IP/21/011306 MR/21/036540
29592 IP/21/011307 MR/21/035164
29593 IP/21/011308 MR/21/036615
29594 IP/21/011309 MR/21/022936
29595 IP/21/011310 MR/21/035569
29596 IP/21/011311 MR/21/036677
29597 IP/21/011312 MR/19/043176
29598 IP/21/011313 MR/21/036679
29599 IP/21/011314 MR/21/036675
29601 IP/21/011316 MR/21/036563
29602 IP/21/011317 MR/21/036630
29603 IP/21/011318 MR/21/036593
29604 IP/21/011319 MR/21/036685
29605 IP/21/011320 MR/21/036684
29607 IP/21/011322 MR/21/036681
29608 IP/21/011323 MR/21/036680
29609 IP/21/011324 MR/21/036687
29610 IP/21/011325 MR/21/036674
29611 IP/21/011326 MR/21/036688
29612 IP/21/011327 MR/21/036673