can i have a cron job that does this? :
say i have 3 columns in a table
col1 percent col3
100 20.0
95 20.0
75 15.0
i need to take values from col1 (100,95,75) and get the percentage (20%,20%,15%) of those values. then update col3 to reflect the percentage ie; 20% of 100 =20 (col3)
but, only the rows with no value in col3 need to be updated
am i making sense?
say i have 3 columns in a table
col1 percent col3
100 20.0
95 20.0
75 15.0
i need to take values from col1 (100,95,75) and get the percentage (20%,20%,15%) of those values. then update col3 to reflect the percentage ie; 20% of 100 =20 (col3)
but, only the rows with no value in col3 need to be updated
am i making sense?