Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2 LSP4YOU - Learner's Support Publications

Update Query

Q:4
Update field total with the sum of Sub1, Sub2 and Sub3.


SQL> UPDATE STUDENT SET TOTAL=SUB1+SUB2+SUB3;

6 rows updated.