Selected tasks database table
From TaskDepender
| Line 1: | Line 1: | ||
| − | ''This page describes the temporary table that is created to hold the ids of the selected tasks.'' | + | __NOTOC__''This page describes the temporary table that is created to hold the ids of the selected tasks.'' |
== Description == | == Description == | ||
| Line 20: | Line 20: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| − | === | + | === Add a task === |
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
| − | + | INSERT INTO SelectedTasks VALUE(%d) | |
| + | </syntaxhighlight> | ||
| − | === | + | === Delete a task === |
| + | |||
| + | <syntaxhighlight lang="sql"> | ||
| + | DELETE FROM SelectedTasks WHERE Id=%d | ||
| + | </syntaxhighlight> | ||
| + | |||
| + | === Clear table === | ||
| + | |||
| + | <syntaxhighlight lang="sql"> | ||
| + | DELETE FROM SelectedTasks | ||
| + | </syntaxhighlight> | ||
---- | ---- | ||
* [[Database]] | * [[Database]] | ||
