Computer scienceFundamentalsSQL and DatabasesBasics SQLData Modification Language

Updating selected rows

Query parts

Report a typo

Here is an update query:

UPDATE music SET is_trending = false WHERE genre = 'Alternative rock'

Match parts of the query with what their roles are:

Match the items from left and right columns

'Alternative rock'

music

false

UPDATE

is_trending

WHERE

a query type specifier

new value for the specified column

start of the condition clause

a column to update values in

a value that rows being updated must currently have

table name

___

Create a free account to access the full topic