To bring up to date: update a textbook; update the files.
n. (ŭp'dāt')- Information that updates something.
- The act or an instance of bringing something up to date.
- An updated version of something.
Dictionary:
up·date (ŭp-dāt') ![]() |
To bring up to date: update a textbook; update the files.
n. (ŭp'dāt')| Computer Desktop Encyclopedia: update |
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
| Marketing Dictionary: update |
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.
| Business Dictionary: Update |
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 |
| Wikipedia: Update (SQL) |
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).
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 )
|
||||||||||||||||||||
This entry is from Wikipedia, the leading user-contributed encyclopedia. It may not have been reviewed by professional editors (see full disclaimer)
| Translations: Update |
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. - ενημέρωση, (Η/Υ) ενημερωμένη έκδοση προγράμματος
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. - עדכון
If you are unable to view some languages clearly, click here.
To select your translation preferences click here.
| ACDBU (intelligence) | |
| change file (technology) | |
| commit (technology) |
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 | |
![]() | 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