Recent
Favorites

Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: sams »Table: registered_20
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

Edit mode

Customize edit mode.

Documentation Disallow BLOB and BINARY columns from editing.
Documentation Display the function fields in edit/insert mode.
Documentation Defines whether or not type fields should be initially displayed in edit/insert mode.
Documentation How many rows can be inserted at one time.
Documentation Sort order for items in a foreign-key dropdown box; content is the referenced data, id is the key value.
Documentation A dropdown will be used if fewer items are present.
Text fields

Customize text input fields.

Documentation Defines which type of editing controls should be used for CHAR and VARCHAR columns; input - allows limiting of input length, textarea - allows newlines in columns.
Documentation Defines the minimum size for input fields generated for CHAR and VARCHAR columns.
Documentation Defines the maximum size for input fields generated for CHAR and VARCHAR columns.
Documentation Number of columns for CHAR/VARCHAR textareas.
Documentation Number of rows for CHAR/VARCHAR textareas.
Documentation Textarea size (columns) in edit mode, this value will be emphasized for SQL query textareas (*2).
Documentation Textarea size (rows) in edit mode, this value will be emphasized for SQL query textareas (*2).
Documentation Double size of textarea for LONGTEXT columns.
ColumnTypeFunctionNullValue
idint(11)
User Reg Idvarchar(10)
Application No.int(5)
Candidate Nametinytext
Gendervarchar(6)
Single Child (if Female)varchar(2)
Fathers Nametinytext
Mothers Nametinytext
Guardians Nametinytext
Parents Guardians Contact Nobigint(10)
Date of Birthdate
Age as on 1/4/2020int(2)
Email Idtinytext
Mobile No.bigint(10)
Categoryvarchar(20)
Differently Abledvarchar(2)
Disability Categoryvarchar(10)
Are you a Defense Personnelvarchar(2)
Religionvarchar(9)
Other Religionvarchar(10)
Nationalityvarchar(6)
Are you Native of Puducherry Union Territoryvarchar(2)
Native / Residence of Karaikalvarchar(10)
Are you Domicile of Jammu & Kashmirvarchar(2)
Are you from URBAN/RURAL areavarchar(5)
Permanent Addresstinytext
Pincodeint(6)
Cityvarchar(12)
Statetinytext
Perm Countrytinytext
Correspondence Addresstinytext
Pincode2int(6)
City2tinytext
State2tinytext
Comm Countrytinytext
Preferred Test City 1varchar(18)
Preferred Test City 2varchar(8)
10th Subject/Specializationvarchar(7)
10th Register/Roll Noint(6)
10th Duration of Courseint(2)
10th Name of University Board/Universityvarchar(27)
10th Year of Completionint(4)
10th Resultvarchar(7)
10th Percentageint(3)
12th Degree Namevarchar(11)
12th Subject/Specializationvarchar(7)
12th Register/Roll Noint(7)
12th Duration of Courseint(1)
12th Name of University Board/Universityvarchar(27)
12th Year of Completionint(4)
12th Resultvarchar(4)
12th Percentagedecimal(3,1)
UG Degree Namevarchar(4)
UG Subject/Specializationvarchar(7)
UG Register/Roll Nobigint(11)
UG Duration of Courseint(1)
UG Name of University Board/Universityvarchar(20)
UG Year of Completionint(4)
UG Resultvarchar(7)
UG Percentagevarchar(10)
PG Degree Namevarchar(10)
PG Subject/Specializationvarchar(10)
PG Register/Roll Novarchar(10)
PG Duration of Coursevarchar(10)
PG Name of University Board/Universityvarchar(10)
PG Year of Completionvarchar(10)
PG Resultvarchar(10)
PG Percentagevarchar(10)
PG Integrated Degree Namevarchar(10)
PG Integrated Subject/Specializationvarchar(10)
PG Integrated Register/Roll Novarchar(10)
PG Integrated Duration of Coursevarchar(10)
PG Integrated Name of University Board/Universityvarchar(10)
PG Integrated Year of Completionvarchar(10)
PG Integrated Resultvarchar(10)
PG Integrated Percentagevarchar(10)
OTHER Degree Namevarchar(10)
OTHER Subject/Specializationvarchar(10)
OTHER Register/Roll Novarchar(10)
OTHER Duration of Coursevarchar(10)
OTHER Name of University Board/Universityvarchar(10)
OTHER Year of Completionvarchar(10)
OTHER Resultvarchar(10)
OTHER Percentagevarchar(10)
Programme Typevarchar(17)
Specializationvarchar(13)
PHD Typevarchar(10)
Exemption for PhD Entrance Exam under Clausevarchar(10)
Specialization Preference 1varchar(10)
Specialization Preference 2varchar(10)
Specialization Preference 3varchar(10)
Do you Have Work Experiencevarchar(10)
Post Held_1varchar(10)
From Date_1varchar(10)
TO Date_1varchar(10)
Work Experience 1 (Year, Month, days)_1varchar(10)
Name of Organization 2_1varchar(10)
Post Held_1_1varchar(10)
From Date_1_1varchar(10)
TO Date_1_1varchar(10)
Work Experience 2 (Year, Month, days)_1varchar(10)
No of Publications_1varchar(10)
Do you Have Work Experience_2varchar(10)
Name of Organization1_2varchar(10)
Post Held_2varchar(10)
From Date_2varchar(10)
TO Date_2varchar(10)
Work Experience 1 (Year, Month, days)_2varchar(10)
Name of Organization 2_2varchar(10)
Post Held_2_1varchar(10)
From Date_2_1varchar(10)
TO Date_2_1varchar(10)
Work Experience 2 (Year, Month, days)_2varchar(10)
No of Publications_2varchar(10)
Do you Have Work Experience_3varchar(10)
Name of Organization1_3varchar(10)
Post Held_3varchar(10)
From Date_3varchar(10)
TO Date_3varchar(10)
Work Experience 1 (Year, Month, days)_3varchar(10)
Name of Organization 2_3varchar(10)
Post Held_3_1varchar(10)
From Date_3_1varchar(10)
TO Date_3_1varchar(10)
Work Experience 2 (Year, Month, days)_3varchar(10)
No of Publications_3varchar(10)
Do you Have Work Experience_4varchar(10)
Name of Organization1_4varchar(10)
Post Held_4varchar(10)
From Date_4varchar(10)
TO Date_4varchar(10)
Work Experience 1 (Year, Month, days)_4varchar(10)
Name of Organization 2_4varchar(10)
Post Held_4_1varchar(10)
From Date_4_1varchar(10)
TO Date_4_1varchar(10)
Work Experience 2 (Year, Month, days)_4varchar(10)
No of Publications_4varchar(10)
Do you Have Work Experience_5varchar(10)
Name of Organization1_5varchar(10)
Post Held_5varchar(10)
From Date_5varchar(10)
TO Date_5varchar(10)
Work Experience 1 (Year, Month, days)_5varchar(10)
Name of Organization 2_5varchar(10)
Post Held_5_1varchar(10)
From Date_5_1varchar(10)
TO Date_5_1varchar(10)
Work Experience 2 (Year, Month, days)_5varchar(10)
No of Publications_5varchar(10)
Payment Statusvarchar(1)
Payment Datevarchar(29)
Basic Registration Datevarchar(16)
Profile Submission Datevarchar(10)
NSEIT Transaction numbervarchar(12)
Statusvarchar(21)
Course_Codevarchar(6)
Rankvarchar(6)
Total_Scorevarchar(6)


