Recent
Favorites

Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: gpsbeta »Table: employee_details
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press 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 (1494 total, Query took 0.2731 seconds.)
SELECT * FROM `employee_details`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
Number of rows:
Filter rows:
Sort by key:
Full textsidemp_idpen_idNameGender_tmpFather_NameMother_NameMarital_StatusSpouse_NameNationalityCategoryAppointed_AgainstReligionDOB_tmpStaff_TypeEmployment_TypeDesignation_tmpSchool_tmpDepartment_tmpCentreSectionOther_EntitiesDate_of_JoinSuperannuation_Datepermanent_addresspermanent_citypermanent_statepermanent_pincodecommunication_addresscommunication_citycommunication_statecommunication_pincodemobile_nophone_noemail_idblood_groupdisabilityplace_of_birthhome_townquitted_servicequitted_service_typequitted_service_sub_typesalary_account_nosav_contrib_typegpf_cpf_nps_nosociety_nopan_nohealth_card_noheightpersonal_identification_marksaadhar_nodate_createddate_modified
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 1
1 101 NULL GOVINDAN.S Male SRINIVASAN RAJAM Married JANAKIAMMAL India OBC OBC Hinduism 1964-01-15 Non-Teaching Regular Driver Level - I Transport Section 1987-11-07 NULL 17, High School RoadKirumampakkam Puducherry Puducherry 607402 17, High School RoadKirumampakkam Puducherry Puducherry 607402 9750551319 govindang68@gmail.com O +ve Pondicherry Pondicherry No 413244508 GPF PU/0274/NT 230 AGDPG0008K 171 293200098364 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 2
2 1527 NULL MEENAKSHISUNDARAM. V Male VENGUIDASALAME SIVAGAMY Married SINDHUJA India OBC General (UR) Hinduism 1978-02-27 Non-Teaching Contract Lab Attender (Electronic Media) School of Media &  Mass Communication Centre for Electronic Media 2008-02-01 NULL No.3, Nondi Savarirayapillai Street Karaikal Puducherry 609602 No.3, Nondi Savarirayapillai Street Karaikal Puducherry 609602 9345488978 vkannan_09@yahoo.in B +ve Karaikal Karaikal No 757681170 CPF 111107181220 1190 FYLPS4143E 3051 164 I) A mole on the neck II) A scar on the right han... 566755853276 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 3
3 1526 NULL UMESAN. M Male MANNU. C KASIYAMMAL. M Married JAYANTHI.M India OBC General (UR) Hinduism 1987-12-05 Non-Teaching Contract Lab Attender (Electronic Media) School of Media &  Mass Communication Centre for Electronic Media 2008-03-01 NULL No.3/93, ThathagkuppamNochalere-Post Gingee Taluk Villupuram District Tamil Nadu 604201 No.2, Nethaji Street, Chinnakalapet Puducherry Tamil Nadu 605014 9626565447 4132654660 mkumesan@gmail.com O +ve Thathagkuppam Gingee-Tamil nadu No 725645196 CPF 111107223806 1183 AEDPU3970Q 3053 162     I) A scar on right leg II) A mole on mouth   ... 732281301189 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 4
4 1017 NULL BALAMURUGAN. S Male SOLAMALAI. V CHANDRA. S Married ANITHA.S India SC General (UR) Hinduism 1981-04-28 Non-Teaching Contract Production Assistant School of Media &  Mass Communication Centre for Electronic Media 2008-07-01 NULL No.19/1-A, Vaigai Appartment, Anna Nagar, Madurai Tamil Nadu 625020 No.123, ECR Poongavanam Chetty StreetAmma Mariamma... Periya Kalapet Tamil Nadu 605014 9840752373 bala.emmrc@gmail.com O +ve Madurai Madurai No 758588012 CPF CPF/114/NT NULL AOAPB7870B 3052 172 I) A mole on right hand elbow II) A scar on left ... 695827080326 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 5
5 1018 NULL MANAMATHI. M Female MANAMOHAN. K BANUMATHI. R Unmarried India OBC General (UR) Hinduism 1984-02-18 Non-Teaching Contract Graphic Assistant School of Media &  Mass Communication Centre for Electronic Media 2008-07-01 NULL No.60, 3rd CrossAsiriyar Nagar, Karaikal Puducherry 609602 No.60, 3rd CrossAsiriyar Nagar, Karaikal Puducherry 609602 9442646077 4368227777 manamathi@gmail.com B +ve Akkaravattam karaikal Karaikal No 759828293 CPF CPF/115/NT NULL AXQPM0353B 156  I) A mole on the right lower hand II) A little m... 987170371725 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 6
6 1019 NULL IYYANAR. M Male MURUGAIYAN. K RADHA. M Married SANTHANI.S India SC General (UR) Hinduism 1979-11-05 Non-Teaching Contract Technician (Electronic Media) School of Media &  Mass Communication Centre for Electronic Media 2008-04-01 NULL No.474, Srinarayanaguru Street Vallam & Post Ginge... Villupuram District Tamil Nadu 604206 No.474, Srinarayanaguru Street Vallam & Post Ginge... Villupuram District Tamil Nadu 604206 9444284453 miyyanar@gmail.com O +ve Vallam Gingee-Tamil nadu No 758587982 CPF CPF/116/NT NULL AANPI4658P 3056 170 I) A white mole on the right side abdumn II) A sm... 711140658676 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 7
7 102 P309 BALAKRISHNAN. K Male KATHIR. P AMIRTHAM. K Married DEVAKUMARI.B India SC SC Hinduism 1959-09-22 Non-Teaching Regular Driver Level - I Transport Section 1987-08-06 2019-09-30 No.11, Pillayar Koil Street, KudiyrppupalayamSelia... Puducherry Puducherry 607402 No.11, Pillayar Koil Street, KudiyrppupalayamSelia... Puducherry Puducherry 607402 B +ve Puducherry Puducherry No 413242205 NULL 162 NULL AGOPB4870D 150 I) A black mole on the left cheek II) A scar on th... NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 8
8 1020 NULL SANJEEV KUMAR. J. A Male ANAND. J ARUNA Married LAVANYA.S India SC General (UR) Hinduism 1971-05-06 Non-Teaching Contract Producer School of Media &  Mass Communication Centre for Electronic Media 2008-08-01 NULL No.D-21Type-IV Qtrs Pondicherry University Puducherry Puducherry 605014 No.D-21Type-IV Qtrs Pondicherry University Puducherry Puducherry 605014 9791553528 sanjeevkumar_ja@yahoo.com O +ve Hyderabad Hyderabad No 759310838 CPF CPF/117/NT NULL AOXPK9826R 170   I) A scar on left cheek       977782732711 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 9
9 1544 NULL KALAIYANAGAN. M Male MAYAKRISHNAN.R MUTHULAKSHMI. M Married SATHYAKUMARI.K India SC SC Hinduism 1982-05-02 Non-Teaching Contract Junior Engineer(Civil) Engineering Wing (Civil) 2008-11-02 NULL No.12, Othavadi Street, PudunagarPoraiyour PetVill... Puducherry Puducherry 605110 No.12, Othavadi Street, PudunagarPoraiyour PetVill... Puducherry Puducherry 605110 9944614045 4132660146 kalaicivilpec@gmail.com A +ve Puducherry Puducherry No 762816884 CPF CPF/175/NT NULL AVUPK2595H 155 I) A scar on right leg II) A mole on the left che... 260426174493 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 10
10 103 P213 DEVASIGAMANY. R Male RAMACHANDIRAN. B ANDAL. R Married SANTHA.D India OBC Land Affected Hinduism 1957-04-18 Non-Teaching Regular Senior Assistant Department of Physical Education and Sports 1987-04-08 2017-04-30 No.31, Throwpathiamman Koil StreetPillaichavady & ... Puducherry Puducherry 605014 No.31, Throwpathiamman Koil StreetPillaichavady & ... Puducherry Puducherry 605014 9443287657 4132654696 devasigamany57@gmail.com O +ve Puducherry Puducherry No SUPER ANNUATION 413240489 NULL 215 NULL AVGPD4616C 217 164  I) A scar in right hand palm II) A scar in the l... 325013466770 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 11
11 1524 NULL SUBRAMANIYAM. P Male PERIYASAMY CHENNAPILLY Married ILLAIYAKANNI India SC SC Hinduism 1973-05-15 Non-Teaching Contract Lab Attendant School of Life Sciences Animal House 2008-11-03 NULL No.1-B, Amman Koil Street, PerumbandiVanchinapuram... Ariyalur District Tamil Nadu 621714 No.170, Pallivasal Street, Periyar NagarNellithope Nellithope Tamil Nadu 605005 9842051545 maniyam56@yahoo.com O +ve Ariyalur, Tamil nadu Perumband No 498816599 CPF CPF/163/NT NULL 109 155  I) A big mole on the right hand palm between the... 519570700967 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 12
12 1525 NULL KESSAVARAMAN. E Male EGANATHAN. M THILAGAVATHY. E Married MALARVIZHI.K India OBC OBC Hinduism 1976-09-18 Non-Teaching Contract Laboratory Attendant Ramanujan School of Mathematical Sciences 2008-04-23 NULL No.16, Mettu StreetChinna Kalapet Puducherry Puducherry 605014 No.16, Mettu StreetChinna Kalapet Puducherry Puducherry 605014 8940541405 KESSAVARAMAN@gmail.com B +ve Puducherry Puducherry No 772982351 CPF CPF/164/NT 1185 172  A mole on left side of chest      A scar on the ... 272503194265 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 13
13 1034 NULL SIVAKUMAR. G Male GOVINDASAMY. N VASANTHA. G Married SANTHI.S India OBC General (UR) Hinduism 1971-08-20 Non-Teaching Contract Camara Man School of Media &  Mass Communication Centre for Electronic Media 2008-05-26 NULL No.9, Jothi Ramalingam StreetNear Sakthi NagarSara... Puducherry Puducherry 605013 No.9, Jothi Ramalingam StreetNear Sakthi NagarSara... Puducherry Puducherry 605013 9487061730 7502429730 subisuriya@gmail.com A +ve Puducherry Puducherry No 774844513 CPF CPF/166/NT NULL CLVPS5248A 3057 170 I) A black mole on the nose II) A scar on the che... 704788898576 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 14
14 1039 NULL RAJA. A Male ANANTHARAJ. N INDUBALA. A Married SHANTI.A India SC SC Hinduism 1983-12-26 Non-Teaching Regular Assistant   Administration (Establishment - Non-Teaching) 2008-07-28 2043-12-31 No.2/12, 3rd Cross Street Shanthi Nagar Palayamkot... Tirunelveli Tamil Nadu 627002 F-60, QuartersUniversity Campus Pondicherry Univer... Puducherry Tamil Nadu 605014 9677998077 arajan3@yahoo.co.in B +ve tirunelveli tirunelveli No 784148434 NPS 111001051682 792 APOPR6438Q 425 165     I) An scar on right eyebrow II) An scar on ce... 869698740159 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 15
15 1040 NULL BABU.V Male VENGADESAN.D THILAGAVATHY.V Married THARAKESWARI.V India SC SC Hinduism 1980-07-25 Non-Teaching Regular Assistant   Examination Wing 2008-07-28 2040-07-31 No.16, Iyyanar koil st Thattanchavady. Puducherry Puducherry 605009 No.16, Iyyanar koil st Thattanchavady. Puducherry Puducherry 605009 9952627829 bavbu07@gmail.com AB +ve Puducherry Puducherry No 723819440 NPS 110061393555 791 AWVPB3040L 430 157  I). A mole on right fore arm just above the wris... 502581918526 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 16
16 1041 NULL PADMAVATHI.D Female DURAISAMY.P SELLAMMAL.C Married PERUMAL.A India ST ST Hinduism 1981-09-05 Non-Teaching Regular Junior Assistant Purchase & Stores Section 2008-06-28 2041-05-31 NeethipuramChinnathanda PostKolathur BlockMettur T... Salem Tamil Nadu 636303 48, Middle StreetPeriyakalapetPuducherry Puducherry Tamil Nadu 605014 9486458339 perumalpadma2012@gmail.com O +ve Nedungadu Kolathur No 784888140 NPS 110071896297 806 AMUPP0227G 152 A mole on left feetA mole on neck 317476612426 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 17
17 1043 NULL PARVATHI. P Female PADMANABHAN. C LAKSHMI DEVI. P Married BASKARAN.G India ST ST Hinduism 1978-10-02 Non-Teaching Regular Junior Assistant Central Instrumentation Facility 2008-07-30 2038-02-28 No.104, Sri Ram Nagar, PuliyamangalamArokkonam, Vellore Tamil Nadu 613004 No.F-47, 24 Unit Apartment, Staff Quatres, Pondich... Kalapet Tamil Nadu 605014 9442385698 parvathibaskaran2k11@gmail.com A -ve Cuddapah Andra Pradesh Cuddapah Andra Pradesh No 784650489 NPS 110051051676 800 BLSPP3965R 6759 160  I) A mole on the nose II) A scar on the right si... 958026047101 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 18
18 1044 NULL SANTHALAKSHMY.K Male KRISHNAMOORTHY.A KASTURI.K Married VEERAPANDIAN.D India SC SC Hinduism 1974-10-18 Non-Teaching Regular Assistant   Examination Wing 2008-07-30 2034-10-30 No.18, ranganathan st Nethaji nagar-IIUppulam Puducherry Puducherry 605001 No.18, ranganathan st Nethaji nagar-IIUppulam Puducherry Puducherry 605001 9600917706 veerkrishnithilan@gmail.com B +ve Puducherry Puducherry No 784888355 NPS 110061052284 798 FFQPS9221K 476 145  I) A mole on the right eye.II) A mole at the bac... 661011685802 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 19
19 1045 NULL DHANASEGARY.S Female SUBBARAYAN.P SELVAMBAL.S Married NIL India SC SC Hinduism 1978-04-04 Non-Teaching Regular Assistant   Examination Wing 2008-08-14 2038-04-30 No.121, Desamariamman Koil streetBahour PetBahour Puducherry Puducherry 607402 No.121, Desamariamman Koil streetBahour PetBahour Puducherry Puducherry 607402 4132200568 dhanasegary1978@gmail.com B +ve Y Puducherry Puducherry No 788523467 NPS 110001052287 795 CJIPD7891P 150  I) A block in the right hand.II) A scar in the f... 602067499271 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 20
20 1046 NULL THEIVENDRAN. P Male PANDI. P PAPPA.P Married DEIS India SC SC Hinduism 1976-05-06 Non-Teaching Regular Assistant   Planning and Development Section 2008-07-21 2036-06-30 Vowal Thottam (P.O) Agrl. College (Via) Madurai Tamil Nadu 625104 No.F-63, Staff Quarters Pondicherry University Cam... Kalapet Tamil Nadu 605014 9787103899 7598879079 theivamt@gmail.com O +ve Madurai Madurai No 783664200 NPS 110031051677 794 AIXPT7895F 424 164 I) A black mole on left hand wrist II) A scar on ... 792777530501 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 21
21 1047 NULL PUNITHAVATHY. R Female RAMACHANDRAN.M CHINTHAMANI.R Married VENGADACHALAM.V India ST ST Hinduism 1989-10-03 Non-Teaching Regular Junior Assistant Finance And Accounts Section 2008-07-23 2049-03-31 No.13/18, Chinna Madhur VillagePelakkadu postYerca... Salem Tamil Nadu 636601 No.46-F, Staff qtrsPondicherry University Kalapet Puducherry Tamil Nadu 605014 8939458771 vathy.punitha@gmail.com O +ve Salem Salem No 785305725 NPS 110071052289 801 BYTPP0620F 162 I) A mole on the left handII) A mole on the Upper... 476849055309 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 22
22 1545 NULL R.DOURERADJANE Male RAMAMOURTHY VISSALATCHY Married VALLI India OBC OBC Hinduism 1974-09-04 Non-Teaching Contract Junior Engineer(Civil) Engineering Wing (Civil) 2008-07-22 NULL 129, I cross, Sri Ranga Nagar, Marie Oulougrate,Mo... Puducherry Puducherry 605010 129, I cross, Sri Ranga Nagar, Marie Oulougrate,Mo... Puducherry Puducherry 605010 9842335424 doure74@gmail.com B +ve Puducherry Puducherry No 787015319 CPF 110147580813 NULL AJBPD2235Q 152 A mole in the centre palm right handA mole at cent... 582690768853 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 23
23 1052 NULL JAYA.M Female JAYARAMAN.G ANDAL.J Married MURUGAN India OBC Compassionate Hinduism 1968-04-20 Non-Teaching Regular Office Attendant Finance And Accounts Section 2008-08-09 2028-04-30 No.66, M.G.Road Puducherry Puducherry 605001 No.66, M.G.Road Puducherry Puducherry 605001 8754729651 kamaljaya1969@gmail.com O -ve Kerala Puducherry No 792626648 NPS 110051393550 799 AVLPJ5633N 152 I) A black mole over the left arm middle fingerII... 355375184236 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 24
24 1053 NULL SELVAKUMAR.N Male NATARAJAN. E RATHINAM Married RAJAMMAL.S India ST ST Hinduism 1978-12-29 Non-Teaching Regular Junior Assistant Purchase & Stores Section 2008-09-19 2038-12-31 132/3, Periyakombai, Rasipuram (TK) - 636113Namall... Namakal Tamil Nadu 636113 B-03/Type II Quarters,Pondicherry University Campu... PUDUCHERRY Tamil Nadu 605014 9442253341 rajiselva@yahoo.co.in O +ve Attur No 795500280 NPS 111001896452 797 FZKPS3140F 475 165 A thick mole on the right side of the neckA black... 500054038608 NULL 2019-12-13 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `employee_details` WHERE `employee_details`.`id` = 25
25 1055 NULL DURAI VIJAYAN. D Male DURAIKANNAN KRISHNAVENI Married CHARMILA India SC General (UR) Hinduism 1974-04-03 Non-Teaching Contract Shooting Assistant School of Media &  Mass Communication Centre for Electronic Media 2008-09-19 NULL No.253, Bharathidasan StreetGandhi Nagar, Thiruchi... Vanur Taluk Tamil Nadu 605111 No.253, Bharathidasan StreetGandhi Nagar, Thiruchi... Vanur Taluk Tamil Nadu 605111 99945493454 vijayandurai@gmail.com O +ve Uppuvelore Thiruchitrambalam TN No 795500199 CPF CPF/170/NT NULL CCAPD7889N 158 I) A mole on the right ring finger II) A mole on ... 479092289017 NULL 2019-12-13 00:00:00
With selected: With selected:

|
|
|
Number of rows:
Filter rows:
Sort by key:
Query results operationsPrint PrintCopy to clipboard Copy to clipboardExport Export Display chart Display chart Create view Create view

Bookmark this SQL query Bookmark this SQL query
mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.