sms-beta.bicpu.edu.in / 127.0.0.1 / gpsbeta / registered_20

Recent`pu_recruitment_nt`.`education_details`
`pu_recruitment_nt`.`ci_sessions`
`sams`.`affliated_colleges`
`fuel`.`fuel_blocks`
`genhr`.`assets_category`
`sams`.`entrance_19`
`sams`.`other_details`
`world`.`country`
`pu_recruitment_nt_2022`.`ci_sessions`
`pu_website`.`pu_terms`
Favorites `purec_nt`.`type_definition`
 `purec_nt`.`uploads`
 `gpsbeta`.`grades`
New
cm9vdA==.ZnVlbA==cm9vdA==.ZnVlbA==0
fuel
cm9vdA==.Z2VuaHI=cm9vdA==.Z2VuaHI=0
genhr
cm9vdA==.Z3BzYmV0YQ==cm9vdA==.Z3BzYmV0YQ==0
gpsbeta
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1hcm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h0
information_schema
cm9vdA==.am91cm5hbA==cm9vdA==.am91cm5hbA==0
journal
cm9vdA==.bGlicmFyeQ==cm9vdA==.bGlicmFyeQ==0
library
cm9vdA==.bG1zcm9vdA==.bG1z0
lms
cm9vdA==.bXlzcWw=cm9vdA==.bXlzcWw=0
mysql
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1hcm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h0
performance_schema
cm9vdA==.cGhwbXlhZG1pbg==cm9vdA==.cGhwbXlhZG1pbg==0
phpmyadmin
cm9vdA==.cHJvZmlsZQ==cm9vdA==.cHJvZmlsZQ==0
profile
cm9vdA==cm9vdA==.cHU=0
 pu
cm9vdA==cm9vdA==.cHU=.cmVjcnVpdG1lbnQ=0
 recruitment
cm9vdA==.cHVfcmVjcnVpdG1lbnQ=cm9vdA==.cHU=.cmVjcnVpdG1lbnQ=.0
pu_recruitment
cm9vdA==.cHVfcmVjcnVpdG1lbnRfYXJkcg==cm9vdA==.cHU=.cmVjcnVpdG1lbnQ=.YXJkcg==0
pu_recruitment_ardr
cm9vdA==.cHVfcmVjcnVpdG1lbnRfZGlycm9vdA==.cHU=.cmVjcnVpdG1lbnQ=.ZGly0
pu_recruitment_dir
cm9vdA==.cHVfcmVjcnVpdG1lbnRfbnQ=cm9vdA==.cHU=.cmVjcnVpdG1lbnQ=.bnQ=0
pu_recruitment_nt
cm9vdA==.cHVfcmVjcnVpdG1lbnRfbnRfMjAyMg==cm9vdA==.cHU=.cmVjcnVpdG1lbnQ=.bnRfMjAyMg==0
pu_recruitment_nt_2022
cm9vdA==.cHVfcmVjcnVpdG1lbnRfbnRfMjAyMw==cm9vdA==.cHU=.cmVjcnVpdG1lbnQ=.bnRfMjAyMw==0
pu_recruitment_nt_2023
cm9vdA==.cHVfcmVjcnVpdG1lbnRfcmVnXzIwMjQ=cm9vdA==.cHU=.cmVjcnVpdG1lbnQ=.cmVnXzIwMjQ=0
pu_recruitment_reg_2024
cm9vdA==.cHVfc21zX2JldGE=cm9vdA==.cHU=.c21zX2JldGE=0
pu_sms_beta
cm9vdA==.cHVfd2Vic2l0ZQ==cm9vdA==.cHU=.d2Vic2l0ZQ==0
pu_website
cm9vdA==.cHVfd2Vic2l0ZTE=cm9vdA==.cHU=.d2Vic2l0ZTE=0
pu_website1
cm9vdA==cm9vdA==.cHVyZWM=0
 purec
