update query in sql

SQL

DBMS

Update Query may be used to update the existing records in a given table.To update only selected records where clause may also be used in the query as in case of delete query.

Update Query Syntax:

update table-name

set column-name=new value ,column-name=new value,………… where clause(optional);

SQL Delete Query as following

    update student set address='delhi' , fee=30000 where course='bca'

Above query update the address to delhi and fee to 30000 where course is bca.

Python

Java

C

C++

HTML/CSS

Java Script

PHP

SQL

C Programs

update query in sql

SQL Delete Query as following

Video/ C Introduction