transformations:sqlcommand
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
| transformations:sqlcommand [2017/05/01 22:47] – dmitry | transformations:sqlcommand [2017/05/01 22:48] – dmitry | ||
|---|---|---|---|
| Line 5: | Line 5: | ||
| * Delete database table | * Delete database table | ||
| * Delete all rows | * Delete all rows | ||
| - | * Custom | + | * Custom |
| ==== Create database table ==== | ==== Create database table ==== | ||
| Line 22: | Line 22: | ||
| Note that some databases don't have a native command for truncation. In such cases truncation is performed with the help of a DELETE query. The operation is atomic meaning that it either deletes everything, or, in case of a failure, nothing. | Note that some databases don't have a native command for truncation. In such cases truncation is performed with the help of a DELETE query. The operation is atomic meaning that it either deletes everything, or, in case of a failure, nothing. | ||
| - | ==== Custom | + | ==== Custom |
| Sends a free-form SQL query to the database, specified by [[: | Sends a free-form SQL query to the database, specified by [[: | ||
transformations/sqlcommand.txt · Last modified: 2022/12/05 14:23 by craigt