cm9vdA==.cHVyZWM=cm9vdA==.cHVyZWM=.0
purec
cm9vdA==.cHVyZWNfZmFjdWx0eQ==cm9vdA==.cHVyZWM=.ZmFjdWx0eQ==0
purec_faculty
cm9vdA==.cHVyZWNfbnQ=cm9vdA==.cHVyZWM=.bnQ=0
purec_nt
cm9vdA==.cHVyZWNfbnRfMjAyMg==cm9vdA==.cHVyZWM=.bnRfMjAyMg==0
purec_nt_2022
cm9vdA==.cHVyZWNfc3RhdA==cm9vdA==.cHVyZWM=.c3RhdA==0
purec_stat
cm9vdA==.cXVpeg==cm9vdA==.cXVpeg==0
quiz
cm9vdA==.c2Ftcw==cm9vdA==.c2Ftcw==0
sams
cm9vdA==.dGVtcG9yYXJpb3M=cm9vdA==.dGVtcG9yYXJpb3M=0
temporarios
cm9vdA==.dGVzdA==cm9vdA==.dGVzdA==0
test
cm9vdA==.d2FyZWhvdXNlcm9vdA==.d2FyZWhvdXNl0
warehouse
cm9vdA==.d29ybGQ=cm9vdA==.d29ybGQ=0
world

Navigation panel
Navigation tree
Servers
Databases
Tables

Navigation panel

Customize appearance of the navigation panel.

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.

Navigation tree

Customize the navigation tree.

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

Servers

Servers display options.

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.

Databases

Databases display options.

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

Tables

Tables display options.

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

Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »

Database: gpsbeta »

Table: registered_20

Click on the bar to scroll to top of page

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 structure

Table structure

Settings for the table structure (list of columns).

Default transformations
Hide table structure actions Whether the table structure actions should be hidden.
Show column comments Whether column comments should be shown in table structure view
Default transformations for Hex Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	2
Default transformations for Substring Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	0 all …
Default transformations for Bool2Text Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	T F
Default transformations for External Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	0 -f /dev/null -i -wrap -q 1 1
Default transformations for PreApPend Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Default transformations for DateFormat Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	0 local
Default transformations for Inline Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	100 100
Default transformations for TextImageLink Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	100 50
Default transformations for TextLink Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.

