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. The UPDATE statement has the following form: UPDATE table_name SET column_name = value [, column_name = value ...] [WHERE condition] For the UPDATE to be successful, the user must have data manipulation privileges (UPDATE privilege) on the table or column and the updated value must not conflict with all the applicable constraints (such as primary keys, unique indexes, CHECK constraints, and NOT NULL constraints).

Property Value
dbo:abstract
  • 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. The UPDATE statement has the following form: UPDATE table_name SET column_name = value [, column_name = value ...] [WHERE condition] For the UPDATE to be successful, the user must have data manipulation privileges (UPDATE privilege) on the table or column and the updated value must not conflict with all the applicable constraints (such as primary keys, unique indexes, CHECK constraints, and NOT NULL constraints). In some databases, such as PostgreSQL, when a FROM clause is present, what essentially happens is that the target table is joined to the tables mentioned in the fromlist, and each output row of the join represents an update operation for the target table. When using FROM, one should ensure that the join produces at most one output row for each row to be modified. In other words, a target row shouldn't join to more than one row from the other table(s). If it does, then only one of the join rows will be used to update the target row, but which one will be used is not readily predictable. Because of this indeterminacy, referencing other tables only within sub-selects is safer, though often harder to read and slower than using a join. (en)
  • Een UPDATE-opdracht in SQL wijzigt gegevens in één of meerdere records van een database. UPDATE wordt gebruikt in de volgende vorm: UPDATE tabelnaam SET kolomnaam1 = waarde1 [, kolomnaam2 = waarde2 ...] [WHERE criteria] Opdat de UPDATE-opdracht zou lukken moet de gebruiker de nodige machtigingen hebben voor het wijzigen van data, de nieuwe waarde mag geen conflict geven met de geldende constraints (zoals primaire sleutels, unieke indexen en constraints). (nl)
  • UPDATEステートメントは、SQL におけるデータ操作言語 (DML) のステートメントの1つで、テーブル内の1つもしくは複数のレコードのデータを更新する。WHERE句が省略されている場合はすべてのレコードが、指定されている場合はその条件式を満たす一部のレコードだけが、一括して更新される。 (ja)
  • Update é uma instrução da linguagem SQL que altera os dados de um ou mais registros em uma tabela. Nem todas as linhas precisam ser atualizadas, um subconjunto pode ser escolhido utilizando uma condição. (pt)
  • UPDATE — оператор языка SQL, позволяющий обновить значения в заданных столбцах таблицы. (ru)
  • 以下是Update陳述式的語法: UPDATE 資料表名稱 SET [欄位名稱1 = 值1], [ 欄位名稱2 = 值2], [ 欄位名稱3 = 值 ...] [WHERE 條件式] UPDATE若要能成功,使用者必須要有欄位或是資料表的資料存取權限(UPDATE權限),而且更新的值不可違背資料表的限制條件(如主鍵、唯一索引、檢查限制或非空值等限制)。 (zh)
dbo:wikiPageID
  • 1220573 (xsd:integer)
dbo:wikiPageRevisionID
  • 645787532 (xsd:integer)
dct:subject
rdfs:comment
  • Een UPDATE-opdracht in SQL wijzigt gegevens in één of meerdere records van een database. UPDATE wordt gebruikt in de volgende vorm: UPDATE tabelnaam SET kolomnaam1 = waarde1 [, kolomnaam2 = waarde2 ...] [WHERE criteria] Opdat de UPDATE-opdracht zou lukken moet de gebruiker de nodige machtigingen hebben voor het wijzigen van data, de nieuwe waarde mag geen conflict geven met de geldende constraints (zoals primaire sleutels, unieke indexen en constraints). (nl)
  • UPDATEステートメントは、SQL におけるデータ操作言語 (DML) のステートメントの1つで、テーブル内の1つもしくは複数のレコードのデータを更新する。WHERE句が省略されている場合はすべてのレコードが、指定されている場合はその条件式を満たす一部のレコードだけが、一括して更新される。 (ja)
  • Update é uma instrução da linguagem SQL que altera os dados de um ou mais registros em uma tabela. Nem todas as linhas precisam ser atualizadas, um subconjunto pode ser escolhido utilizando uma condição. (pt)
  • UPDATE — оператор языка SQL, позволяющий обновить значения в заданных столбцах таблицы. (ru)
  • 以下是Update陳述式的語法: UPDATE 資料表名稱 SET [欄位名稱1 = 值1], [ 欄位名稱2 = 值2], [ 欄位名稱3 = 值 ...] [WHERE 條件式] UPDATE若要能成功,使用者必須要有欄位或是資料表的資料存取權限(UPDATE權限),而且更新的值不可違背資料表的限制條件(如主鍵、唯一索引、檢查限制或非空值等限制)。 (zh)
  • 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. The UPDATE statement has the following form: UPDATE table_name SET column_name = value [, column_name = value ...] [WHERE condition] For the UPDATE to be successful, the user must have data manipulation privileges (UPDATE privilege) on the table or column and the updated value must not conflict with all the applicable constraints (such as primary keys, unique indexes, CHECK constraints, and NOT NULL constraints). (en)
rdfs:label
  • Update (SQL) (en)
  • UPDATE (SQL) (ja)
  • Update (SQL) (nl)
  • Update (SQL) (ru)
  • Update (SQL) (pt)
  • Update (zh)
owl:sameAs
prov:wasDerivedFrom
foaf:isPrimaryTopicOf
is dbo:wikiPageDisambiguates of
is dbo:wikiPageRedirects of
is foaf:primaryTopic of