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 :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id int(11)
calc_time date
basic_salary double
effective_date date
format_dict longtext utf8mb4_general_ci
payment_mode smallint(6)
increase double
deduction double
increase_formula longtext utf8mb4_general_ci
deduction_formula longtext utf8mb4_general_ci
increase_formula_name longtext utf8mb4_general_ci
deduction_formula_name longtext utf8mb4_general_ci
extra_increase double
extra_deduction double
total_loan_amount double
refund_loan_amount double
unrefund_loan_amount double
loan_deduction double
loan_increase double
advance_increase double
advance_deduction double
reimbursement double
total_increase_formula longtext utf8mb4_general_ci
total_increase_formula_name longtext utf8mb4_general_ci
total_increase_expression longtext utf8mb4_general_ci
total_increase double
total_deduction_formula longtext utf8mb4_general_ci
total_deduction_formula_name longtext utf8mb4_general_ci
total_deduction_expression longtext utf8mb4_general_ci
total_deduction double
total_salary_expression longtext utf8mb4_general_ci
total_salary double
employee_id int(11) Browse foreign values Browse foreign values
calc_end_time date
net_pay double
social_security_deduction double
tax_deduction double
total_income_per_year double
total_tax_deduction_per_year double