Drop files here

SQL upload ( 0 ) x-

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

Full texts id issue_no store_code store_desc issue_date voucher_no patient_type patient_no patient_name issue_type pay_check_flag mrno visit_no prescription_no sex age month day doctor_code doctor_name reason remark authorized_by issued_by payment_status paid_by paid_date given_by given_date remarks upload created_date created_by modified_date modified_by locationname reversal_status
1 IS/17/000001 2017-06-29 00:00:00 DV/17/000001 EX OSR Y PV/17/000001 NULLNULLNULLNULL000001 I NULLNULLNULLNULL2017-06-29 05:52:07 000001 NULLNULLAPH 0
2 IS/17/000002 STRPHY Pharmacy Store 2017-06-30 00:00:00 DV/17/000002 OP OP/17/000406 Mr GOLU  MISHRA WHR Y MR/17/000378 20 PV/17/000002 Male 11 NULLNULLDR0003 Dr Ashutosh Rastogi 000020 I NULLNULLNULLNULLNULL2017-06-30 06:32:50 000020 NULL0 APH 0
3 IS/17/000003 STRPHY Pharmacy Store 2017-06-30 00:00:00 DV/17/000003 OP OP/17/000424 Mr RAHUL KUMAR MISHRA WHR Y MR/17/000396 8 PV/17/000003 Male 28 NULLNULLDR0004 Dr Vipin Kumar Singh 000020 I NULLNULLNULLNULLNULL2017-06-30 08:45:42 000020 NULL0 APH 0
4 IS/17/000004 STRPHY Pharmacy Store 2017-06-30 00:00:00 DV/17/000004 OP OP/17/000422 Ms PUSHPA  TIWARI WHR Y MR/17/000394 6 PV/17/000004 Female 21 NULLNULLDR0003 Dr Ashutosh Rastogi 000020 I NULLNULLNULLNULLNULL2017-06-30 09:07:24 000020 NULL0 APH 0
5 IS/17/000005 STRPHY Pharmacy Store 2017-06-30 00:00:00 DV/17/000005 OP OP/17/000421 Mr RAVINDARA  YADAV WHR Y MR/17/000393 5 PV/17/000005 Male 23 NULLNULLDR0003 Dr Ashutosh Rastogi 000020 I NULLNULLNULLNULLNULL2017-06-30 09:26:42 000020 NULL0 APH 0
6 IS/17/000006 STRPHY Pharmacy Store 2017-06-30 00:00:00 DV/17/000006 OP OP/17/000420 Mr RAM LAL  YADAV WHR Y MR/17/000392 4 PV/17/000006 Male 22 NULLNULLDR0003 Dr Ashutosh Rastogi 000020 I NULLNULLNULLNULLNULL2017-06-30 09:30:24 000020 NULL0 APH 0
7 IS/17/000007 STRPHY Pharmacy Store 2017-06-30 00:00:00 DV/17/000007 OP OP/17/000435 Mr ROHIT KUMAR PANDEY WHR Y MR/17/000407 15 PV/17/000007 Male 25 NULLNULLDR0004 Dr Vipin Kumar Singh 000020 I NULLNULLNULLNULLNULL2017-06-30 12:28:43 000020 NULL0 APH 0
8 IS/17/000008 STRPHY Pharmacy Store 2017-06-30 00:00:00 DV/17/000008 OP OP/17/000438 Mr BAIJNATH KUMAR SHARMA WHR Y MR/17/000410 13 PV/17/000008 Male 22 NULLNULLDR0003 Dr Ashutosh Rastogi 000020 I NULLNULLNULLNULLNULL2017-06-30 12:35:56 000020 NULL0 APH 0
9 IS/17/000009 STRPHY Pharmacy Store 2017-07-01 00:00:00 DV/17/000009 EX 417553 WHR Y PV/17/000009 NULLNULLNULLNULL000020 I NULLNULLNULLNULL2017-07-01 04:32:33 000020 NULLNULLAPH 0
10 IS/17/000010 STRPHY Pharmacy Store 2017-07-01 00:00:00 DV/17/000010 EX AHAMADI BANO-409111 WHR Y PV/17/000010 NULLNULLNULLNULL000020 I NULLNULLNULLNULL2017-07-01 04:40:20 000020 NULLNULLAPH 0
11 IS/17/000011 STRPHY Pharmacy Store 2017-07-01 00:00:00 DV/17/000011 OP OP/17/000193 Mr raj   WHR Y MR/17/000214 3 PV/17/000011 Male 22 NULLNULLDR0004 Dr Vipin Kumar Singh 000020 I NULLNULLNULLNULLNULL2017-07-01 04:43:11 000020 NULL0 APH 0
12 IS/17/000012 STRPHY Pharmacy Store 2017-07-01 00:00:00 DV/17/000012 OP OP/17/000391 Mrs ANJU   WHR Y MR/17/000363 6 PV/17/000012 Female 45 NULLNULLDR0003 Dr Ashutosh Rastogi 000020 I NULLNULLNULLNULLNULL2017-07-01 04:45:26 000020 NULL0 APH 0
13 IS/17/000013 STRPHY Pharmacy Store 2017-07-01 00:00:00 DV/17/000013 OP OP/17/000347 Mr GEETA   WHR Y MR/17/000331 9 PV/17/000013 Male 26 NULLNULLDR0003 Dr Ashutosh Rastogi 000020 I NULLNULLNULLNULLNULL2017-07-01 04:48:04 000020 NULL0 APH 0
14 IS/17/000014 STRPHY Pharmacy Store 2017-07-01 00:00:00 DV/17/000014 OP OP/17/000214 Ms SADRUN NISHA   WHR Y MR/17/000235 1 PV/17/000014 Female 16 NULLNULLDR0003 Dr Ashutosh Rastogi 000020 I NULLNULLNULLNULLNULL2017-07-01 04:51:07 000020 NULL0 APH 0
15 IS/17/000015 STRPHY Pharmacy Store 2017-07-01 00:00:00 DV/17/000015 OP OP/17/000428 Ms JAIBUL NISHA WHR Y MR/17/000400 10 PV/17/000015 Female 19 NULLNULLDR0004 Dr Vipin Kumar Singh 000020 I NULLNULLNULLNULLNULL2017-07-01 04:53:07 000020 NULL0 APH 0
16 IS/17/000016 STRPHY Pharmacy Store 2017-07-01 00:00:00 DV/17/000016 EX RAM JAG-417881 WHR Y PV/17/000016 NULLNULLNULLNULL000020 I NULLNULLNULLNULL2017-07-01 04:55:03 000020 NULLNULLAPH 0
17 IS/17/000017 STRPHY Pharmacy Store 2017-07-01 00:00:00 DV/17/000017 EX SAZIDA WHR Y PV/17/000017 NULLNULLNULLNULL000020 I NULLNULLNULLNULL2017-07-01 04:56:40 000020 NULLNULLAPH 0
18 IS/17/000018 STRPHY Pharmacy Store 2017-07-01 00:00:00 DV/17/000018 EX FAGU LAL WHR Y PV/17/000018 NULLNULLNULLNULL000020 I NULLNULLNULLNULL2017-07-01 04:58:52 000020 NULLNULLAPH 0
19 IS/17/000019 STRPHY Pharmacy Store 2017-07-01 00:00:00 DV/17/000019 EX GANGOTRI DEVI WHR Y PV/17/000019 NULLNULLNULLNULL000020 I NULLNULLNULLNULL2017-07-01 05:01:46 000020 NULLNULLAPH 0
20 IS/17/000020 STRPHY Pharmacy Store 2017-07-01 00:00:00 DV/17/000020 EX ADITYA KUMAR WHR Y PV/17/000020 NULLNULLNULLNULL000020 I NULLNULLNULLNULL2017-07-01 05:04:36 000020 NULLNULLAPH 0
21 IS/17/000021 STRPHY Pharmacy Store 2017-07-01 00:00:00 DV/17/000021 EX MITHU WHR Y PV/17/000021 NULLNULLNULLNULL000020 I NULLNULLNULLNULL2017-07-01 05:07:29 000020 NULLNULLAPH 0
22 IS/17/000022 STRPHY Pharmacy Store 2017-07-01 00:00:00 DV/17/000022 EX RAM VILAS WHR Y PV/17/000022 NULLNULLNULLNULL000020 I NULLNULLNULLNULL2017-07-01 05:10:21 000020 NULLNULLAPH 0
23 IS/17/000023 STRPHY Pharmacy Store 2017-07-01 00:00:00 DV/17/000023 EX ASHOK KUMARI WHR Y PV/17/000023 NULLNULLNULLNULL000020 I NULLNULLNULLNULL2017-07-01 05:12:01 000020 NULLNULLAPH 0
24 IS/17/000024 STRPHY Pharmacy Store 2017-07-01 00:00:00 DV/17/000024 EX ASHA SINGH WHR Y PV/17/000024 NULLNULLNULLNULL000020 I NULLNULLNULLNULL2017-07-01 05:13:33 000020 NULLNULLAPH 0
25 IS/17/000025 STRPHY Pharmacy Store 2017-07-01 00:00:00 DV/17/000025 EX INDRA VIJAY WHR Y PV/17/000025 NULLNULLNULLNULL000020 I NULLNULLNULLNULL2017-07-01 05:16:50 000020 NULLNULLAPH 0