Delete a row from mongodb database in azure

Question

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?

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

Answer 1

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.