Drop files here

SQL upload ( 0 ) x-

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

Full texts id counter_master_id counter_code counter_des employee_master_id empid emp_name created_date created_by modified_date modified_by locationname
1 5 PH01 Pharmacy Counter 1 20 000020 Amit Mishra 2017-06-10 04:23:29 1 0000-00-00 00:00:00 0 AEH
2 6 PH02 Pharmacy Counter 2 28 000028 Satendra Kumar 2017-06-13 00:50:30 1 2017-06-13 07:33:26 1 AEH
3 9 OP01 Optical Counter 1 27 000027 Krishna Kumar Gupta 2017-06-14 04:15:51 1 2017-06-14 09:46:55 1 AEH
4 10 OP02 Optical Counter 2 23 000023 Deepak Sharma 2017-06-14 05:46:51 1 0000-00-00 00:00:00 0 AEH
5 1 FD01 Registration Counter 1 19 000013 Shraddha Mishra 2017-06-14 05:47:16 1 2017-10-04 05:54:18 2 AEH
7 5 PH01 Pharmacy Counter 1 77 000077 sanjay shrivastav 2017-06-30 01:35:32 1 0000-00-00 00:00:00 0 AEH
12 7 PH03 Pharmacy Counter 3 25 000025 Kuldeep Tiwari 2017-06-30 23:59:43 1 0000-00-00 00:00:00 0 AEH
13 9 OP01 Optical Counter 1 27 000027 Krishna Kumar Gupta 2017-07-01 01:55:24 1 0000-00-00 00:00:00 0 AEH
14 14 VI01 Vision Counter1 50 000050 Pankaj Gaur 2017-07-01 05:40:53 1 2018-12-01 09:15:54 1 AEH
15 8 PH04 Pharmacy Counter 4 29 000029 Pradeep Chandra 2017-07-06 01:12:25 1 0000-00-00 00:00:00 0 AEHB
21 15 VCK01 Vision Center Kumarganj 49 000049 Pradeep Verma 2017-07-13 05:38:23 1 0000-00-00 00:00:00 0 AEH
22 16 VCT01 Vision Center Tanda 49 000049 Pradeep Verma 2017-07-13 05:38:23 1 2018-03-14 10:04:50 1 APH
23 17 PHK01 Pharmacy Counter Khalilabad 120 000120 pradeep yadav 2017-09-16 00:23:12 1 0000-00-00 00:00:00 0 AEH
24 3 Regist Registration Counter 4 17 000011 Sachin Pandey 2017-10-04 00:11:25 2 2018-04-30 08:09:05 1 AEH
25 27 Vision Vision Counter1 137 000137 sarvjeet verma 2017-10-12 03:44:18 2 2023-03-11 07:09:52 218 AEH
26 18 FD05 Registration Counter Basti 159 000159 Raj Laxmi 2017-11-10 23:09:27 1 0000-00-00 00:00:00 0 AEH
27 17 PHK01 Pharmacy Counter Khalilabad 160 000160 Vivek Kumar 2017-11-26 22:49:44 1 0000-00-00 00:00:00 0 AEH
28 17 PHK01 Pharmacy Counter Khalilabad 127 000127 Ram Bachan 2018-01-02 06:23:52 1 0000-00-00 00:00:00 0 APH
29 2 FD02 Registration Counter 2 144 000144 Poonam Mishra 2018-01-31 00:13:21 1 0000-00-00 00:00:00 0 APH
30 19 CRC01 CAMP REGISTRATION 1 83 000083 Ankur Tripathi 2018-02-06 04:31:29 1 2018-08-06 10:08:36 1 AEH
31 20 CRC02 CAMP REGISTRATION  2 83 000083 Amit Pandey 2018-03-01 04:56:17 1 2018-08-06 10:09:28 1 AEH
32 16 VCT01 Vision Center Tanda 49 000049 Pradeep Verma 2018-03-14 10:45:34 1 0000-00-00 00:00:00 0 VCT
33 17 PHK01 Pharmacy Counter Khalilabad 123 000123 Admin 2018-04-20 07:05:48 2 2020-07-24 09:08:12 218 AEH
34 17 PHK01 Pharmacy Counter Khalilabad 174 000174 annu dubey 2018-04-20 08:50:38 1 0000-00-00 00:00:00 0 AEHK
36 6 PH02 Pharmacy Counter 2 167 000167 Rohit Kumar 2018-07-11 10:31:19 2 0000-00-00 00:00:00 0 AEH