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 :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id int(10)
YearMonth int(11)
EmplID int(11)
CalculationDate date
WorkDays int(10)
WorkDaysInMonth int(10)
BasicSalary decimal(12,2)
BasicSalaryManual tinyint(3)
Allowances decimal(12,2)
AllowancesManual tinyint(3)
RegularBonus decimal(12,2)
IrregularBonus decimal(12,2)
IrregularBonusManual tinyint(3)
PaidAdvance decimal(12,2)
RepaymentOfLoan decimal(12,2)
RepaymentOfLoanManual tinyint(3)
IncomeTax decimal(12,2)
IncomeTaxManual tinyint(3)
OtherTaxes decimal(12,2)
EmplSocialSecurity decimal(12,2)
EmplSocialSecurityPercent decimal(12,2)
CompSocialSecurity decimal(12,2)
CompSocialSecurityPercent decimal(12,2)
SocialSecurityTotal decimal(12,2)
EmplSocialSecurityGov decimal(12,2)
EmplSocialSecurityPercentGov decimal(12,2)
CompSocialSecurityGov decimal(12,2)
CompSocialSecurityPercentGov decimal(12,2)
SocialSecurityTotalGov decimal(12,2)
EmplSocialSecurityInj decimal(12,2)
EmplSocialSecurityPercentInj decimal(12,2)
CompSocialSecurityInj decimal(12,2)
CompSocialSecurityPercentInj decimal(12,2)
SocialSecurityTotalInj decimal(12,2)
InsurenceAmount decimal(12,2)
Brutto decimal(12,2)
Payment decimal(12,2)
Calculated tinyint(3)
CountPaidDayForBasicSalary int(11)
NotPaidDaysForBasicSalary text utf8mb4_general_ci
SettlementDate date
status int(11)
deleted int(11)
addedOn datetime
addedBy int(11)
modifiedBy int(11)
modifiedOn timestamp
Extra decimal(10,2)
Minus decimal(12,2)