functional overview

Update records in database tables.

Details of Functions

tableUpdate the items in the
If search criteria are added, the target records are narrowed down according to the specified criteria.
If no search criteria are used, all records will be included.

note

Fruit and Vegetable Table(Before execution)

ID	Name	category
1	apple (fruit)	fruit
2	green bell pepper	vegetable
3	onion (edible plant, Allium cepa)	vegetable
4	grape	fruit
5	potato (Solanum tuberosum)	vegetable

If the following argument is specified, the result will be the "Fruits and Vegetables Table (after execution)".
argument (e.g. function, program, programme)

table	field	value
Fruit and Vegetable Table	Name	(edible) cherry

additional parameter

field	value
Category	fruit

Search field	terms	Comparison value
ID	=	2

Fruit and Vegetable Table(After execution)

ID	Name	Category
1	apple (fruit)	fruit
2	(edible) cherry	fruit
3	onion (edible plant, Allium cepa)	vegetable
4	grape	fruit
5	potato (Solanum tuberosum)	vegetable

parameter

argument (e.g. function, program, programme)

table	Specify the target table.
update field	Specify the target field.
value	numeric data character string data Date & Time Data update fieldSpecify the value to be set for the contents of the
update field	Specify the target field. (additional argument)
value	numeric data character string data Date & Time Data update fieldSpecify the value to be set for the contents of the (additional argument)
Search field	Specify fields to search. (additional argument)
terms	Specify conditions. (additional argument) >= <= > < ! = ! =
Comparison value	numeric data character string data Date & Time Data Search fieldand the value to be compared. (additional argument)

return value

without

<前 1003_データベース/追加>

<次 1005_データベース/削除>