Drop files here

SQL upload ( 0 ) x-

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

Full texts id registration_id name dr_id drname mrno opno ipno admission_date patient_src patient_type basic_tarrif_ind cat_desc grade age_yr age_mm age_dd employee_no dept_desc discharge_date sex status grade_code ward_rep_dtm emp_recov_case emp_ref_no emp_ref_no1 emp_ref_no2 bill_payble_by bill_amt ref_no departmnt_desc case_code sec_drname sdr_id thr_drId for_drId nee para remark patient_complaint edd ward_id ward_code ward_desc bill_class room_id room_code room_desc bed_id bed_no bed_status bed_type bed_desc created_date created_by modified_date modified_by ward_time ward_timeprifix bed_charge_limit reg_payment outpatient_refer_id p_package_id info_house_keeping info_ward locationname camp_id surgery anesthesia eye lense patient_cat cat_code reason_for_readmission
1 160 Mr ISU  KHAN DR0127 Dr Upendra Singh MR/18/000160 OP/18/000160 IP/18/000005 2018-02-01 12:33:56 pm O Re NULLAEHB NULL70 0 0 2018-02-07 09:34:58 am M D NULLNULLNULLNULLNULLNULLNULLNULLOPTL04-Opthalmology Observation ss NULLNULLNULLNULL2018-2-01 4 EGWFF EYE GENRAL WARD FF General 10 B ROOM B 37 BED 01 F GEN 2018-02-01 12:44:49 000144 2018-02-11 12:19:19 000001 AM unpaid NULLyes yes AEH NULLss ss right P
2 159 Mrs KESHAWPATI   DR0127 Dr Upendra Singh MR/18/000159 OP/18/000159 IP/18/000006 2018-02-01 02:11:53 pm O Re NULLAEHB NULL75 0 0 2018-02-07 10:09:12 am F D NULLNULLNULLNULLNULLNULLNULLNULLOPTL04-Opthalmology Observation ss NULLNULLNULLNULL2018-2-01 4 EGWFF EYE GENRAL WARD FF General 9 A ROOM A 19 BED 03 F GEN 2018-02-01 14:13:35 000013 2018-02-11 13:03:56 000001 AM paid NULLyes yes AEH NULLIOL003 ss right P
3 167 Mrs SHIV LALI DR0127 Dr Upendra Singh MR/18/000167 OP/18/000167 IP/18/000007 2018-02-01 02:30:27 pm O Re NULLAEHB NULL50 0 0 2018-02-07 11:06:46 am F D NULLNULLNULLNULLNULLNULLNULLNULLOPTL04-Opthalmology Observation ss NULLNULLNULLNULL2018-2-01 4 EGWFF EYE GENRAL WARD FF General 10 B ROOM B 38 BED 02 F GEN 2018-02-01 14:32:13 000013 2018-02-11 12:19:38 000001 AM paid NULLyes yes AEH NULLIOL002 ss right P
4 196 Mrs KOYLA   DR0127 Dr Upendra Singh MR/18/000196 OP/18/000196 IP/18/000008 2018-02-01 02:52:49 pm O Re NULLAEHB NULL75 0 0 2018-02-07 11:07:12 am F D NULLNULLNULLNULLNULLNULLNULLNULLOPTL04-Opthalmology Observation ss NULLNULLNULLNULL2018-2-01 4 EGWFF EYE GENRAL WARD FF General 10 B ROOM B 39 BED 03 F GEN 2018-02-01 14:54:17 000013 2018-02-11 13:06:08 000001 AM unpaid NULLyes yes AEH NULLIOL002 ss left P
5 223 Mrs JASKALA   DR0165 dr Anoop Mishra MR/18/000223 OP/18/000223 IP/18/000010 2018-02-02 11:24:43 am O Re NULLAEHB NULL58 0 0 2018-02-07 11:07:36 am F D NULLNULLNULLNULLNULLNULLNULLNULLOPTL04-Opthalmology Observation ss NULLNULLNULLNULL2018-2-02 4 EGWFF EYE GENRAL WARD FF General 9 A ROOM A 20 BED 04 F GEN 2018-02-02 11:25:31 000013 2018-02-11 12:20:03 000001 AM paid NULLyes yes AEH NULLss ss right P
6 258 Mr NARENDRA BAHADUR SINGH DR0165 dr Anoop Mishra MR/18/000258 OP/18/000259 IP/18/000011 2018-02-02 11:56:55 am O Re NULLAEHB NULL50 0 0 2018-02-07 11:08:37 am M D NULLNULLNULLNULLNULLNULLNULLNULLOPTL04-Opthalmology Observation ss NULLNULLNULLNULL2018-2-02 4 EGWFF EYE GENRAL WARD FF General 10 B ROOM B 41 BED 05 F GEN 2018-02-02 11:58:24 000013 2018-02-11 12:21:29 000001 AM paid NULLyes yes AEH NULLIOL002 ss left P
7 660 Mrs MURTA DEVI DR0165 dr Anoop Mishra MR/18/000660 OP/18/000664 IP/18/000012 2018-02-06 11:22:19 am O Re NULLAEHB NULL65 OPTL04 2018-02-07 11:07:47 am F D NULLNULLNULLNULLNULLNULLNULLNULLOpthalmology Observation ss NULLNULLNULLNULL2018-2-07 4 EGWFF EYE GENRAL WARD FF General 9 A ROOM A 21 BED 05 F GEN 2018-02-06 11:22:51 000013 2018-02-11 12:20:25 000001 AM paid NULLyes yes AEH 0 CAT365 ss left PC P
8 666 Mr SHAKIL  AHMAD DR0127 Dr Upendra Singh MR/18/000666 OP/18/000670 IP/18/000013 2018-02-06 11:41:15 am O Re NULLAEHB NULL55 0 0 2018-02-07 11:07:59 am M D NULLNULLNULLNULLNULLNULLNULLNULLOPTL04-Opthalmology Observation ss NULLNULLNULLNULL2018-2-07 4 EGWFF EYE GENRAL WARD FF General 9 A ROOM A 22 BED 06 F GEN 2018-02-06 11:45:38 000144 2018-02-11 12:20:50 000001 AM paid NULLyes yes AEH NULLIOL002 ss right P
9 672 Mr RAM MILAN   DR0127 Dr Upendra Singh MR/18/000672 OP/18/000676 IP/18/000014 2018-02-06 11:57:50 am O Re NULLAEHB NULL65 0 0 2018-02-07 11:08:22 am M D NULLNULLNULLNULLNULLNULLNULLNULLOPTL04-Opthalmology Observation ss NULLNULLNULLNULL2018-2-06 4 EGWFF EYE GENRAL WARD FF General 9 A ROOM A 23 BED 07 F GEN 2018-02-06 11:59:15 000013 2018-02-11 12:21:11 000001 AM paid NULLyes yes AEH NULLIOL002 ss right P
10 694 Mrs KAILASA DEVI DR0127 Dr Upendra Singh MR/18/000694 OP/18/000698 IP/18/000015 2018-02-06 12:05:05 pm O Re NULLAEHB NULL60 0 0 2018-02-07 11:09:16 am F D NULLNULLNULLNULLNULLNULLNULLNULLOPTL04-Opthalmology Observation ss NULLNULLNULLNULL2018-2-06 4 EGWFF EYE GENRAL WARD FF General 10 B ROOM B 42 BED 06 F GEN 2018-02-06 12:06:07 000013 2018-02-11 12:22:04 000001 AM paid NULLyes yes AEH NULLIOL055 ss left P
11 659 Mr GYANMATI   DR0127 Dr Upendra Singh MR/18/000659 OP/18/000663 IP/18/000016 2018-02-06 12:06:59 pm O Re NULLAEHC NULL55 OPTL04 2018-02-07 11:08:53 am M D NULLNULLNULLNULLNULLNULLNULLNULLOpthalmology Observation ss NULLNULLNULLNULL2018-2-07 4 EGWFF EYE GENRAL WARD FF General 13 CAMP CAMP 1 97 BED 1 F GEN 2018-02-06 12:07:20 000012 2018-02-11 12:21:47 000001 AM unpaid NULLyes yes AEH 0 IOL051 ss right PC P
12 696 Mrs HAMID   DR0127 Dr Upendra Singh MR/18/000696 OP/18/000700 IP/18/000017 2018-02-06 12:08:00 pm O Re NULLAEHC NULL65 OPTL04 2018-02-07 11:09:33 am F D NULLNULLNULLNULLNULLNULLNULLNULLOpthalmology Observation ss NULLNULLNULLNULL2018-2-07 4 EGWFF EYE GENRAL WARD FF General 13 CAMP CAMP 1 98 BED 2 F GEN 2018-02-06 12:08:17 000012 2018-02-11 12:22:24 000001 AM unpaid NULLyes yes AEH 0 IOL051 ss right PC P
13 689 Smt BELA DEVI DR0127 Dr Upendra Singh MR/18/000689 OP/18/000693 IP/18/000018 2018-02-06 12:08:31 pm O Re NULLAEHC NULL75 OPTL04 2018-02-07 11:10:04 am F D NULLNULLNULLNULLNULLNULLNULLNULLOpthalmology Observation ss NULLNULLNULLNULL2018-2-07 4 EGWFF EYE GENRAL WARD FF General 13 CAMP CAMP 1 99 BED 3 F GEN 2018-02-06 12:08:45 000012 2018-02-07 11:25:08 000001 AM unpaid NULLyes yes AEH 0 IOL051 ss right PC P
14 681 Mr JAIRAM   DR0127 Dr Upendra Singh MR/18/000681 OP/18/000685 IP/18/000019 2018-02-06 12:08:55 pm O Re NULLAEHC NULL75 OPTL04 2018-02-07 11:09:48 am M D NULLNULLNULLNULLNULLNULLNULLNULLOpthalmology Observation ss NULLNULLNULLNULL2018-2-07 4 EGWFF EYE GENRAL WARD FF General 13 CAMP CAMP 1 100 BED 4 F GEN 2018-02-06 12:09:08 000012 2018-02-11 12:22:47 000001 AM unpaid NULLyes yes AEH 0 IOL051 ss left PC P
15 678 Mrs ANARA   DR0127 Dr Upendra Singh MR/18/000678 OP/18/000682 IP/18/000020 2018-02-06 12:09:20 pm O Re NULLAEHC NULL60 OPTL04 2018-02-07 11:10:45 am F D NULLNULLNULLNULLNULLNULLNULLNULLOpthalmology Observation ss NULLNULLNULLNULL2018-2-07 4 EGWFF EYE GENRAL WARD FF General 13 CAMP CAMP 1 101 BED 5 F GEN 2018-02-06 12:09:44 000012 2018-02-07 11:24:27 000001 AM unpaid NULLyes yes AEH 0 IOL051 ss left PC P
16 674 Mr PARTAP   DR0127 Dr Upendra Singh MR/18/000674 OP/18/000678 IP/18/000021 2018-02-06 12:10:03 pm O Re NULLAEHC NULL70 OPTL04 2018-02-07 11:10:22 am M D NULLNULLNULLNULLNULLNULLNULLNULLOpthalmology Observation ss NULLNULLNULLNULL2018-2-07 4 EGWFF EYE GENRAL WARD FF General 13 CAMP CAMP 1 102 BED 6 F GEN 2018-02-06 12:10:15 000012 2018-02-07 11:24:49 000001 AM unpaid NULLyes yes AEH 0 IOL051 ss right PC P
17 670 Mrs VIDYA   DR0127 Dr Upendra Singh MR/18/000670 OP/18/000674 IP/18/000022 2018-02-06 12:10:30 pm O Re NULLAEHC NULL60 OPTL04 2018-02-07 11:12:11 am F D NULLNULLNULLNULLNULLNULLNULLNULLOpthalmology Observation ss NULLNULLNULLNULL2018-2-07 4 EGWFF EYE GENRAL WARD FF General 13 CAMP CAMP 1 103 BED 7 F GEN 2018-02-06 12:10:50 000012 2018-02-07 11:21:52 000001 AM unpaid NULLyes yes AEH 0 IOL051 ss left PC P
18 663 Smt PIYARI        DEVI DR0127 Dr Upendra Singh MR/18/000663 OP/18/000667 IP/18/000023 2018-02-06 12:11:00 pm O Re NULLAEHB NULL70 OPTL04 2018-02-07 11:11:19 am F D NULLNULLNULLNULLNULLNULLNULLNULLOpthalmology Observation ss NULLNULLNULLNULL2018-2-07 4 EGWFF EYE GENRAL WARD FF General 10 B ROOM B 43 BED 07 F GEN 2018-02-06 12:11:46 000012 2018-02-07 11:23:38 000001 AM unpaid NULLyes yes AEH 0 IOL051 ss left PC P
19 692 Smt ANARA DEVI DR0127 Dr Upendra Singh MR/18/000692 OP/18/000696 IP/18/000024 2018-02-06 12:18:14 pm O Re NULLAEHC NULL70 OPTL04 2018-02-07 11:11:02 am F D NULLNULLNULLNULLNULLNULLNULLNULLOpthalmology Observation ss NULLNULLNULLNULL2018-2-07 4 EGWFF EYE GENRAL WARD FF General 11 C ROOM C 57 BED 01 F GEN 2018-02-06 12:18:49 000012 2018-02-07 11:24:08 000001 AM unpaid NULLyes yes AEH 0 IOL051 ss right PC P
20 667 Mr GAGANRAM   DR0127 Dr Upendra Singh MR/18/000667 OP/18/000671 IP/18/000025 2018-02-06 12:19:26 pm O Re NULLAEHC NULL55 OPTL04 2018-02-07 11:11:35 am M D NULLNULLNULLNULLNULLNULLNULLNULLOpthalmology Observation ss NULLNULLNULLNULL2018-2-07 4 EGWFF EYE GENRAL WARD FF General 11 C ROOM C 58 BED 02 F GEN 2018-02-06 12:19:42 000012 2018-02-07 11:23:18 000001 AM unpaid NULLyes yes AEH 0 IOL051 ss right PC P
21 685 Smt DAULA   DR0127 Dr Upendra Singh MR/18/000685 OP/18/000689 IP/18/000026 2018-02-06 12:19:53 pm O Re NULLAEHC NULL65 OPTL04 2018-02-07 11:11:54 am F D NULLNULLNULLNULLNULLNULLNULLNULLOpthalmology Observation ss NULLNULLNULLNULL2018-2-07 4 EGWFF EYE GENRAL WARD FF General 11 C ROOM C 59 BED 03 F GEN 2018-02-06 12:20:08 000012 2018-02-07 11:22:57 000001 AM unpaid NULLyes yes AEH 0 IOL051 ss right PC P
22 676 Mr DHANAU   DR0127 Dr Upendra Singh MR/18/000676 OP/18/000680 IP/18/000027 2018-02-06 12:20:20 pm O Re NULLAEHC NULL50 OPTL04 2018-02-07 11:13:16 am M D NULLNULLNULLNULLNULLNULLNULLNULLOpthalmology Observation ss NULLNULLNULLNULL2018-2-07 4 EGWFF EYE GENRAL WARD FF General 11 C ROOM C 60 BED 04 F GEN 2018-02-06 12:20:33 000012 2018-02-07 11:20:47 000001 AM unpaid NULLyes yes AEH 0 IOL051 ss right PC P
23 671 Mrs PHOOLWATI   DR0127 Dr Upendra Singh MR/18/000671 OP/18/000675 IP/18/000028 2018-02-06 12:20:47 pm O Re NULLAEHC NULL65 OPTL04 2018-02-07 11:12:27 am F D NULLNULLNULLNULLNULLNULLNULLNULLOpthalmology Observation ss NULLNULLNULLNULL2018-2-07 4 EGWFF EYE GENRAL WARD FF General 11 C ROOM C 61 BED 05 F GEN 2018-02-06 12:21:01 000012 2018-02-07 11:21:25 000001 AM unpaid NULLyes yes AEH 0 IOL051 ss right PC P
24 679 Smt BHAGIRATI   DR0127 Dr Upendra Singh MR/18/000679 OP/18/000683 IP/18/000029 2018-02-06 12:21:11 pm O Re NULLAEHC NULL70 OPTL04 2018-02-07 11:12:45 am F D NULLNULLNULLNULLNULLNULLNULLNULLOpthalmology Observation ss NULLNULLNULLNULL2018-2-07 4 EGWFF EYE GENRAL WARD FF General 11 C ROOM C 62 BED 06 F GEN 2018-02-06 12:21:24 000012 2018-02-07 11:21:09 000001 AM unpaid NULLyes yes AEH 0 IOL051 ss right PC P
25 711 Mrs RAJPATI   DR0127 Dr Upendra Singh MR/18/000711 OP/18/000715 IP/18/000030 2018-02-06 12:21:57 pm O Re NULLAEHB NULL70 0 0 2018-02-07 11:13:00 am F A NULLNULLNULLNULLNULLNULLNULLNULLOPTL04-Opthalmology Observation ss NULLNULLNULLNULL2018-2-06 4 EGWFF EYE GENRAL WARD FF General 9 A ROOM A 24 BED 08 F GEN 2018-02-06 12:23:58 000144 2018-02-11 13:05:10 000001 AM paid NULLyes yes AEH NULLIOL056 ss right P