Drop files here

SQL upload ( 0 ) x-

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

Full texts id patient_no patient_name batchdetail_id item_code qty drugissue_id p_pack_id p_pack_amt p_advance p_pack_qty drugissue_detail_id rate created_by created_date locationname
1 OP/17/000406 Mr GOLU  MISHRA 97 PHR/CCN/00106 1.00 2 NULLNULLNULLNULL1 272.00 20 2017-06-30 06:32:50 APH
2 OP/17/000406 Mr GOLU  MISHRA 114 PHR/CCN/00027 1.00 2 NULLNULLNULLNULL2 124.00 20 2017-06-30 06:32:50 APH
3 OP/17/000406 Mr GOLU  MISHRA 68 PHR/CCN/00083 1.00 2 NULLNULLNULLNULL3 267.00 20 2017-06-30 06:32:50 APH
4 OP/17/000406 Mr GOLU  MISHRA 94 PHR/CCN/00104 1.00 2 NULLNULLNULLNULL4 37.50 20 2017-06-30 06:32:50 APH
5 OP/17/000406 Mr GOLU  MISHRA 45 PHR/CCN/00040 2.00 2 NULLNULLNULLNULL5 2.90 20 2017-06-30 06:32:50 APH
6 OP/17/000424 Mr RAHUL KUMAR MISHRA 97 PHR/CCN/00106 1.00 3 NULLNULLNULLNULL6 272.00 20 2017-06-30 08:45:42 APH
7 OP/17/000424 Mr RAHUL KUMAR MISHRA 114 PHR/CCN/00027 1.00 3 NULLNULLNULLNULL7 124.00 20 2017-06-30 08:45:42 APH
8 OP/17/000424 Mr RAHUL KUMAR MISHRA 68 PHR/CCN/00083 1.00 3 NULLNULLNULLNULL8 267.00 20 2017-06-30 08:45:42 APH
9 OP/17/000424 Mr RAHUL KUMAR MISHRA 94 PHR/CCN/00104 1.00 3 NULLNULLNULLNULL9 37.50 20 2017-06-30 08:45:42 APH
10 OP/17/000424 Mr RAHUL KUMAR MISHRA 45 PHR/CCN/00040 2.00 3 NULLNULLNULLNULL10 2.90 20 2017-06-30 08:45:42 APH
11 OP/17/000422 Ms PUSHPA  TIWARI 10 PHR/CCN/00013 4.00 4 NULLNULLNULLNULL11 26.00 20 2017-06-30 09:07:24 APH
12 OP/17/000422 Ms PUSHPA  TIWARI 114 PHR/CCN/00027 5.00 4 NULLNULLNULLNULL12 124.00 20 2017-06-30 09:07:24 APH
13 OP/17/000422 Ms PUSHPA  TIWARI 71 PHR/CCN/00085 6.00 4 NULLNULLNULLNULL13 125.50 20 2017-06-30 09:07:24 APH
14 OP/17/000422 Ms PUSHPA  TIWARI 82 PHR/CCN/00093 5.00 4 NULLNULLNULLNULL14 167.00 20 2017-06-30 09:07:24 APH
15 OP/17/000422 Ms PUSHPA  TIWARI 100 PHR/CCN/00107 2.00 4 NULLNULLNULLNULL15 92.75 20 2017-06-30 09:07:24 APH
16 OP/17/000422 Ms PUSHPA  TIWARI 68 PHR/CCN/00083 13.00 4 NULLNULLNULLNULL16 267.00 20 2017-06-30 09:07:24 APH
17 OP/17/000422 Ms PUSHPA  TIWARI 73 PHR/CCN/00086 4.00 4 NULLNULLNULLNULL17 362.00 20 2017-06-30 09:07:24 APH
18 OP/17/000422 Ms PUSHPA  TIWARI 83 PHR/CCN/00095 16.00 4 NULLNULLNULLNULL18 187.00 20 2017-06-30 09:07:24 APH
19 OP/17/000422 Ms PUSHPA  TIWARI 97 PHR/CCN/00106 9.00 4 NULLNULLNULLNULL19 272.00 20 2017-06-30 09:07:24 APH
20 OP/17/000422 Ms PUSHPA  TIWARI 2 PHR/CCN/00020 1.00 4 NULLNULLNULLNULL20 88.53 20 2017-06-30 09:07:24 APH
21 OP/17/000422 Ms PUSHPA  TIWARI 26 PHR/CCN/00022 2.00 4 NULLNULLNULLNULL21 385.53 20 2017-06-30 09:07:24 APH
22 OP/17/000422 Ms PUSHPA  TIWARI 41 PHR/CCN/00036 1.00 4 NULLNULLNULLNULL22 133.82 20 2017-06-30 09:07:24 APH
23 OP/17/000422 Ms PUSHPA  TIWARI 43 PHR/CCN/00037 5.00 4 NULLNULLNULLNULL23 105.22 20 2017-06-30 09:07:24 APH
24 OP/17/000422 Ms PUSHPA  TIWARI 44 PHR/CCN/00038 4.00 4 NULLNULLNULLNULL24 136.94 20 2017-06-30 09:07:24 APH
25 OP/17/000422 Ms PUSHPA  TIWARI 113 PHR/CCN/00060 3.00 4 NULLNULLNULLNULL25 142.38 20 2017-06-30 09:07:24 APH