Drop files here

SQL upload ( 0 ) x-

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

Full texts id clinical_code clinicalf_name uom doctor_name dept_name created_date locationname
1 R75     Inconclusive laboratory evidence of human immunode... Admin Information Technology 2012-02-17 03:20:09 AEH
2 R00     Abnormalities of heart beat Admin Information Technology 2012-02-17 03:20:09 AEH
3 R00.0   Tachycardia, unspecified Admin Information Technology 2012-02-17 03:20:09 AEH
4 R00.1   Bradycardia, unspecified Admin Information Technology 2012-02-17 03:20:09 AEH
5 R00.2   Palpitations Admin Information Technology 2012-02-17 03:20:09 AEH
6 R00.8   Other abnormalities of heart beat Admin Information Technology 2012-02-17 03:20:09 AEH
7 R01     Cardiac murmurs and other cardiac sounds Admin Information Technology 2012-02-17 03:20:09 AEH
8 R01.0   Benign and innocent cardiac murmurs Admin Information Technology 2012-02-17 03:20:09 AEH
9 R01.1   Cardiac murmur, unspecified Admin Information Technology 2012-02-17 03:20:09 AEH
10 R01.2   Other cardiac sounds Admin Information Technology 2012-02-17 03:20:09 AEH
11 R02     Gangrene, not elsewhere classified Admin Information Technology 2012-02-17 03:20:09 AEH
12 R03     Abnormal blood-pressure reading, without diagnosis Admin Information Technology 2012-02-17 03:20:09 AEH
13 R03.0   Elevated blood-pressure reading, without diagnosis... Admin Information Technology 2012-02-17 03:20:09 AEH
14 R03.1   Nonspecific low blood-pressure reading Admin Information Technology 2012-02-17 03:20:09 AEH
15 R04     Haemorrhage from respiratory passages Admin Information Technology 2012-02-17 03:20:09 AEH
16 R04.0   Epistaxis Admin Information Technology 2012-02-17 03:20:09 AEH
17 R04.1   Hemorrhage from throat Admin Information Technology 2012-02-17 03:20:09 AEH
18 R04.2   Hemoptysis Admin Information Technology 2012-02-17 03:20:09 AEH
19 R04.8   Hemorrhage from other sites in respiratory passage... Admin Information Technology 2012-02-17 03:20:09 AEH
20 R04.9   Hemorrhage from respiratory passages, unspecified Admin Information Technology 2012-02-17 03:20:09 AEH
21 R05     Cough Admin Information Technology 2012-02-17 03:20:09 AEH
22 R06     Abnormalities of breathing Admin Information Technology 2012-02-17 03:20:09 AEH
23 R06.0   Dyspnoea Admin Information Technology 2012-02-17 03:20:09 AEH
24 R06.1   Stridor Admin Information Technology 2012-02-17 03:20:09 AEH
25 R06.2   Wheezing Admin Information Technology 2012-02-17 03:20:09 AEH