Update MySql tabel depending on cell values

Update MySql tabel depending on cell values

References

Reference NO 1

http://stackoverflow.com/questions/16730722/how-to-update-mysql-database-table-cell-based-on-the-values-in-other-cell

Reference NO 2

http://stackoverflow.com/questions/18026242/how-to-update-mysql-table-row-in-which-cell-values-are-greater-than-n

Reference NO 3

http://forums.mysql.com/read.php?10,1354114521,newer

Reference NO 4

http://answers.yahoo.com/question/index?qid=20110701114311AAoqaBh

Reference NO 5

http://dba.stackexchange.com/questions/21152/how-to-update-one-table-based-on-another-tables-values-on-the-fly

Reference NO 6

https://forums.digitalpoint.com/threads/how-to-update-more-than-one-cell-in-mysql-update-statement.902371/

Reference NO 7

http://www.howtoplaza.com/how-to-update-or-change-data-in-a-mysql-table

Reference NO 8

http://php.about.com/od/learnmysql/ss/mysql_data_2.htm