Drop files here

SQL upload ( 0 ) x -

Page-related settings Click 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.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `studentall` ORDER BY `pphoneno` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts regno rollno s_name f_name dob dept gender nationality religion community caste caddr paddr phoneno pphoneno Descending Ascending 1 email baccno ifsc aadhar first_g phy_h degree hostel hostel_status batch updated time
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513115114076'
513115114076 15ME079 SIVA. P PALANI M 1998-06-11 B.E. Mechanical Engineering Male Indian Hindu SC KURAVAN 40/10D RAMASAMY ADAIKALAM STREET,
MULLAIVADI POST...
40/10D RAMASAMY ADAIKALAM STREET,
MULLAIVADI POST...
9787303456 9994959033 sivadhaya1998@gmail.com 35191804810 SBIN0000810 466178196767 YES NO UG YES Staying Inside 2015-2019 YES 2017-08-16 10:37:14
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513116106090'
513116106090 16EC092 YAMUNADEVI M MANICKAM K 1999-11-11 B.E. Electronics and Communication Engineering Female Indian Hindu SC ADI DRAVIDA TPGIT, GIRLS HOSTAL, BAGAYAM, VELLORE. PINCODE-632... A/123-4/3,KANGUPPAM(VILL.& POST), KATPADI TALUK, V... 8270442810 9994936042 yamunadevi11111999@gmail.com 356502010118235 UBINO535656 814464470659 NO NO UG NO NA 2016-2020 YES 2018-11-10 16:20:31
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513115621305'
513115621305 16MCA(LE)05 GAYATHRI N G.NARAYANAN 1994-04-09 MCA Female Indian Hindu MBC MEENAVAR Thanthai periyar govt institute of technology,TPGI... 107,Parvathi nagar,Theirpet,Hosur-635109 9791485772 9994838031 gayathriksn@gmail.com 36184435912 SBIN0001810 324413022583 NO NO PG YES Staying Inside 2016-2018 YES 2017-08-16 10:37:14
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513116410014'
513116410014 16MAE09 KISHOREKUMAR M MUNUSWAMY K 1995-07-15 M.E. Manufacturing Engineering Male Indian Hindu SC ADI DRAVIDA NO.21/5,SANJEEVI PILLAI STREET,
D.K.M.COLLEGE ROA...
NO.21/5,SANJEEVI PILLAI STREET,
D.K.M.COLLEGE ROA...
8220363615 9994782422 kumarkishore93@gmail.com 33247375805 SBIN0015472 632900666533 NO NO PG NO NA 2016-2018 YES 2017-08-16 10:37:14
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513115103704'
513115103704 16CE(T)04 PAZHANI S SURESH A 1998-06-05 B.E. Civil Engineering Male Indian Hindu BC SENGUNTHAR NO.9,Srinivasa Illam,
Thendral Nagar,
Chitteri,
...
4/677,Anna Street,
Srikalikapuram,Pallipet(TK),
...
8428811551 9994750194 pazhani05061998@gmail.com 6064160671 IDIB000R052 475964287763 YES NO NO NA 2015-2019 YES 2017-08-16 10:37:14
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513115106059'
513115106059 15EC062 PRIYANKA AKILA.R RAJAMANI K 1997-11-24 B.E. Electronics and Communication Engineering Female Indian Hindu MBC VANNIYAR TPGIT GIRLS HOSTEL,BAGAYAM,VELLORE-632002 2/100,BRAMINAR STREET,AVALUR,VELLORE(DT)-632531 9944693710 9994666549 akilapriyanka1@gmail.com 35210435637 SBIN0013075 232742663803 YES NO UG YES Staying Inside 2015-2019 YES 2018-11-10 16:20:31
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513116114057'
513116114057 16ME059 NANTHAKISHORE T N NAGARAJ T 1999-09-11 B.E. Mechanical Engineering Male Indian Hindu SC VALLUVAN TPGIT boys hostel,
Vellore-632002
25A,Gandhi nagar,thuraiyur road,theppakulam opposi... 7397554920 9994645859 rajininantha3@gmail.com 20369673547 SBIN0012807 832410635629 NO NO UG YES Staying Inside 2016-2020 YES 2017-08-16 10:37:14
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513115106088'
513115106088 15EC092 SUSMITHA.T TAMILSELVAN.M 1998-03-11 B.E. Electronics and Communication Engineering Female Indian Hindu BC TPGIT girls hostel,bagayam,vellore-2,632 002 2/A,perumal kovil street ,pandaram lane ,chinnasal... 9600261244 9994587232 susmithaselvan@gmail.com 20276922715 SBIN0011069 422592703979 NO NO UG YES Staying Inside 2015-2019 YES 2018-11-10 16:20:31
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513115103017'
513115103017 15CE018 HARIHARAPUTHIRAN. M G.MURUGAN 1998-05-21 B.E. Civil Engineering Male Indian Hindu BC KAMMALAR BOYS HOSTEL
TPGIT
VELLORE-02
7A/13,SUNDARAR STREET
SANKARANKOVIL-627756
TIRUN...
7845316098 9994579329 hariharanhhp@gmail.com 765872223 IDIB000S008 838014355041 NO NO UG YES Staying Inside 2015-2019 YES 2017-08-16 10:37:14
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513116106058'
513116106058 16EC058 RAHAMATHULLA ASSIGN ALI.M 1998-12-01 B.E. Electronics and Communication Engineering Male Indian Muslim BCM LABBAI Room no:60,Tpgit Boys hostel,bagayam,vellore-63200... S/O M.asain Ali ,door no:9/4,Banadurai East Street... 8056394330 9994554071 rahmathsulaiman55@gmail.com 004401000053101 IOBA0000044 714897697463 YES NO UG NO NA 2016-2020 YES 2018-11-10 16:20:31
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513116103049'
513116103049 16CE047 SIVAKUMAR M MURUGAN.B 1999-11-20 B.E. Civil Engineering Male Indian Hindu BC D.no:394,Mahatma gandhi street,
Srinivaasa nagar...
D.no:394,Mahatma gandhi street,
Srinivaasa nagar...
9894315314 9994490349 mrsivakumar07@gmail.com 36122353032 SBIN0000842 878704774424 YES NO UG NO NA 2016-2020 YES 2017-08-16 10:37:14
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513114114005'
513114114005 14ME005 AJITH KUMAR . D D.DHANANCHEZHIYAN 1997-04-20 B.E. Mechanical Engineering Male Indian Hindu MBC KULALA No:51,kuzhavar street,kodampakkam,mahendravadi pos... No:51,kuzhavar street,kodampakkam,mahendravadi pos... 9524958978 9994478972 Ajikmdda1120@gmail.com 34394512133 SBIN0002203 444148271035 YES NO UG NO 2014-2018 YES 2017-08-16 10:37:14
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513114106019'
513114106019 14EC019 ESWARAMOORTHY.M MURUGESAN.S 1997-05-02 B.E. Electronics and Communication Engineering Male Indian Hindu SCA Arunthathiyar 1/302,chitheri road,tpgit opposite ,Bagayam,vellor... 5/109,palappalayam colony,koonavelampatti pudur,Ra... 8124994806 9994420813 eswar1062@gmail.com 31387421280 SBIN0001310 389367669170 YES NO UG YES Staying Inside 2014-2018 YES 2018-11-10 16:20:31
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513114114069'
513114114069 14ME071 RAMPRASATH S S SRINIVASAN S R 1997-10-03 B.E. Mechanical Engineering Male Indian Hindu BC SOURASHTRA NO:87,Big Sowrashtra Street,Walajapet,Vellore Dist... NO:87,Big Sowrashtra Street,Walajapet,Vellore Dist... 9597648071 9994363976 dhanaramprasath@gmail.com 34397895188 SBIN0002203 677578935998 YES NO UG NO 2014-2018 YES 2017-08-16 10:37:14
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513116106075'
513116106075 16EC077 SATHISH KUMAR S SUBRAMANI V 1999-04-21 B.E. Electronics and Communication Engineering Male Indian Hindu BC No-37,D sector,
V.G.Rao Nagar,
Katpadi,
Vellore...
No-37,D sector,
V.G.Rao Nagar,
Katpadi,
Vellore...
7548853079 9994307663 sathish1999421@gmail.com 001400101008297 CORP0000014 545115878618 NO NO UG NO NA 2016-2020 YES 2018-11-10 16:20:31
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513114103005'
513114103005 14CE005 ARUN.S SEKAR.C 1997-07-10 B.E. Civil Engineering Male Indian Hindu MBC VANNIYAR PLOT NO:3,THIRUVALLUVAR STREET,THENDRAL NAGAR,CHIT... B2/11C,KAVERIPATTU,REDDIYUR(P.O),JOLARPETTAI,NATTR... 9994662778 9994267792 arunsamudi@gmail.com 34297738207 SBIN0003688 640771052164 NO NO UG YES Staying Inside 2014-2018 YES 2017-08-16 10:37:14
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513116106086'
513116106086 16EC088 THULASIMANI N NAGENTHIRAN.A 1998-12-16 B.E. Electronics and Communication Engineering Female Indian Hindu BC D.no 6-2/38 new 6th ward kattiya muthu mudali stre... D.no6-2/38 new 6th ward kattiya muthu mudali stree... 9488240614 9994211614 thulasi thulasi 998@mail.com 36062566159 SBIN0002275 479276056125 NO NO UG YES Staying Inside 2016-2020 YES 2018-11-10 16:20:31
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513114114096'
513114114096 14ME098 VIGNESH A ANNADURAI.K 1996-11-10 B.E. Mechanical Engineering Male Indian Hindu BC AGAMUDAYAR 86/1,EAST BAZZAR STREET,SHOLINGHUR(PO),WALAJA(TK),... 86/1,EAST BAZZAR STREET,SHOLINGHUR(PO),WALAJA(TK),... 9629959055 9994093561 vignesha618@gmail.com 34238734927 SBIN0002203 525886428176 NO NO UG NO 2014-2018 YES 2017-08-16 10:37:14
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513116103031'
513116103031 16ce031 MOHAMED JAWAHAR H A.HIDHAYATHULLA 1998-10-27 B.E. Civil Engineering Male Indian Muslim BCM LABBAI Room no.53,
TPGIT boys hostel,
Bagayam,
Vellore...
4/2415-b, main road,
Thangachimadam (PO),
Ramesw...
8680877960 9994071240 Mohamedjawahar227@gmail.com 0232036000000141 DLXB0000232 352752057076 NO NO UG YES Staying Inside 2016-2020 YES 2017-08-16 10:37:14
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513115106005'
513115106005 15EC005 ARUNPANDI.R RAJANGAM.M 1998-05-28 B.E. Electronics and Communication Engineering Male Indian Hindu MBC PIRAMALAI KALLARS 9-10-1A,KARAIYALAN STREET,
THAMARAIKULAM,
PERIYA...
9-10-1A,KARAIYALAN STREET,
THAMARAIKULAM,
PERIYA...
9894581190 9994057616 arunpandi71.ece@gmail.com 1020108048759 CNRB0001020 665722286735 NO NO UG YES Staying Inside 2015-2019 YES 2018-11-10 16:20:31
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513115621017'
513115621017 15MCA19 LAVANYA.K R.L.KARTHIKEYAN 1995-05-24 MCA Female Indian Hindu BC SENGUNTHAR 334,Sundhara Ganapathi street,
Gandhi Nagar,
vel...
334,Sundhara Ganapathi street,
Gandhi Nagar,
vel...
9940714377 9994017817 karthik.lavanya24@gmail.com 168301000016270 IOBA0001683 827335569959 NO NO PG NA NA 2015-2018 YES 2017-08-16 10:37:14
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513115106305'
513115106305 16EC(LE)05 MULLAIVENDAN D DURAISAMY 1997-06-25 B.E. Electronics and Communication Engineering Male Indian Hindu MBC VANNIYAR ROOM NO:02,TPGIT BOYS HOSTEL,VELLORE,BAGAYAM,632 0... 2/69,ANUMAMPATTI(V), PALLATHUR(P),TIRUPATTUR(TK), ... 9698788967 9976959735 vendanmullai0123@gmail.com 6059137150 IDIB000G048 546835186886 NO NO UG NO NA 2016-2019 YES 2018-11-10 16:20:31
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513115106047'
513115106047 15EC050 MONISHA.J JAYAPRAKASH.M 1998-07-27 B.E. Electronics and Communication Engineering Female Indian Hindu BC SENGUNTHAR 108,kumaran street,thiruvothur,cheyyar -604 407,th... 108,kumaran street,thiruvothur,cheyyar -604 407,th... 9245334059 9976748342 monishakavya27@gmail.com 6053620746 IDIB000C018 312873211941 YES NO UG YES Staying Inside 2015-2019 YES 2018-11-10 16:20:31
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513116106085'
513116106085 16ec087 THARAGESWARI J S. JAGADEESWARAN 1999-06-24 B.E. Electronics and Communication Engineering Female Indian Hindu BC 15,Thandu mari amman kovil west street ,Northpet,S... 15,Thandu mari amman kovil west street,Northpet,Sa... 8220953297 9976522934 jthara51@gmail.com 008101000033638 IOBA0000081 292505932909 YES NO UG YES Staying Inside 2016-2020 YES 2018-11-10 16:20:31
Edit Edit Copy Copy Delete Delete
DELETE FROM studentall WHERE `studentall`.`regno` = '513116103047'
513116103047 16CE047 SENTHIL MURUGAN K T.KATHIRVEL 1999-06-25 B.E. Civil Engineering Male Indian Hindu BC KAMMALAR TPGIT BOYSHOSTEL, BAGAYAM               VELLORE-63... 18A,West water tank street,ladapuram(po), perambal... 9976010272 9976431426 senthilkathirvel1999@gmail.com 6151825415 IDIB000L017 538584583439 NO NO UG YES Staying Inside 2016-2020 YES 2017-08-16 10:37:14
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query