Advertisements
Advertisements
प्रश्न
What is the use of UPDATE command in SQL?
उत्तर
The 'UPDATE' command in SQL is used to modify existing records in a database table. It allows you to change the values of one or more columns for one or more rows in a table based on specific criteria defined by a 'WHERE' clause. If the 'WHERE' clause is omitted, all rows in the table will be updated with the new value, which should be done with caution.
APPEARS IN
संबंधित प्रश्न
Give any two basic commands of SQL.
What is a view in SQL?
Give any two differences between Static (embedded) SQL and Dynamic SQL.
Which one of the following is the shortcut key in MS Excel to 'undo the last action'?
Which one of the following files contains one or more worksheets to organise data?
Which programming language is used to write a Macro in MS Excel?
Name the DBMS language component which can be embedded in a programme.
The fill function can be ______ to complete formulas in a range.
Give any two reasons to show that a blank space or zero is not the same as NULL value in SQL.
What are the SQL statements used in Database testing to manipulate the test table?
