Drop files here

SQL upload ( 0 ) x-

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

Full texts id camp_code camp_name start_mrno camptype_id camp_date close_date surgery_date state district org_auth place op surgery sponsor created created_by modified modified_by category_master_id
28 FAZ03( S.G.J.V.KHUDIPUR HAIRIGTANGANJ FAIZABAD NULL2 2018-02-11 2018-02-13 2018-02-12 40 23 1 S.G.J.V.KHUDIPUR HAIRIGTANGANJ FAIZABAD 40 25 SHITLA PRASAD 2018-02-12 08:00:34 000083 2018-02-12 08:00:34 NULL2
21 sul01( P.V. UGHARPUR, JAISINGH PUR, SULTANPUR NULL1 2018-02-06 2018-02-08 2018-02-07 40 68 1 P.V. UGHARPUR, JAISINGH PUR, SULTANPUR 35 23 2018-02-06 17:00:55 000001 2018-02-07 10:00:43 000083 2
22 SUL002 P.V. BADUNADEEH MOTIGARPUR-SULTANPUR NULL2 2018-02-06 2018-02-08 2018-02-07 40 68 1 P.V. BADUNADEEH MOTIGARPUR-SULTANPUR 60 35 LALJI YADAV 2018-02-06 18:00:16 000083 2018-02-07 16:00:37 000083 2
25 FAZ01 RAJA HATIMDHAM TAKSAL FAIZABAD NULL1 2018-02-08 2018-02-09 2018-02-08 40 23 1 RAJA HATIMDHAM TAKSAL FAIZABAD 500 30 2018-02-08 15:00:28 000083 2018-02-08 15:57:28 NULL2
24 AMB02( P.V.KUDIYA CHITAUNA KATEHARI AMBEDKARNAGAR NULL1 2018-02-07 2018-02-09 2018-02-08 40 4 1 P.V.KUDIYA CHITAUNA KATEHARI AMBEDKARNAGAR 25 21 2018-02-07 16:00:25 000083 2018-02-07 16:42:25 NULL2
26 FAZ02( P.V.KISANGANJ BIKAPUR FAIZABAD NULL1 2018-02-08 2018-02-10 2018-02-09 40 23 1 P.V.KISANGANJ BIKAPUR FAIZABAD 2018-02-08 16:00:17 000083 2018-02-08 16:32:17 NULL2
27 SUL03( J.H.MALIKPUR NONRA AKHANDNAGAR SULTANPUR NULL1 2018-02-11 2018-02-13 2018-02-12 40 68 1 J.H.MALIKPUR NONRA AKHANDNAGAR SULTANPUR 1OO 5O 2018-02-11 13:00:46 000083 2018-02-11 13:18:46 NULL2
20 AMB01( P.V. HAJPURA, JALALPUR, AMBEDKAR NAGAR NULL2 2018-02-06 2018-02-06 2018-02-06 40 4 1 P.V. HAJPURA, JALALPUR, AMBEDKAR NAGAR 50 15 GRAM PRADHAN 2018-02-06 09:00:27 000001 2018-02-06 09:55:27 NULL2
29 AMB03 P.V.Atampur Katehari Ambedkarnagar NULL1 2018-02-12 2018-02-14 2018-02-13 40 4 1 P.V.Atampur Katehari Ambedkarnagar 20 10 2018-02-12 12:00:35 000083 2018-02-12 12:00:09 000083 2
30 AMB04( P.V. LALAPUR, AKBARPUR, AMBEDKAR NAGAR NULL1 2018-02-12 2018-02-13 2018-02-13 40 4 1 P.V. LALAPUR, AKBARPUR, AMBEDKAR NAGAR 50 35 2018-02-12 17:00:55 000047 2018-02-13 10:00:48 000047 2
31 AMB05( P.V.ASHRAFPUR BARVA KATEHARI AMBEDKARNAGAR NULL1 2018-02-13 2018-02-15 2018-02-14 40 4 1 P.V.ASHRAFPUR BARVA KATEHARI AMBEDKARNAGAR 60 40 2018-02-13 09:00:12 000083 2018-02-13 09:18:12 NULL2
32 FAZ04 S.K.BODHIPUR MAYA FAIZABAD NULL1 2018-02-13 2018-02-14 2018-02-14 40 23 1 S.K.BODHIPUR MAYA FAIZABAD 70 50 2018-02-13 09:00:15 000083 2018-02-13 09:23:15 NULL2
33 SUL04( P.V.BHIURA AKHANDNAGAR SULTANPUR NULL1 0000-00-00 2018-02-15 2018-02-14 40 68 1 P.V.BHIURA AKHANDNAGAR SULTANPUR 35 25 2018-02-14 12:00:16 000083 2018-02-14 12:24:16 NULL2
34 FAZ05( T.E.AASTIKAN BHITVA  HAIRINGTANGANJ FAIZABAD NULL1 2018-02-15 2018-02-17 2018-02-16 40 23 1 T.E.AASTIKAN BHITVA  HAIRINGTANGANJ FAIZABAD 50 25 2018-02-15 11:00:44 000083 2018-02-15 11:03:44 NULL2
35 BASTI0 VISION CENTER, KUSAURA, BASTI NULL1 2018-02-16 2018-02-16 2018-02-16 40 14 1 VISION CENTER, KUSAURA, BASTI 10 5 2018-02-16 15:00:23 000047 2018-02-16 15:01:23 NULL2
36 FAZ06( P.V. BHUITAURA RUDAULI FAIZABAD NULL1 2018-02-18 2018-02-20 2018-02-19 40 23 1 P.V. BHUITAURA RUDAULI FAIZABAD 55 32 2018-02-18 13:00:06 000083 2018-02-18 13:18:06 NULL2
37 FAZ07( A.E.C.S,BHAGATNAGAR RUDAULI FAIZABAD NULL1 2018-02-18 2018-02-20 2018-02-19 40 23 1 A.E.C.S,BHAGATNAGAR RUDAULI FAIZABAD 75 40 2018-02-18 17:00:41 000083 2018-02-18 17:03:41 NULL2
38 FAZ08( P.V.IMILIYA TARUN FAIZABAD NULL1 2018-02-19 2018-02-21 2018-02-20 40 23 1 P.V.IMILIYA TARUN FAIZABAD 50 30 2018-02-19 12:00:57 000083 2018-02-19 12:29:57 NULL2
39 AMB06( RAJ CLINIC MASRA BAZAR AMBEDKAR NAGAR NULL1 2018-02-20 2018-02-21 2018-02-21 40 4 1 RAJ CLINIC MASRA BAZAR AMBEDKAR NAGAR 100 70 2018-02-20 18:00:41 000047 2018-02-20 18:04:41 NULL2
40 SUL05( J.H.S.AKHANDNAGAR SULTANPUR NULL1 2018-02-21 2018-02-23 2018-02-22 40 68 1 J.H.S.AKHANDNAGAR SULTANPUR 150 50 2018-02-21 15:00:28 000083 2018-02-21 15:46:28 NULL2
41 SUL06( P.V.DHANPATGANJ SULTANPUR NULL1 2018-02-22 2018-02-24 2018-02-23 40 68 1 P.V.DHANPATGANJ SULTANPUR 55 30 2018-02-22 12:00:06 000083 2018-02-22 12:03:06 NULL2
42 FAZ09( P.V.MOTIGANJ HAIRIGTANGANJ FAIZABAD NULL1 2018-02-22 2018-02-24 2018-02-23 40 23 1 P.V.MOTIGANJ HAIRIGTANGANJ FAIZABAD 60 40 2018-02-22 12:00:54 000083 2018-02-22 12:05:54 NULL2
43 SDNR01 Budhawa chauraha Bhnwapur Siddhartha nagar NULL1 2018-02-23 2018-02-24 2018-02-23 40 65 1 Budhawa chauraha Bhnwapur Siddhartha nagar 27 06 2018-02-23 11:00:44 000032 2018-02-23 11:00:49 000001 2
44 SUL07( GRAM MUDILA AKHANDNAGAR SULTANPUR NULL1 2018-02-23 2018-02-25 2018-02-24 40 68 1 GRAM MUDILA AKHANDNAGAR SULTANPUR 250 15 2018-02-24 09:00:48 000083 2018-02-24 09:15:48 NULL2
45 FAZ10( P.V.RAJAPUR MAYA  FAIZABAD NULL1 2018-02-25 2018-02-27 2018-02-26 40 23 1 P.V.RAJAPUR MAYA  FAIZABAD 40 20 2018-02-25 09:00:17 000083 2018-02-25 09:41:17 NULL2