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 :
Edit mode
Customise edit mode.
Edit mode
Documentation Disallow BLOB and BINARY columns from editing. Restore default value
Documentation Display the function fields in edit/insert mode. Restore default value
Documentation Defines whether or not type fields should be initially displayed in edit/insert mode. Restore default value
Documentation How many rows can be inserted at one time. Restore default value
Documentation Sort order for items in a foreign-key dropdown box; content is the referenced data, id is the key value. Restore default value
Documentation A dropdown will be used if fewer items are present. Restore default value
Text fields
Customise text input fields.
Text 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. Restore default value
Documentation Defines the minimum size for input fields generated for CHAR and VARCHAR columns. Restore default value
Documentation Defines the maximum size for input fields generated for CHAR and VARCHAR columns. Restore default value
Documentation Number of columns for CHAR/VARCHAR textareas. Restore default value
Documentation Number of rows for CHAR/VARCHAR textareas. Restore default value
Documentation Textarea size (columns) in edit mode, this value will be emphasised for SQL query textareas (*2). Restore default value
Documentation Textarea size (rows) in edit mode, this value will be emphasised for SQL query textareas (*2). Restore default value
Documentation Double size of textarea for LONGTEXT columns. Restore default value
Column Type Function Null Value
ID int(11)
TYPE int(11)
IS_SAVE int(11)
IS_RESET int(11)
STATUS int(11)
CURRENT_OFFICE_NAME varchar(255)
CURRENT_DESIGNATION_MASTER varchar(255)
CURRENT_SERVICE_GROUP varchar(255)
CURRENT_LEVEL varchar(50)
DOB varchar(20)
CURRENT_POST_DATE varchar(20)
CURRENT_POST_DATE_ENG varchar(255)
CURRENT_POST_HELD_DATE varchar(255)
ADDRESS_IR_NO varchar(255)
MASTER_DISTRICT int(11)
MASTER_TEMPORARY_DISTRICT varchar(250)
MASTER_TEMPORARY_ADDRESS varchar(250)
PRESENT_TYPE int(11)
REASON_FOR_TRANSFER text
RESPONSE text
NAME varchar(255)
NAME_ENG varchar(200)
EMPLOYEE_SN varchar(200)
PHONE_NUMBER varchar(255)
EMAIL_ADDRESS varchar(255)
STATE int(11)
VOUGOLIK varchar(100)
PAHILA_KARYA_GAREU varchar(100)
GHAR_PAYAKS varchar(100)
PATI_PATNI varchar(100)
EMP_AGE varchar(100)
FAJIL_YES_NO varchar(100)
TALIM_KAJ_GAYEKO varchar(100)
SAHAMATI_PATRA varchar(100)
RIKTA_AWASTHA varchar(100)
PADHMA_NIYUKTI varchar(100)
AWAKASH_HUNE_AWADHI varchar(100)
HAJIR_DIN varchar(11)
sign varchar(255)
CREATED_AT timestamp current_timestamp()
CREATED_BY int(11)
UPDATED_BY int(11)
UPDATED_AT timestamp
is_complete tinyint(1) 0


Column Type Function Null Value
ID int(11)
TYPE int(11)
IS_SAVE int(11)
IS_RESET int(11)
STATUS int(11)
CURRENT_OFFICE_NAME varchar(255)
CURRENT_DESIGNATION_MASTER varchar(255)
CURRENT_SERVICE_GROUP varchar(255)
CURRENT_LEVEL varchar(50)
DOB varchar(20)
CURRENT_POST_DATE varchar(20)
CURRENT_POST_DATE_ENG varchar(255)
CURRENT_POST_HELD_DATE varchar(255)
ADDRESS_IR_NO varchar(255)
MASTER_DISTRICT int(11)
MASTER_TEMPORARY_DISTRICT varchar(250)
MASTER_TEMPORARY_ADDRESS varchar(250)
PRESENT_TYPE int(11)
REASON_FOR_TRANSFER text
RESPONSE text
NAME varchar(255)
NAME_ENG varchar(200)
EMPLOYEE_SN varchar(200)
PHONE_NUMBER varchar(255)
EMAIL_ADDRESS varchar(255)
STATE int(11)
VOUGOLIK varchar(100)
PAHILA_KARYA_GAREU varchar(100)
GHAR_PAYAKS varchar(100)
PATI_PATNI varchar(100)
EMP_AGE varchar(100)
FAJIL_YES_NO varchar(100)
TALIM_KAJ_GAYEKO varchar(100)
SAHAMATI_PATRA varchar(100)
RIKTA_AWASTHA varchar(100)
PADHMA_NIYUKTI varchar(100)
AWAKASH_HUNE_AWADHI varchar(100)
HAJIR_DIN varchar(11)
sign varchar(255)
CREATED_AT timestamp current_timestamp()
CREATED_BY int(11)
UPDATED_BY int(11)
UPDATED_AT timestamp
is_complete tinyint(1) 0

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

Continue insertion with rows