Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »Table: diagnoses
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 (190 total, Query took 0.0093 seconds.)
SELECT * FROM `diagnoses`

Full texts id icd_code diagnosis_name doctor_name dept_name created_date locationname
33 A18.5+ Tuberculosis of eye Admin Information Technology 0000-00-00 00:00:00 AEH
726 A54.3   Gonococcal infection of eye Admin Information Technology 0000-00-00 00:00:00 AEH
901 C14.2   Malignant neoplasm of Waldeyers ring Admin Information Technology 0000-00-00 00:00:00 AEH
924 D09.2   Carcinoma in situ of eye Admin Information Technology 0000-00-00 00:00:00 AEH
1064 C43.1   Malignant melanoma of eyelid, including canthus Admin Information Technology 0000-00-00 00:00:00 AEH
1075 D03.1   Melanoma in situ of eyelid, including canthus Admin Information Technology 0000-00-00 00:00:00 AEH
1086 C44.1   Malignant neoplasm of skin of eyelid, including ca... Admin Information Technology 0000-00-00 00:00:00 AEH
1099 D04.1   Carcinoma in situ of skin of eyelid, including can... Admin Information Technology 0000-00-00 00:00:00 AEH
1351 C69     Malignant neoplasm of eye and adnexa Admin Information Technology 0000-00-00 00:00:00 AEH
1359 C69.8   Overlapping malignant lesion of eye and adnexa Admin Information Technology 0000-00-00 00:00:00 AEH
1360 C69.9   Malignant neoplasm of eye, unspecified Admin Information Technology 0000-00-00 00:00:00 AEH
1601 D22.1   Melanocytic naevi of eyelid, including canthus Admin Information Technology 0000-00-00 00:00:00 AEH
1611 D23.1   Other benign neoplasms of skin of eyelid, includin... Admin Information Technology 0000-00-00 00:00:00 AEH
1643 D31     Benign neoplasm of eye and adnexa Admin Information Technology 0000-00-00 00:00:00 AEH
1651 D31.9   Benign neoplasm of eye, unspecified Admin Information Technology 0000-00-00 00:00:00 AEH
3163 G93.7   Reyes syndrome Admin Information Technology 0000-00-00 00:00:00 AEH
3281 H40.3   Glaucoma secondary to eye trauma Admin Information Technology 0000-00-00 00:00:00 AEH
3282 H40.4   Glaucoma secondary to eye inflammation Admin Information Technology 0000-00-00 00:00:00 AEH
3283 H40.5   Glaucoma secondary to other eye disorders Admin Information Technology 0000-00-00 00:00:00 AEH
3310 H54.0   Blindness, both eyes Admin Information Technology 0000-00-00 00:00:00 AEH
3311 H54.1   Blindness, one eye, low vision other eye Admin Information Technology 0000-00-00 00:00:00 AEH
3312 H54.2   Low vision, both eyes Admin Information Technology 0000-00-00 00:00:00 AEH
3313 H54.3   Unqualified visual loss, both eyes Admin Information Technology 0000-00-00 00:00:00 AEH
3314 H54.4   Blindness, one eye Admin Information Technology 0000-00-00 00:00:00 AEH
3315 H54.5   Low vision, one eye Admin Information Technology 0000-00-00 00:00:00 AEH