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
Customize 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
Customize 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 emphasized for SQL query textareas (*2). Restore default value
Documentation Textarea size (rows) in edit mode, this value will be emphasized 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)
records_transactionno varchar(255)
records_processor varchar(25)
records_section varchar(55)
records_workgroup varchar(25)
records_sender varchar(25)
records_address varchar(100)
records_daterecv varchar(55)
records_subject varchar(255)
records_documentsource varchar(25)
records_doctype varchar(25)
records_documentstatus varchar(55)
records_officeorigin varchar(25)
records_dateprocessed text
records_time text
records_receiver varchar(55)
cenro_recvdate varchar(55)
cenro_recvtime varchar(55)
cenro_processor varchar(55)
cenro_workgroup varchar(55)
cenro_section varchar(55)
cenro_priority varchar(55)
cenro_action varchar(55)
cenro_action_others varchar(255)
cenro_receiver varchar(55)
cenro_dateprocessed varchar(55)
cenro_time varchar(55)
section_recvdate varchar(55)
section_recvtime varchar(55)
section_processor varchar(55)
section_workgroup varchar(55)
section_section varchar(55)
section_priority varchar(55)
section_action varchar(55)
section_action_others varchar(255)
section_receiver varchar(55)
section_dateprocessed varchar(55)
section_time varchar(55)
focal_recvdate varchar(25)
focal_recvtime varchar(25)
focal_processor varchar(55)
focal_workgroup varchar(55)
focal_section varchar(55)
focal_action varchar(255)
focal_dateprocessed varchar(25)
focal_time varchar(25)
focal_receiver varchar(55)
section_outgoing_recvdate varchar(25)
section_outgoing_recvtime varchar(25)
section_outgoing_processor varchar(25)
section_outgoing_workgroup varchar(55)
section_outgoing_section varchar(55)
section_outgoing_action varchar(255)
section_outgoing_dateprocessed varchar(25)
section_outgoing_time varchar(25)
cenro_outgoing_recvdate varchar(25)
cenro_outgoing_recvtime varchar(25)
cenro_outgoing_processor varchar(55)
cenro_outgoing_workgroup varchar(55)
cenro_outgoing_section varchar(55)
cenro_outgoing_action varchar(255)
cenro_outgoing_dateprocessed varchar(25)
cenro_outgoing_time varchar(25)
records_outgoing_recvdate varchar(25)
records_outgoing_recvtime varchar(25)
records_outgoing_processor varchar(55)
records_outgoing_workgroup varchar(55)
records_outgoing_section varchar(55)
records_outgoing_action varchar(255)
records_outgoing_dateprocessed varchar(25)
records_outgoing_time varchar(25)
section_reroute_recvdate varchar(25)
section_reroute_recvtime varchar(25)
section_reroute_processor varchar(55)
section_reroute_workgroup varchar(55)
section_reroute_section varchar(55)
section_reroute_remarks varchar(255)
section_reroute_dateprocessed varchar(25)
section_reroute_time varchar(25)
section_reroute_receiver varchar(55)
focal_reroute_recvdate varchar(25)
focal_reroute_recvtime varchar(25)
focal_reroute_processor varchar(55)
focal_reroute_workgroup varchar(55)
focal_reroute_section varchar(55)
focal_reroute_remarks varchar(255)
focal_reroute_dateprocessed varchar(25)
focal_reroute_time varchar(25)
focal_reroute_receiver varchar(55)


Column Type Function Null Value
id int(11)
records_transactionno varchar(255)
records_processor varchar(25)
records_section varchar(55)
records_workgroup varchar(25)
records_sender varchar(25)
records_address varchar(100)
records_daterecv varchar(55)
records_subject varchar(255)
records_documentsource varchar(25)
records_doctype varchar(25)
records_documentstatus varchar(55)
records_officeorigin varchar(25)
records_dateprocessed text
records_time text
records_receiver varchar(55)
cenro_recvdate varchar(55)
cenro_recvtime varchar(55)
cenro_processor varchar(55)
cenro_workgroup varchar(55)
cenro_section varchar(55)
cenro_priority varchar(55)
cenro_action varchar(55)
cenro_action_others varchar(255)
cenro_receiver varchar(55)
cenro_dateprocessed varchar(55)
cenro_time varchar(55)
section_recvdate varchar(55)
section_recvtime varchar(55)
section_processor varchar(55)
section_workgroup varchar(55)
section_section varchar(55)
section_priority varchar(55)
section_action varchar(55)
section_action_others varchar(255)
section_receiver varchar(55)
section_dateprocessed varchar(55)
section_time varchar(55)
focal_recvdate varchar(25)
focal_recvtime varchar(25)
focal_processor varchar(55)
focal_workgroup varchar(55)
focal_section varchar(55)
focal_action varchar(255)
focal_dateprocessed varchar(25)
focal_time varchar(25)
focal_receiver varchar(55)
section_outgoing_recvdate varchar(25)
section_outgoing_recvtime varchar(25)
section_outgoing_processor varchar(25)
section_outgoing_workgroup varchar(55)
section_outgoing_section varchar(55)
section_outgoing_action varchar(255)
section_outgoing_dateprocessed varchar(25)
section_outgoing_time varchar(25)
cenro_outgoing_recvdate varchar(25)
cenro_outgoing_recvtime varchar(25)
cenro_outgoing_processor varchar(55)
cenro_outgoing_workgroup varchar(55)
cenro_outgoing_section varchar(55)
cenro_outgoing_action varchar(255)
cenro_outgoing_dateprocessed varchar(25)
cenro_outgoing_time varchar(25)
records_outgoing_recvdate varchar(25)
records_outgoing_recvtime varchar(25)
records_outgoing_processor varchar(55)
records_outgoing_workgroup varchar(55)
records_outgoing_section varchar(55)
records_outgoing_action varchar(255)
records_outgoing_dateprocessed varchar(25)
records_outgoing_time varchar(25)
section_reroute_recvdate varchar(25)
section_reroute_recvtime varchar(25)
section_reroute_processor varchar(55)
section_reroute_workgroup varchar(55)
section_reroute_section varchar(55)
section_reroute_remarks varchar(255)
section_reroute_dateprocessed varchar(25)
section_reroute_time varchar(25)
section_reroute_receiver varchar(55)
focal_reroute_recvdate varchar(25)
focal_reroute_recvtime varchar(25)
focal_reroute_processor varchar(55)
focal_reroute_workgroup varchar(55)
focal_reroute_section varchar(55)
focal_reroute_remarks varchar(255)
focal_reroute_dateprocessed varchar(25)
focal_reroute_time varchar(25)
focal_reroute_receiver varchar(55)

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

Continue insertion with rows