Share on Facebook Share on Twitter Email
Answers.com

update

 
Dictionary: up·date   (ŭp-dāt') pronunciation
 
tr.v., -dat·ed, -dat·ing, -dates.

To bring up to date: update a textbook; update the files.

n. (ŭp'dāt')
  1. Information that updates something.
  2. The act or an instance of bringing something up to date.
  3. An updated version of something.

Search unanswered questions...
Enter a word or phrase...
All Community Q&A Reference topics
 

To change data in a file or database.

Update and Edit

The terms "update" and "edit" are often used synonymously, although "update" is more often used to refer to changes in a database, while "edit" is more general and means to alter the content of any file (text, database, graphics, etc.).

Update and Upgrade

The terms "update" and "upgrade" are used synonymously, although "update" is more often used to refer to adding and deleting elements of data, and "upgrade" refers to installing new versions of software. However, you can "update" your software by "upgrading" to the new version. See edit.

Download Computer Desktop Encyclopedia to your iPhone/iTouch

 

1. Computerized file maintenance process in an off-line system that applies all necessary transactions against the old file, producing a new file reflecting all adds, deletes, and changes that have become necessary since the last update. It is necessary to update a file before producing any output, to ensure the accuracy and completeness of the output. Most updates are conducted on a regular schedule, corresponding with the required frequency of the output. Regular updates are not necessary for on-line systems that are continuously updated.

2. Provide current information to an individual or group of persons, or revise printed information according to the most current information available.

 

1. Computerized file maintenance process in an Off-Line system that applies all necessary Transactions against the old file, producing a new file reflecting all adds, deletes, and Changes that have become necessary since the last update.

2. Provide current information to an individual or group of persons, or revise printed information according to the most current information available.

 
Thesaurus: update
Top

verb

    To make modern in appearance or style: modernize. See new/old.

 
Antonyms: update
Top

v

Definition: bring up to date
Antonyms: antique, make old


 
Wikipedia: Update (SQL)
Top

A SQL UPDATE statement that 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[1]:

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, the updated value must not conflict with all the applicable constraints (such as primary keys, unique indexes, CHECK constraints, and NOT NULL constraints).

Examples

Set the value of column C1 in table T to 1, only in those rows where the value of column C2 is "a".

UPDATE T SET C1 = 1 WHERE C2 = 'a'

Increase value of column C1 by 1 if the value in column C2 is "a".

UPDATE T SET C1 = C1 + 1 WHERE C2 = 'a'

Prepend the value in column C1 with the string "text" if the value in column C2 is "a".

UPDATE T SET C1 = 'text' || C1 WHERE C2 = 'a'

Set the value of column C1 in table T1 to 2, only if the value of column C2 is found in the sub list of values in column C3 in table T2 having the column C4 equal to 0.

UPDATE T1 
SET    C1 = 2    
WHERE  C2 IN ( SELECT C3
               FROM   T2
               WHERE  C4 = 0)

You may also update multiple columns in a single update statement:

UPDATE T SET C1 = 1, C2 = 2

Complex conditions are also possible:

UPDATE T SET A = 1 WHERE C1 = 1 AND C2 = 2

The SQL:2003 standard does not support updates of a joined table. Therefore, the following method needs to be used. Note that the subselect in the SET clause must be a scalar subselect, i.e., it can return at most a single row.

UPDATE T1
SET    C1 = ( SELECT T2.C2
              FROM   T2
              WHERE  T1.ID = T2.ID )
WHERE  EXISTS ( SELECT 1
                FROM   T2
                WHERE  T1.ID = T2.ID )

 
Translations: Update
Top

Dansk (Danish)
v. tr. - opdatere, ajourføre, modernisere
n. - opdatering, ajourføring, modernisering

Nederlands (Dutch)
bijwerken, actualiseren, moderniseren, verslag van ontwikkelingen, meest recente gegevens/versie, het bijwerken

Français (French)
v. tr. - mettre ou remettre (qch) à jour, moderniser, actualiser, remettre (qch) au goût du jour, mettre (qn) au courant de
n. - mise à jour

Deutsch (German)
v. - auf den neuesten Stand bringen, modernisieren
n. - Aktualisierung

Ελληνική (Greek)
v. - ενημερώνω, εκσυγχρονίζω
n. - ενημέρωση, (Η/Υ) ενημερωμένη έκδοση προγράμματος

Italiano (Italian)
aggiornare

Português (Portuguese)
v. - atualizar
n. - atualização (f)

Русский (Russian)
модернизировать, вносить дополнения, модернизация, дополнения и/или улучшения, корректировка данных, последний (уточненный) вариант (доклада и т.п.), самые свежие новости

Español (Spanish)
v. tr. - poner al día, actualizar
n. - (realizar una) actualización, datos (para actualizar información)

Svenska (Swedish)
v. - uppdatera, göra aktuell, modernisera
n. - uppdatering

中文(简体)(Chinese (Simplified))
更新, 补充最新资料, 使现代化, 现代化

中文(繁體)(Chinese (Traditional))
v. tr. - 更新, 補充最新資料, 使現代化
n. - 現代化, 更新

한국어 (Korean)
v. tr. - 갱신하다, 새 것으로 하다
n. - 새롭게 함, 최신 정보

日本語 (Japanese)
v. - 最新のものにする
n. - 最新版, 最新情報

العربيه (Arabic)
‏(فعل) جدد معلولات (الاسم) تجديد المعلومات‏

עברית (Hebrew)
v. tr. - ‮עדכן‬
n. - ‮עדכון‬


 
 

 

Copyrights:

Dictionary. The American Heritage® Dictionary of the English Language, Fourth Edition Copyright © 2007, 2000 by Houghton Mifflin Company. Updated in 2007. Published by Houghton Mifflin Company. All rights reserved.  Read more
Computer Desktop Encyclopedia. THIS COPYRIGHTED DEFINITION IS FOR PERSONAL USE ONLY.
All other reproduction is strictly prohibited without permission from the publisher.
© 1981-2009 Computer Language Company Inc.  All rights reserved.  Read more
Marketing Dictionary. Dictionary of Marketing Terms. Copyright © 2000 by Barron's Educational Series, Inc. All rights reserved.  Read more
Business Dictionary. Dictionary of Business Terms. Copyright © 2000 by Barron's Educational Series, Inc. All rights reserved.  Read more
Thesaurus. Roget's II: The New Thesaurus, Third Edition by the Editors of the American Heritage® Dictionary Copyright © 1995 by Houghton Mifflin Company. Published by Houghton Mifflin Company. All rights reserved.  Read more
Answers Corporation Antonyms. © 1999-2009 by Answers Corporation. All rights reserved.  Read more
Wikipedia. This article is licensed under the GNU Free Documentation License. It uses material from the Wikipedia article "Update (SQL)" Read more
Translations. Copyright © 2007, WizCom Technologies Ltd. All rights reserved.  Read more

 

Mentioned in