hi I have a problem, what mysql script should I use on this.
assuming i have 2 tables
total used is 4, total left is 1 its like dfference script
table_used
4
table_left
5(default)
helo
Moderator: General Moderators
Re: helo
Could you try to elaborate on that a little, please? It's unclear what you're trying to do.
Re: helo
im trying to create two tables for my system.
table1
empID = 001
date = 11/15/2011
sickleave = 1
vacationleave =
holiday =
date = 11/16/2011
empID = 001
sickleave = 1
vacationleave = 1
holiday =
date = 11/17/2011
empID = 001
sickleave = 1
vacationleave = 1
holiday = 1
I want my data in table 1 to subtract in my table2.
table2(this is default total leave per employee.)
empID = 1
sickleave = 5
vacationleave = 5
holiday = 5
the result will look like this
empID | date | Sick Leave | Vacation Leave | Holiday |
001 11/15/2011 1
001 11/16/2011 1
001 11/17/2011 1
Reserve Sick Leave | 4
REserve Vacation Leave | 4
Reserve Holiday Leave | 4
table1
empID = 001
date = 11/15/2011
sickleave = 1
vacationleave =
holiday =
date = 11/16/2011
empID = 001
sickleave = 1
vacationleave = 1
holiday =
date = 11/17/2011
empID = 001
sickleave = 1
vacationleave = 1
holiday = 1
I want my data in table 1 to subtract in my table2.
table2(this is default total leave per employee.)
empID = 1
sickleave = 5
vacationleave = 5
holiday = 5
the result will look like this
empID | date | Sick Leave | Vacation Leave | Holiday |
001 11/15/2011 1
001 11/16/2011 1
001 11/17/2011 1
Reserve Sick Leave | 4
REserve Vacation Leave | 4
Reserve Holiday Leave | 4