Клецова Базы данных Лабораторный практикум 2008
.pdfПРИЛОЖЕНИЕ 5
[[INTO Destination] | [TO FILE FileName [ADDITIVE] | TO PRINTER [PROMPT] | TO SCREEN]]
[PREFERENCE PreferenceName] [NOCONSOLE] [PLAIN] [NOWAIT]
[WHERE JoinCondition [AND JoinCondition ...] [AND | OR FilterCondition [AND | OR FilterCondition ...]]]
[GROUP BY GroupColumn [, GroupColumn ...]] [HAVING FilterCondition] [UNION [ALL] SELECTCommand]
[ORDER BY Order_Item [ASC | DESC] [, Order_Item [ASC | DESC] ...]]
UPDATE [DatabaseName1!]TableName1 SET Column_Name1 = eExpression1
[, Column_Name2 = eExpression2 ...]
WHERE FilterCondition1 [AND | OR FilterCondition2 ...]
INSERT INTO dbf_name [(fname1 [, fname2, ...])] VALUES (eExpression1 [, eExpression2, ...])
-or-
INSERT INTO dbf_name FROM ARRAY ArrayName | FROM MEMVAR | FROM NAME ObjectName
-or-
INSERT INTO dbf_name [(fname1 [, fname2, ...])] SELECT [(fname1 [, fname2, ...])] FROM tablename
WHERE condition
DELETE FROM [DatabaseName!]TableName
[WHERE FilterCondition1 [AND | OR FilterCondition2 ...]]
CREATE CURSOR alias_name
(fname1 type [(precision [, scale])] [NULL | NOT NULL]
[CHECK lExpression [ERROR cMessageText]] [AUTOINC [NEXTVALUE NextValue [STEP StepValue]]] [DEFAULT eExpression] [UNIQUE [COLLATE cCollate-
Sequence]]
[NOCPTRANS] [, fname2 ...]) | FROM ARRAY ArrayName
131
Татьяна Владимировна Клецова Наталья Владимировна Овсянникова Игорь Вениаминович Прохоров
Базы данных
Лабораторный практикум
Редактор Н.В. Шумакова
Оригинал-макет изготовлен Т.В. Клецовой
Подписано в печать 01.09.2008. |
Формат 60×84 1/16 |
|
Печ. л. 8,25. |
Уч.-изд. л. 8,25. |
Тираж 120 экз. |
|
Изд. № 3/44. |
Заказ № |
Московский инженерно-физический институт (государственный университет), 115409, Москва, Каширское ш., 31.
Типография издательства «ТРОВАНТ», г. Троицк Московской области