Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »Table: batchdetails
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query
x
 
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
xxxxxxxxxx
 
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 (13962 total, Query took 0.0007 seconds.)
SELECT * FROM `batchdetails`
SELECT * FROM `batchdetails`

Full texts id store_code item_code item_desc batch_no qty manufacturing_date expire_date uom sale_base_rate final_sale_rate mrp created created_by modified modified_by locationname
1 STRPHY PHR/CCN/00002 ACIVIR -400 DT SA64927 0 2016-09-01 2019-08-31 TAB NULLNULL11.99 2017-06-28 17:51:37 9 NULLNULLNULL
2 STRPHY PHR/CCN/00020 ACULAR-LS E/D PT0002 0 2016-08-01 2018-07-31 NULLNULL88.53 2017-06-28 17:51:37 9 NULLNULLNULL
4 STRPHY PHR/CCN/00010 PT0169 0 2017-03-01 2019-08-30 NULLNULL333.96 2017-06-28 17:51:37 9 NULLNULLNULL
5 STRPHY PHR/CCN/00011 6080 0 2017-02-01 2018-07-31 NULLNULL150.51 2017-06-28 17:51:37 9 NULLNULLNULL
6 STRPHY PHR/CCN/00009 PT0062 0 2017-03-01 2019-02-28 NULLNULL333.97 2017-06-28 17:51:37 9 NULLNULLNULL
7 STRPHY PHR/CCN/00011 5854 0 2016-02-01 2017-07-31 NULLNULL136.96 2017-06-28 17:51:40 9 NULLNULLNULL
8 STRPHY PHR/CCN/00012 SA65842 0 2016-11-01 2019-10-31 NULLNULL2.45 2017-06-28 17:51:40 9 NULLNULLNULL
9 STRPHY PHR/CCN/00013 AD0267A 0 2017-01-01 2019-12-31 NULLNULL26.00 2017-06-28 18:14:10 9 NULLNULLNULL
10 STRPHY PHR/CCN/00013 AD0036K 0 2016-11-01 2019-10-31 NULLNULL26.00 2017-06-28 18:14:10 9 NULLNULLNULL
11 STRPHY PHR/CCN/00048 AQUASOL-A CAP 49000797 0 2016-06-01 2017-08-31 NULLNULL27.00 2017-06-28 18:25:03 9 NULLNULLNULL
12 STRPHY PHR/CCN/00015 SA62221 0 2016-04-01 2019-03-31 NULLNULL5.35 2017-06-28 18:25:03 9 NULLNULLNULL
13 STRPHY PHR/CCN/00015 SA65548 0 2016-10-01 2019-09-30 NULLNULL5.35 2017-06-28 18:25:03 9 NULLNULLNULL
14 STRPHY PHR/CCN/00015 SA64008 0 2016-06-01 2019-05-31 NULLNULL5.35 2017-06-28 18:25:03 9 NULLNULLNULL
15 STRPHY PHR/CCN/00015 SA62860 0 2016-06-01 2019-05-31 NULLNULL5.35 2017-06-28 18:25:03 9 NULLNULLNULL
16 STRPHY PHR/CCN/00015 SA65148 0 2016-09-01 2019-08-31 NULLNULL5.35 2017-06-28 18:25:03 9 NULLNULLNULL
17 STRPHY PHR/CCN/00015 SA64365 0 2016-08-01 2019-07-31 NULLNULL5.35 2017-06-28 18:25:04 9 NULLNULLNULL
18 STRPHY PHR/CCN/00124 AS1606 -3 2017-03-01 2019-02-28 NULLNULL15.20 2017-06-28 19:15:30 9 NULLNULLNULL
19 STRPHY PHR/CCN/00018 CARPINOL E/D CL-1504 0 2015-10-01 2017-09-30 NULLNULL51.50 2017-06-28 19:15:30 9 NULLNULLNULL
20 STRPHY PHR/CCN/00018 CARPINOL E/D CL-1603 0 2016-08-01 2018-07-31 NULLNULL51.50 2017-06-28 19:15:30 9 NULLNULLNULL
21 STRPHY PHR/CCN/00018 CARPINOL E/D CL-1602 0 2016-07-01 2018-06-30 NULLNULL51.50 2017-06-28 19:15:30 9 NULLNULLNULL
22 STRPHY PHR/CCN/00021 CIPLOX-500 TAB SB60420 0 2016-12-01 2019-11-30 NULLNULL3.47 2017-06-28 19:15:30 9 NULLNULLNULL
23 STRPHY PHR/CCN/00019 CHLOROCOL-H E/O 6087 0 2017-03-01 2019-02-28 NULLNULL70.00 2017-06-28 19:15:30 9 NULLNULLNULL
24 STRPHY PHR/CCN/00019 CHLOROCOL-H E/O 6112 0 2017-04-01 2019-03-31 NO NULLNULL76.93 2017-06-28 19:15:30 9 NULLNULLNULL
25 STRPHY PHR/CCN/00021 CIPLOX-500 TAB SB70219 0 2017-03-01 2020-02-28 NULLNULL3.54 2017-06-28 19:15:30 9 NULLNULLNULL
26 STRPHY PHR/CCN/00022 COMBIGAN E/D PT0001 0 2016-09-01 2018-08-31 NULLNULL385.53 2017-06-28 19:15:30 9 NULLNULLNULL