#	Name	Type	Collation	Null	Default	Extra	Action
1	id	int(11)		No	None	AUTO_INCREMENT	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
2	User Reg Id	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
3	Application No.	int(5)		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
4	Candidate Name	tinytext	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
5	Gender	varchar(6)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
6	Single Child (if Female)	varchar(2)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
7	Fathers Name	tinytext	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
8	Mothers Name	tinytext	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
9	Guardians Name	tinytext	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
10	Parents Guardians Contact No	bigint(10)		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
11	Date of Birth	date		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
12	Age as on 1/4/2020	int(2)		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
13	Email Id	tinytext	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
14	Mobile No.	bigint(10)		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
15	Category	varchar(20)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
16	Differently Abled	varchar(2)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
17	Disability Category	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
18	Are you a Defense Personnel	varchar(2)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
19	Religion	varchar(9)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
20	Other Religion	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
21	Nationality	varchar(6)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
22	Are you Native of Puducherry Union Territory	varchar(2)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
23	Native / Residence of Karaikal	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
24	Are you Domicile of Jammu & Kashmir	varchar(2)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
25	Are you from URBAN/RURAL area	varchar(5)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
26	Permanent Address	tinytext	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
27	Pincode	int(6)		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
28	City	varchar(12)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
29	State	tinytext	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
30	Perm Country	tinytext	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
31	Correspondence Address	tinytext	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
32	Pincode2	int(6)		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
33	City2	tinytext	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
34	State2	tinytext	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
35	Comm Country	tinytext	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
36	Preferred Test City 1	varchar(18)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
37	Preferred Test City 2	varchar(8)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
38	10th Subject/Specialization	varchar(7)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
39	10th Register/Roll No	int(6)		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
40	10th Duration of Course	int(2)		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
41	10th Name of University Board/University	varchar(27)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
42	10th Year of Completion	int(4)		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
43	10th Result	varchar(7)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
44	10th Percentage	int(3)		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
45	12th Degree Name	varchar(11)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
46	12th Subject/Specialization	varchar(7)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
47	12th Register/Roll No	int(7)		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
48	12th Duration of Course	int(1)		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
49	12th Name of University Board/University	varchar(27)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
50	12th Year of Completion	int(4)		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
51	12th Result	varchar(4)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
52	12th Percentage	decimal(3,1)		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
53	UG Degree Name	varchar(4)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
54	UG Subject/Specialization	varchar(7)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
55	UG Register/Roll No	bigint(11)		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
56	UG Duration of Course	int(1)		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
57	UG Name of University Board/University	varchar(20)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
58	UG Year of Completion	int(4)		Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
59	UG Result	varchar(7)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
60	UG Percentage	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
61	PG Degree Name	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
62	PG Subject/Specialization	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
63	PG Register/Roll No	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
64	PG Duration of Course	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
65	PG Name of University Board/University	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
66	PG Year of Completion	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
67	PG Result	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
68	PG Percentage	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
69	PG Integrated Degree Name	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
70	PG Integrated Subject/Specialization	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
71	PG Integrated Register/Roll No	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
72	PG Integrated Duration of Course	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
73	PG Integrated Name of University Board/University	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
74	PG Integrated Year of Completion	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
75	PG Integrated Result	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
76	PG Integrated Percentage	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
77	OTHER Degree Name	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
78	OTHER Subject/Specialization	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
79	OTHER Register/Roll No	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
80	OTHER Duration of Course	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
81	OTHER Name of University Board/University	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
82	OTHER Year of Completion	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
83	OTHER Result	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
84	OTHER Percentage	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
85	Programme Type	varchar(17)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
86	Specialization	varchar(13)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
87	PHD Type	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
88	Exemption for PhD Entrance Exam under Clause	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
89	Specialization Preference 1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
90	Specialization Preference 2	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
91	Specialization Preference 3	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
92	Do you Have Work Experience	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
93	Post Held_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
94	From Date_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
95	TO Date_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
96	Work Experience 1 (Year, Month, days)_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
97	Name of Organization 2_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
98	Post Held_1_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
99	From Date_1_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
100	TO Date_1_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
101	Work Experience 2 (Year, Month, days)_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
102	No of Publications_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
103	Do you Have Work Experience_2	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
104	Name of Organization1_2	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
105	Post Held_2	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
106	From Date_2	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
107	TO Date_2	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
108	Work Experience 1 (Year, Month, days)_2	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
109	Name of Organization 2_2	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
110	Post Held_2_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
111	From Date_2_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
112	TO Date_2_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
113	Work Experience 2 (Year, Month, days)_2	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
114	No of Publications_2	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
115	Do you Have Work Experience_3	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
116	Name of Organization1_3	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
117	Post Held_3	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
118	From Date_3	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
119	TO Date_3	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
120	Work Experience 1 (Year, Month, days)_3	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
121	Name of Organization 2_3	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
122	Post Held_3_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
123	From Date_3_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
124	TO Date_3_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
125	Work Experience 2 (Year, Month, days)_3	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
126	No of Publications_3	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
127	Do you Have Work Experience_4	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
128	Name of Organization1_4	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
129	Post Held_4	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
130	From Date_4	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
131	TO Date_4	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
132	Work Experience 1 (Year, Month, days)_4	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
133	Name of Organization 2_4	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
134	Post Held_4_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
135	From Date_4_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
136	TO Date_4_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
137	Work Experience 2 (Year, Month, days)_4	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
138	No of Publications_4	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
139	Do you Have Work Experience_5	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
140	Name of Organization1_5	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
141	Post Held_5	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
142	From Date_5	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
143	TO Date_5	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
144	Work Experience 1 (Year, Month, days)_5	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
145	Name of Organization 2_5	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
146	Post Held_5_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
147	From Date_5_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
148	TO Date_5_1	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
149	Work Experience 2 (Year, Month, days)_5	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
150	No of Publications_5	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
151	Payment Status	varchar(1)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
152	Payment Date	varchar(29)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
153	Basic Registration Date	varchar(16)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
154	Profile Submission Date	varchar(10)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
155	NSEIT Transaction number	varchar(12)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
156	Status	varchar(21)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
157	Course_Code	varchar(6)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
158	Rank	varchar(6)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
159	Total_Score	varchar(6)	utf8_general_ci	Yes	NULL		Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns

Check all With selected:

Propose table structure

Track table

Move columns

Normalize

Add column(s)

Indexes

Action		Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
Edit	Drop	PRIMARY	BTREE	Yes	No	id	30571	A	No

Partitions

No partitioning defined!

Information

Space usage
Data	25.6	MiB
Index	0	B
Overhead
Effective	25.6	MiB
Total	25.6	MiB

Row statistics
Format	Compact
Collation	latin1_swedish_ci
Next autoindex	30,954
Creation	Feb 02, 2023 at 01:08 PM
Last update	Nov 12, 2024 at 05:42 AM
Last check	Nov 12, 2024 at 05:42 AM

mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

Connection for controluser as defined in your configuration failed.