How to Update records in TABLE, How to DELETE Records from TABLE
This Tutorial is based on use of Update and Delete statements in SQL.
Below are the queries used in the tutorial.
CREATE TABLE football( SNO INT, PLAYER_NAME VARCHAR(25), TOTAL_WEALTH INT)
INSERT INTO football VALUES(1,'WAYNE ROONEY', 112000)
INSERT INTO football VALUES(2,'ZLATAN' ,212000)
INSERT INTO football VALUES(3,'NEYMAR', 312000)
INSERT INTO football VALUES(4,'CHRISTIANO RONALDO', 412000)
INSERT INTO football VALUES(5,'LIONEL MESSI', 512000)
SELECT * FROM football
UPDATE football SET TOTAL_WEALTH= 500000
DELETE FROM football