Update OperationThe 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![]() Delete OperationThe 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
|
JavaTpoint offers too many high quality services. Mail us on h[email protected], to get more information about given services.
JavaTpoint offers college campus training on Core Java, Advance Java, .Net, Android, Hadoop, PHP, Web Technology and Python. Please mail your requirement at [email protected].
Duration: 1 week to 2 week