Javatpoint Logo
Javatpoint Logo

Update Operation

The UPDATE-SET statement is used to update any column inside the table. The following SQL query is used to update a column.

Consider the following example.

Example

Update Operation

Delete Operation

The DELETE FROM statement is used to delete a specific record from the table. Here, we must impose a condition using WHERE clause otherwise all the records from the table will be removed.

The following SQL query is used to delete the employee detail whose id is 110 from the table.

Consider the following example.

Example

Next TopicJoin Operation




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


B.Tech / MCA