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 :
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
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 bigint(20) unsigned
expense_type enum -- ledger_wise
expense_invoice_no varchar(50)
expense_invoice_date date
voucher_number varchar(50)
voucher_type_id bigint(20) 0
entry_mode enum --
urd enum -- N
voucher_date date
voucher_time time
due_date date
ledger_id int(10) unsigned
party_cat_id int(11) 0
sgst_amount decimal(10,2) 0.00
cgst_amount decimal(10,2) 0.00
igst_amount decimal(10,2) 0.00
cess_amount decimal(10,2) 0.00
round_off decimal(12,2)
price decimal(10,2) 0.00
pri_discount decimal(10,2) 0.00
proportionate_discount decimal(10,2) 0.00
additional_discount decimal(10,2) 0.00
add_charges decimal(10,2) 0.00
item_tax_amount decimal(10,2) 0.00
add_charges_fixed_tax_amount decimal(10,2) 0.00
add_charges_proportionate_tax_amount decimal(10,2) 0.00
tds_amount decimal(10,2) 0.00
freight_charges decimal(10,2) 0.00
payment_status enum -- Pending
narration text
receiver_name varchar(100)
receiver_contact_number varchar(20)
branch_id int(11)
user_id bigint(20) unsigned
modified_user_id bigint(20) unsigned
finance_year_id bigint(20) unsigned
delete_status tinyint(1) 0
is_cancelled enum -- N
created_at datetime current_timestamp()
updated_at datetime
posting_status enum -- Pending
calc_add_discount_from enum -- BASE


Column Type Function Null Value
id bigint(20) unsigned
expense_type enum -- ledger_wise
expense_invoice_no varchar(50)
expense_invoice_date date
voucher_number varchar(50)
voucher_type_id bigint(20) 0
entry_mode enum --
urd enum -- N
voucher_date date
voucher_time time
due_date date
ledger_id int(10) unsigned
party_cat_id int(11) 0
sgst_amount decimal(10,2) 0.00
cgst_amount decimal(10,2) 0.00
igst_amount decimal(10,2) 0.00
cess_amount decimal(10,2) 0.00
round_off decimal(12,2)
price decimal(10,2) 0.00
pri_discount decimal(10,2) 0.00
proportionate_discount decimal(10,2) 0.00
additional_discount decimal(10,2) 0.00
add_charges decimal(10,2) 0.00
item_tax_amount decimal(10,2) 0.00
add_charges_fixed_tax_amount decimal(10,2) 0.00
add_charges_proportionate_tax_amount decimal(10,2) 0.00
tds_amount decimal(10,2) 0.00
freight_charges decimal(10,2) 0.00
payment_status enum -- Pending
narration text
receiver_name varchar(100)
receiver_contact_number varchar(20)
branch_id int(11)
user_id bigint(20) unsigned
modified_user_id bigint(20) unsigned
finance_year_id bigint(20) unsigned
delete_status tinyint(1) 0
is_cancelled enum -- N
created_at datetime current_timestamp()
updated_at datetime
posting_status enum -- Pending
calc_add_discount_from enum -- BASE

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

Continue insertion with rows