Question

explain in depth about UPDATE command​

Answer 1

$\large{\underline{{\boxed{\textbf{Brainliest\:Answer}}}}}$

Defination of Update Command

UPDATE Command is used to update any record of data in a table.

The UPDATE statement is a Structured Query Language (SQL) statement used to change or update values in a table.

It is usually suffixed with a WHERE clause to restrict the change to a set of values that meet a specific set of criteria.

$\pink{\bold{\underline{\underline{ Syntax \: of \: UPDATE\: \: Command :}}}}$

UPDATE table_name SET column_name = new_value WHERE some_condition;

WHERE is used to add a condition to any SQL query.

Details according to SQL

An SQL UPDATE statement changes the data of one or more records in a table. Either all the rows can be updated, or a subset may be chosen using a condition.

$\pink{\bold{\underline{\underline{SQL \:Syntax \: of \: UPDATE\: \: Command :}}}}$

UPDATE table_name SET column_name = value [, column_name = value ...]

Function of SQL Command

An UPDATE statement is used to directly change or modify the values stored in one or more fields in a specified record in a single table.

$\boxed{\bold{{Keep\: Asking\: - \: Be \: Brainly}}}$

Answer 2

Answer:

Kartik pls yr ...jb mai janti hi nhi use kisi pr bhi trust krk ese jaoge(｡ŏ﹏ŏ).........mne v bhejdi req ..but kartik I really love uh yr