CODEWITHSUNDEEP
mongodbazureazure-cosmosdb
PirateApp
PirateApp

Reputation: 6194

Delete a row from mongodb database in azure

I am an azure newbie who has a mongodb database on Azure cloud storage. I am trying to delete a row with a specific value from the Query explorer in Azure, but I keep getting this error. Am I missing something? enter image description here

delete from users where _id='...' doesnt work neither does delete * from users where _id='' work

this works perfectly even if am doing SQL on a mongodb database while querying enter image description here

Upvotes: 0

Views: 1167

Answers (1)

Sami Pussinen
Sami Pussinen

Reputation: 98

I think you are using Microsoft DocumentDB (not mongoDB). DocumentDB is available on Azure and supports SQL-like queries.

I suggest taking a look at the documentation: https://azure.microsoft.com/en-us/documentation/articles/documentdb-sql-query/

According to the docs INSERT, UPDATE, and DELETE are only available through the REST API and not in the query language.

Upvotes: 2

Related Questions