Update Operation

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

原创文章,作者:ItWorker,如若转载,请注明出处:https://blog.ytso.com/263638.html

(0)
上一篇 2022年5月30日
下一篇 2022年5月30日

相关推荐

发表回复

登录后才能评论