Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »View: OPS
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 2.2432 seconds.)
SELECT * FROM `OPS`

order_no mrno patient_no
OR/21/072432 MR/19/043176 IP/21/011312
OR/21/072398 MR/21/022936 IP/21/011309
OR/21/072248 MR/21/031153 IP/21/011302
OR/21/072259 MR/21/031189 IP/21/011303
OR/21/072491 MR/21/034576 IP/21/011342
OR/21/072352 MR/21/035164 IP/21/011307
OR/21/072423 MR/21/035569 IP/21/011310
OR/21/072191 MR/21/035627 IP/21/011301
OR/21/072482 MR/21/035985 IP/21/011339
OR/21/072496 MR/21/036294 IP/21/011343
OR/21/072299 MR/21/036431 IP/21/011305
OR/21/072323 MR/21/036540 IP/21/011306
OR/21/072286 MR/21/036543 IP/21/011304
OR/21/072448 MR/21/036563 IP/21/011316
OR/21/072454 MR/21/036593 IP/21/011318
OR/21/072362 MR/21/036615 IP/21/011308
OR/21/072451 MR/21/036630 IP/21/011317
OR/21/072478 MR/21/036669 IP/21/011336
OR/21/072473 MR/21/036671 IP/21/011332
OR/21/072468 MR/21/036673 IP/21/011327
OR/21/072464 MR/21/036674 IP/21/011325
OR/21/072436 MR/21/036675 IP/21/011314
OR/21/072477 MR/21/036676 IP/21/011335
OR/21/072430 MR/21/036677 IP/21/011311
OR/21/072479 MR/21/036678 IP/21/011337