Question

what are the manipulation operations that can be done on a table​

Answer 1

A “Data manipulation language (DML)” is also called as a computer programming language, it is used to manipulate the data. The manipulation operations involves like to SELECT, INSERT, DELETE and UPDATE the data into the SQL database.

SELECT - We can select one or more data from the table.

Syntax:  Select column1 from table_name

INSERT - We can insert one or more values into the table by using insert command.

Syntax: Insert into table_name (column1, column2) values (value1, value2)

DELETE - We can delete one or more data with the specify condition from the table.

Syntax: Delete from table_name where condition;

UPDATE - We can update the data table values by using update command.

Syntax: Update table_ name  Set column = value Where specific _condition;

Answer 2

Answer:

Answer

• SELECT - We can select one or more data from the table. ...

• INSERT - We can insert one or more values into the table by using insert command. ...

• DELETE - We can delete one or more data with the specify condition from the table. ...

• UPDATE - We can update the data table values by using update command.

~♥~~♥~~♥~~♥~~♥~~♥~~♥~

armyy