Update statement

Update data without writing any code

Update

{
  "type": "sql-update",
  "id": "order-set-status-update",
  "connection": "sample-database-connection",
  "table": "order",
  "whereCondition": "`id` = :id",
  "params": [
    {
      "column": "status",
      "name": "status",
      "type": "string",
      "required": true
    },
    {
      "name": "id",
      "type": "int",
      "column": "id",
      "required": true
    },
    {
      "name": "createdAt",
      "column": "created_at",
      "sqlValue": "NOW()"
    }
  ]
}

sqlValue - use database specific values

whereCondition - update conditions