ColumnTypeFunctionNullValue
idint(11)
User Reg Idvarchar(10)
Application No.int(5)
Candidate Nametinytext
Gendervarchar(6)
Single Child (if Female)varchar(2)
Fathers Nametinytext
Mothers Nametinytext
Guardians Nametinytext
Parents Guardians Contact Nobigint(10)
Date of Birthdate
Age as on 1/4/2020int(2)
Email Idtinytext
Mobile No.bigint(10)
Categoryvarchar(20)
Differently Abledvarchar(2)
Disability Categoryvarchar(10)
Are you a Defense Personnelvarchar(2)
Religionvarchar(9)
Other Religionvarchar(10)
Nationalityvarchar(6)
Are you Native of Puducherry Union Territoryvarchar(2)
Native / Residence of Karaikalvarchar(10)
Are you Domicile of Jammu & Kashmirvarchar(2)
Are you from URBAN/RURAL areavarchar(5)
Permanent Addresstinytext
Pincodeint(6)
Cityvarchar(12)
Statetinytext
Perm Countrytinytext
Correspondence Addresstinytext
Pincode2int(6)
City2tinytext
State2tinytext
Comm Countrytinytext
Preferred Test City 1varchar(18)
Preferred Test City 2varchar(8)
10th Subject/Specializationvarchar(7)
10th Register/Roll Noint(6)
10th Duration of Courseint(2)
10th Name of University Board/Universityvarchar(27)
10th Year of Completionint(4)
10th Resultvarchar(7)
10th Percentageint(3)
12th Degree Namevarchar(11)
12th Subject/Specializationvarchar(7)
12th Register/Roll Noint(7)
12th Duration of Courseint(1)
12th Name of University Board/Universityvarchar(27)
12th Year of Completionint(4)
12th Resultvarchar(4)
12th Percentagedecimal(3,1)
UG Degree Namevarchar(4)
UG Subject/Specializationvarchar(7)
UG Register/Roll Nobigint(11)
UG Duration of Courseint(1)
UG Name of University Board/Universityvarchar(20)
UG Year of Completionint(4)
UG Resultvarchar(7)
UG Percentagevarchar(10)
PG Degree Namevarchar(10)
PG Subject/Specializationvarchar(10)
PG Register/Roll Novarchar(10)
PG Duration of Coursevarchar(10)
PG Name of University Board/Universityvarchar(10)
PG Year of Completionvarchar(10)
PG Resultvarchar(10)
PG Percentagevarchar(10)
PG Integrated Degree Namevarchar(10)
PG Integrated Subject/Specializationvarchar(10)
PG Integrated Register/Roll Novarchar(10)
PG Integrated Duration of Coursevarchar(10)
PG Integrated Name of University Board/Universityvarchar(10)
PG Integrated Year of Completionvarchar(10)
PG Integrated Resultvarchar(10)
PG Integrated Percentagevarchar(10)
OTHER Degree Namevarchar(10)
OTHER Subject/Specializationvarchar(10)
OTHER Register/Roll Novarchar(10)
OTHER Duration of Coursevarchar(10)
OTHER Name of University Board/Universityvarchar(10)
OTHER Year of Completionvarchar(10)
OTHER Resultvarchar(10)
OTHER Percentagevarchar(10)
Programme Typevarchar(17)
Specializationvarchar(13)
PHD Typevarchar(10)
Exemption for PhD Entrance Exam under Clausevarchar(10)
Specialization Preference 1varchar(10)
Specialization Preference 2varchar(10)
Specialization Preference 3varchar(10)
Do you Have Work Experiencevarchar(10)
Post Held_1varchar(10)
From Date_1varchar(10)
TO Date_1varchar(10)
Work Experience 1 (Year, Month, days)_1varchar(10)
Name of Organization 2_1varchar(10)
Post Held_1_1varchar(10)
From Date_1_1varchar(10)
TO Date_1_1varchar(10)
Work Experience 2 (Year, Month, days)_1varchar(10)
No of Publications_1varchar(10)
Do you Have Work Experience_2varchar(10)
Name of Organization1_2varchar(10)
Post Held_2varchar(10)
From Date_2varchar(10)
TO Date_2varchar(10)
Work Experience 1 (Year, Month, days)_2varchar(10)
Name of Organization 2_2varchar(10)
Post Held_2_1varchar(10)
From Date_2_1varchar(10)
TO Date_2_1varchar(10)
Work Experience 2 (Year, Month, days)_2varchar(10)
No of Publications_2varchar(10)
Do you Have Work Experience_3varchar(10)
Name of Organization1_3varchar(10)
Post Held_3varchar(10)
From Date_3varchar(10)
TO Date_3varchar(10)
Work Experience 1 (Year, Month, days)_3varchar(10)
Name of Organization 2_3varchar(10)
Post Held_3_1varchar(10)
From Date_3_1varchar(10)
TO Date_3_1varchar(10)
Work Experience 2 (Year, Month, days)_3varchar(10)
No of Publications_3varchar(10)
Do you Have Work Experience_4varchar(10)
Name of Organization1_4varchar(10)
Post Held_4varchar(10)
From Date_4varchar(10)
TO Date_4varchar(10)
Work Experience 1 (Year, Month, days)_4varchar(10)
Name of Organization 2_4varchar(10)
Post Held_4_1varchar(10)
From Date_4_1varchar(10)
TO Date_4_1varchar(10)
Work Experience 2 (Year, Month, days)_4varchar(10)
No of Publications_4varchar(10)
Do you Have Work Experience_5varchar(10)
Name of Organization1_5varchar(10)
Post Held_5varchar(10)
From Date_5varchar(10)
TO Date_5varchar(10)
Work Experience 1 (Year, Month, days)_5varchar(10)
Name of Organization 2_5varchar(10)
Post Held_5_1varchar(10)
From Date_5_1varchar(10)
TO Date_5_1varchar(10)
Work Experience 2 (Year, Month, days)_5varchar(10)
No of Publications_5varchar(10)
Payment Statusvarchar(1)
Payment Datevarchar(29)
Basic Registration Datevarchar(16)
Profile Submission Datevarchar(10)
NSEIT Transaction numbervarchar(12)
Statusvarchar(21)
Course_Codevarchar(6)
Rankvarchar(6)
Total_Scorevarchar(6)

   and then   
Use TAB key to move from value to value, or CTRL+arrows to move anywhere.

Continue insertion with rows
mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.