Drop files here

SQL upload ( 0 ) x-

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

Full texts id patient_no mrno counselling_id operation_no duno dsp_no patient_cat op_date fst_drname sergn_drname surgery anesthesia anaesthesist techinician ot_code iol_power iol_type eye lense remark op_cat created_by created_date modified_date modified_by locationname
1 IP/18/000012 MR/18/000660 7 ON/18/000001 BN/18/000001 DSP/18/000001 P 2018-02-06 DR0165 DR0127 IOL005 ANEGA OT1 22.5 PC left PC cataract 000136 2018-02-06 15:00:49 2018-03-22 17:00:10 000167 AEH
2 IP/18/000018 MR/18/000689 15 ON/18/000002 BN/18/000002 DSP/18/000002 P 2018-02-06 DR0127 DR0165 IOL055 ANEGA OT1 20.0 PC right PC cataract 000167 2018-02-06 18:00:59 NULLNULLAEH
3 IP/18/000024 MR/18/000692 21 ON/18/000003 BN/18/000003 DSP/18/000003 P 2018-02-06 DR0127 DR0165 IOL055 ANEGA OT1 24.5 PC left PC cataract 000167 2018-02-06 18:00:08 NULLNULLAEH
4 IP/18/000029 MR/18/000679 23 ON/18/000004 BN/18/000004 DSP/18/000004 P 2018-02-06 DR0127 DR0146 IOL055 ANEGA OT1 23.5 PC right PC cataract 000167 2018-02-06 18:00:47 NULLNULLAEH
5 IP/18/000026 MR/18/000685 22 ON/18/000005 BN/18/000005 DSP/18/000005 P 2018-02-06 DR0127 DR0146 IOL055 ANEGA OT1 22.0 PC right PC cataract 000167 2018-02-06 18:00:29 NULLNULLAEH
6 IP/18/000016 MR/18/000659 28 ON/18/000006 BN/18/000006 DSP/18/000006 P 2018-02-06 DR0127 DR0146 IOL055 ANEGA OT1 25.0 PC right PC cataract 000167 2018-02-06 18:00:55 NULLNULLAEH
7 IP/18/000017 MR/18/000696 14 ON/18/000007 BN/18/000007 DSP/18/000007 P 2018-02-06 DR0127 DR0165 IOL055 ANEGA OT1 21.0 PC right PC cataract 000167 2018-02-06 18:00:22 NULLNULLAEH
8 IP/18/000028 MR/18/000671 25 ON/18/000008 BN/18/000008 DSP/18/000008 P 2018-02-06 DR0127 DR0165 IOL055 ANEGA OT1 21.0 PC right PC cataract 000167 2018-02-06 18:00:55 NULLNULLAEH
9 IP/18/000027 MR/18/000676 24 ON/18/000009 BN/18/000009 DSP/18/000009 P 2018-02-06 DR0127 DR0127 IOL055 ANEGA OT1 22.0 PC right PC cataract 000167 2018-02-06 18:00:24 NULLNULLAEH
10 IP/18/000020 MR/18/000678 17 ON/18/000010 BN/18/000010 DSP/18/000010 P 2018-02-06 DR0127 DR0165 IOL055 ANEGA OT1 24.5 PC left PC cataract 000167 2018-02-06 18:00:50 NULLNULLAEH
11 IP/18/000019 MR/18/000681 16 ON/18/000011 BN/18/000011 DSP/18/000011 P 2018-02-06 DR0127 DR0146 IOL055 ANEGA OT1 21.0 PC left PC cataract 000167 2018-02-06 18:00:28 NULLNULLAEH
12 IP/18/000022 MR/18/000670 19 ON/18/000012 BN/18/000012 DSP/18/000012 P 2018-02-06 DR0127 DR0165 IOL055 ANEGA OT1 18.5 PC left PC cataract 000167 2018-02-06 18:00:56 NULLNULLAEH
13 IP/18/000023 MR/18/000663 20 ON/18/000013 BN/18/000013 DSP/18/000013 P 2018-02-06 DR0127 DR0165 IOL055 ANEGA OT1 23.0 PC left PC cataract 000167 2018-02-06 18:00:37 NULLNULLAEH
14 IP/18/000021 MR/18/000674 18 ON/18/000014 BN/18/000014 DSP/18/000014 F 2018-02-06 DR0127 DR0146 IOL055 ANEGA OT1 20.5 PC right PC cataract 000167 2018-02-06 18:00:19 NULLNULLAEH
15 IP/18/000025 MR/18/000667 26 ON/18/000015 BN/18/000015 DSP/18/000015 F 2018-02-06 DR0127 DR0146 IOL055 ANEGA OT1 24.0 PC right PC cataract 000167 2018-02-06 18:00:51 NULLNULLAEH
16 IP/18/000055 MR/18/000816 78 ON/18/000016 BN/18/000016 DSP/18/000016 F 2018-02-07 DR0127 DR0145 IOL055 ANEGA OT1 22.0 pc right PC cataract 000167 2018-02-07 15:00:00 NULLNULLAEH
17 IP/18/000056 MR/18/000818 79 ON/18/000017 BN/18/000017 DSP/18/000017 F 2018-02-07 DR0127 DR0145 IOL055 ANEGA OT1 21.0 PC right PC cataract 000167 2018-02-07 15:00:12 NULLNULLAEH
18 IP/18/000057 MR/18/000820 80 ON/18/000018 BN/18/000018 DSP/18/000018 F 2018-02-07 DR0127 DR0146 IOL055 ANEGA OT1 22.0 PC left PC cataract 000167 2018-02-07 15:00:08 NULLNULLAEH
19 IP/18/000058 MR/18/000822 81 ON/18/000019 BN/18/000019 DSP/18/000019 F 2018-02-07 DR0127 DR0164 IOL055 ANEGA OT1 24.0 PC left PC cataract 000167 2018-02-07 15:00:10 NULLNULLAEH
20 IP/18/000059 MR/18/000936 82 ON/18/000020 BN/18/000020 DSP/18/000020 F 2018-02-07 DR0127 DR0164 IOL055 ANEGA OT1 25.0 PC right PC cataract 000167 2018-02-07 15:00:15 NULLNULLAEH
21 IP/18/000060 MR/18/000934 84 ON/18/000021 BN/18/000021 DSP/18/000021 F 2018-02-07 DR0127 DR0164 IOL055 ANEGA OT1 21.0 PC left PC cataract 000167 2018-02-07 15:00:13 NULLNULLAEH
22 IP/18/000061 MR/18/000921 85 ON/18/000022 BN/18/000022 DSP/18/000022 F 2018-02-07 DR0127 DR0164 IOL055 ANEGA OT1 23.0 PC right PC cataract 000167 2018-02-07 15:00:38 NULLNULLAEH
23 IP/18/000032 MR/18/000910 97 ON/18/000023 BN/18/000023 DSP/18/000023 F 2018-02-07 DR0127 DR0164 IOL055 ANEGA OT1 PC PC right PC cataract 000167 2018-02-07 15:00:37 NULLNULLAEH
24 IP/18/000033 MR/18/000896 91 ON/18/000024 BN/18/000024 DSP/18/000024 F 2018-02-07 DR0127 DR0146 IOL055 ANEGA OT1 20.0 PC left PC cataract 000167 2018-02-07 15:00:23 NULLNULLAEH
25 IP/18/000034 MR/18/000907 89 ON/18/000025 BN/18/000025 DSP/18/000025 F 2018-02-07 DR0127 DR0146 IOL055 ANEGA OT1 19.0 PC left PC cataract 000167 2018-02-07 15:00:12 NULLNULLAEH