About: Update (SQL)   Goto Sponge  NotDistinct  Permalink

An Entity of Type : owl:Thing, within Data Space : dbpedia.org associated with source document(s)

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).

AttributesValues
rdfs:label
  • Update (SQL)
  • UPDATE (SQL)
  • Update (SQL)
  • Update (SQL)
  • Update (SQL)
  • Update
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).
  • UPDATEステートメントは、SQL におけるデータ操作言語 (DML) のステートメントの1つで、テーブル内の1つもしくは複数のレコードのデータを更新する。WHERE句が省略されている場合はすべてのレコードが、指定されている場合はその条件式を満たす一部のレコードだけが、一括して更新される。
  • 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.
  • UPDATE — оператор языка SQL, позволяющий обновить значения в заданных столбцах таблицы.
  • 以下是Update陳述式的語法: UPDATE 資料表名稱 SET [欄位名稱1 = 值1], [ 欄位名稱2 = 值2], [ 欄位名稱3 = 值 ...] [WHERE 條件式] UPDATE若要能成功,使用者必須要有欄位或是資料表的資料存取權限(UPDATE權限),而且更新的值不可違背資料表的限制條件(如主鍵、唯一索引、檢查限制或非空值等限制)。
  • 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).
sameAs
dct:subject
Wikipage page ID
Wikipage revision ID
Link from a Wikipage to another Wikipage
foaf:isPrimaryTopicOf
prov:wasDerivedFrom
has 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.
  • 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).
  • UPDATEステートメントは、SQL におけるデータ操作言語 (DML) のステートメントの1つで、テーブル内の1つもしくは複数のレコードのデータを更新する。WHERE句が省略されている場合はすべてのレコードが、指定されている場合はその条件式を満たす一部のレコードだけが、一括して更新される。
  • 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.
  • UPDATE — оператор языка SQL, позволяющий обновить значения в заданных столбцах таблицы.
  • 以下是Update陳述式的語法: UPDATE 資料表名稱 SET [欄位名稱1 = 值1], [ 欄位名稱2 = 值2], [ 欄位名稱3 = 值 ...] [WHERE 條件式] UPDATE若要能成功,使用者必須要有欄位或是資料表的資料存取權限(UPDATE權限),而且更新的值不可違背資料表的限制條件(如主鍵、唯一索引、檢查限制或非空值等限制)。
http://purl.org/voc/vrank#hasRank
is Link from a Wikipage to another Wikipage of
is Wikipage redirect of
is Wikipage disambiguates of
is foaf:primaryTopic of
Faceted Search & Find service v1.17_git21 as of Mar 09 2019


Alternative Linked Data Documents: PivotViewer | iSPARQL | ODE     Content Formats:       RDF       ODATA       Microdata      About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 07.20.3230 as of Apr 1 2019, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (61 GB total memory)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2019 OpenLink Software