Drop files here

SQL upload ( 0 ) x-

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

Full texts id doctorconsultation_id dr_id name dept_desc value uom slottime consult_amount no_of_days no_of_free_visits created_date created_by modified_date modified_by locationname
1 1 DR0127 Dr Upendra Singh Opthalmology NULLNULL10 0.00 15 10 2018-01-31 01:07:52 000001 2018-12-05 10:54:45 000002 AEH
2 1 DR0145 Dr Alok kumar Opthalmology NULLNULL10 0.00 15 10 2018-01-31 01:07:52 000001 2018-12-05 10:54:59 000002 AEH
3 1 DR0146 Dr Amit verma Opthalmology NULLNULL10 0.00 15 10 2018-01-31 01:07:52 000001 2018-12-05 10:55:12 000002 AEH
4 1 DR0165 dr Anoop Mishra Opthalmology NULLNULL10 0.00 15 10 2018-01-31 01:07:52 000001 2018-12-05 10:55:59 000002 AEH
5 1 DR0197 Dr. VANKATESH KUMAR SRIVASTAVA Opthalmology NULLNULL5 0.00 15 10 2018-01-31 01:07:52 000001 2019-06-15 12:22:15 000002 AHB
6 2 DR0127 Dr Upendra Singh Opthalmology NULLNULL10 0.00 15 10 2018-01-31 01:09:14 000001 2018-12-05 10:39:55 000002 AEH
7 2 DR0145 Dr Alok kumar Opthalmology NULLNULL10 0.00 NULLNULL2018-01-31 01:09:14 000001 NULLNULLAPH
8 2 DR0146 Dr Amit verma Opthalmology NULLNULL10 0.00 15 10 2018-01-31 01:09:14 000001 2018-12-05 10:54:16 000002 AEH
9 2 DR0164 Dr Aakanksha Gehra Opthalmology NULLNULL5 0.00 15 10 2018-01-31 01:09:14 000001 2018-12-05 10:56:29 000002 AEH
10 2 DR0165 Anoop Mishra Opthalmology NULLNULL5 0.00 NULLNULL2018-01-31 01:09:14 000001 NULLNULLAPH
11 3 DR0197 Dr. VANKATESH KUMAR SRIVASTAVA Opthalmology NULLNULL5 0.00 15 10 2018-06-06 12:03:23 000002 2019-06-15 12:24:49 000002 AEH
12 3 DR0170 dr Arun Kumar Pathak Opthalmology NULLNULL5 0.00 3 15 2018-06-06 12:03:23 000002 NULLNULLAEH
13 4 DR0169 Deeksha kesarwani Opthalmology NULLNULL5 0.00 3 15 2018-06-06 12:04:36 000002 NULLNULLAEH
14 4 DR0170 dr Arun Kumar Pathak Opthalmology NULLNULL5 0.00 3 15 2018-06-06 12:04:36 000002 NULLNULLAEH
15 5 DR0169 Deeksha kesarwani Opthalmology NULLNULL5 0.00 3 15 2018-06-06 12:05:40 000002 NULLNULLAEH
16 5 DR0170 dr Arun Kumar Pathak Opthalmology NULLNULL5 0.00 3 15 2018-06-06 12:05:40 000002 NULLNULLAEH
17 6 DR0169 Deeksha kesarwani Opthalmology NULLNULL5 0.00 3 15 2018-06-06 12:06:36 000002 NULLNULLAEH
18 6 DR0170 dr Arun Kumar Pathak Opthalmology NULLNULL5 0.00 3 15 2018-06-06 12:06:36 000002 NULLNULLAEH
19 7 DR0171 Dr. Kirti Tiwari Opthalmology NULLNULL5 0.00 15 3 2018-08-18 05:14:13 000002 NULLNULLAEH
20 7 DR0172 Dr. Ankita Sinha Opthalmology NULLNULL5 0.00 15 3 2018-08-18 05:14:13 000002 2018-09-20 10:37:06 000001 AHB
21 7 DR0173 Dr. Praveer Kumar Srivastava Opthalmology NULLNULL5 0.00 15 3 2018-08-18 05:14:13 000002 NULLNULLAEH
22 7 DR0174 Dr. Saurav Agarwal Opthalmology NULLNULL5 0.00 15 3 2018-08-18 05:14:13 000002 NULLNULLAEH
23 7 DR0175 Dr. Shinde Kiran Ankushrao Opthalmology NULLNULL5 0.00 15 3 2018-08-18 05:14:13 000002 NULLNULLAEH
24 8 DR0171 Dr. Kirti Tiwari Opthalmology NULLNULL5 0.00 15 3 2018-08-18 05:15:13 000002 NULLNULLAEH
25 8 DR0172 Dr. Ankita Sinha Opthalmology NULLNULL5 0.00 15 3 2018-08-18 05:15:13 000002 NULLNULLAEH