Comment on page
SQL Operations
Executes the provided SQL statement. The SELECT statement is used to query data from the database.
- operation (required) - must always be
sql
- sql (required) - use standard SQL
{
"operation": "sql",
"sql": "SELECT * FROM dev.dog WHERE id = 1"
}
[
{
"id": 1,
"age": 7,
"dog_name": "Penny",
"weight_lbs": 38,
"breed_id": 154,
"owner_name": "Kyle",
"adorable": true,
"__createdtime__": 1611614106043,
"__updatedtime__": 1611614119507
}
]
Executes the provided SQL statement. The INSERT statement is used to add one or more rows to a database table.
- operation (required) - must always be
sql
- sql (required) - use standard SQL
{
"operation": "sql",
"sql": "INSERT INTO dev.dog (id, dog_name) VALUE (22, 'Simon')"
}
{
"message": "inserted 1 of 1 records",
"inserted_hashes": [
22
],
"skipped_hashes": []
}
Executes the provided SQL statement. The UPDATE statement is used to change the values of specified attributes in one or more rows in a database table.
- operation (required) - must always be
sql
- sql (required) - use standard SQL
{
"operation": "sql",
"sql": "UPDATE dev.dog SET dog_name = 'penelope' WHERE id = 1"
}
{
"message": "updated 1 of 1 records",
"update_hashes": [
1
],
"skipped_hashes": []
}
Executes the provided SQL statement. The DELETE statement is used to remove one or more rows of data from a database table.
- operation (required) - must always be
sql
- sql (required) - use standard SQL
{
"operation": "sql",
"sql": "DELETE FROM dev.dog WHERE id = 1"
}
{
"message": "1 of 1 record successfully deleted",
"deleted_hashes": [
1
],
"skipped_hashes": []
}
Last modified 18d ago