www.tpgit.edu.in / 127.0.0.1 / tpgited1 / studentall

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Table navigation bar

Use only icons, only text or both.

How to display various action links

Use only icons, only text or both.

Allow to display all the rows

Whether a user should be displayed a "show all (rows)" button.

Maximum number of rows to display

Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.

Default sorting order

SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.

Highlight pointer

Highlight row pointed by the mouse cursor.

Row marker

Highlight selected rows.

Grid editing: trigger action

Grid editing: save all edited cells at once

Repeat headers

Repeat the headers every X cells, 0 deactivates this feature.

Limit column characters

Maximum number of characters shown in any non-numeric column on browse view.

Where to show the table row links

These are Edit, Copy and Delete links.

Show row links anyway

Whether to show row links even in the absence of a unique key.

Primary key default sort order

Default sort order for tables with a primary key.

Remember table's sorting

When browsing tables, the sorting of each table is remembered.

Relational display

For display Options

			regno	rollno	s_name	f_name	dob	dept	gender	nationality	religion	community	caste	caddr	paddr	phoneno	pphoneno 1	email	baccno	ifsc	aadhar	first_g	phy_h	degree	hostel	hostel_status	batch	updated	time
Edit	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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	Copy	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

Customize appearance of the navigation panel.

Customize the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

Customize browse mode.

Navigation panel

Customize appearance of the navigation panel.

Navigation tree

Customize the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

Browse mode

Customize browse mode.