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
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.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments