Question

what is the sql commands
​

Answer 1

Answer:

• INSERT is used to insert a new row in a relation/table.

e.g. Consider a table called STUDENT with columns in the order:

Roll No, Name, Class..

To insert data, the command is:

INSERT INTO STUDENT values ( 1, ABC, 12 );

• UPDATE is used to update values in an existing row in a relation/table.

Consider the same relation as above, to update values, the SQL command is:

UPDATE STUDENT SET Name=XYZ where RollNo = 1;

Explanation: