将文件拖动至此

SQL upload ( 0 ) x-

服务器: localhost »数据库: hmis »表: ipadmissions
页面相关设置点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 记录数: 用时:
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库: 查询时间:

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 Whether a user should be displayed a "show all (rows)" button.
文档 浏览结果集时显示的行数。若结果集总行数超过该值,将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序,其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头,要禁止此功能请设为 0
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 61306 行, 查询花费 0.0426 秒。)
SELECT * FROM `ipadmissions`

完整内容 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