Skip to content

SQLDelete

Jump to bottom Edit New page
jazzzz edited this page Dec 13, 2012 · 1 revision

SQL Delete

The SQL Delete command deletes one or more records from the database. The set of records involved are taken by the WHERE clause.

Syntax

DELETE FROM <Class>|cluster:<cluster>|index:<index> [<Condition>*](WHERE) [BY <Fields>* [ASC|DESC](ORDER)*] [<MaxRecords>](LIMIT)

The WHERE clause is common to the other SQL commands.

Examples

Delete all the records with surname equals to 'unknown' ignoring the case:

delete from Profile where surname.toLowerCase() = 'unknown'

To know more about other SQL commands look at SQL commands.

Home - Download - Install - Upgrade - Professional Support - Courses - Team

  • Copyright (C) Orient Technologies - All rights reserved.

軽量・高速、ビッグデータ時代のグラフデータベースOrientDB

<script> (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); ga('create', 'UA-28543690-2', 'orientechnologies.com'); ga('send', 'pageview'); </script>
Add a custom sidebar
Clone this wiki locally