functional overview

Delete a record in the database.

Details of Functions

tableDeletes records from the
If search criteria are added, the target records are narrowed down according to the specified criteria.

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
Fruit and Vegetable Table

additional parameter

Search field	terms	Comparison value
ID	=	2

Fruit and Vegetable Table(After execution)

ID	Name	category
1	apple (fruit)	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.
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

<前 1004_データベース/更新>

<次 1006_データベース/SQL実行>