Delete
Basic Usage
await db.tables['stocks'].delete(
where={'order_num': 1}
)
List Syntax Filtering
Delete Rows matching value comparison
delete_department = await db.tables['departments'].delete(
where=[
['id', '<', 2000] # Value Comparison
]
)
DELETE FROM departments WHERE id < 2000