Creating Records

For insert some records on OrientDb you can use the follow commands:

INSERT INTO V (name, type) VALUES ('Supersong', 'song'), ('Brian', 'artist')
INSERT INTO V SET name = 'Gary', type = 'artist
INSERT INTO V CONTENT {"name": "Dave", "type": "artist"}
INSERT INTO CLUSTER:9 (name) VALUES ('Bobby')
INSERT INTO Diver SET name = 'Bill', buddy = (SELECT FROM Diver name = 'Jill')
INSERT INTO CLUSTER:ClientFR FROM (SELECT FROM Client WHERE country = "Canada")
CREATE VERTEX Bus CLUSTER Operational
CREATE Employee content { "name": "Jay", "surname": "Miner"}

Selecting Records

For select some records or an specific one you can use:

SELECT FROM Account
SELECT name, age FROM Account
SELECT * FROM Person WHERE name LIKE 'Luk%'
SELECT * FROM Person WHERE name.left(3) = 'Luk'
SELECT FROM [#10:3, #10:4, #10:5]
SELECT name.toUppercase(), address.city.country.name FROM Profile
SELECT FROM Profile ORDER BY @rid DESC
SELECT FROM Profile
LET $city.name = address.city
WHERE $city.name like '%Saint%"' and
  ($city.country.name = 'Italyl' or $city.country.name = 'France')

Updating Records

For update records you can use the follow examples:

UPDATE Profile SET name = 'Dave' WHERE name IS NULL
UPDATE Profile REMOVE name
UPDATE Account ADD addresses = #12:0
UPDATE #15:332 SET address = {"street": "Rose Ave.", "city": {"name": "NY"}}
UPDATE Profile SET job = 'Labourer' WHERE job IS NULL LIMIT 20
UPDATE Counter INCREMENT views = 1 WHERE page = '/downloads/' LOCK RECORD
UPDATE Person SET firstName = 'Dave' UPSERT WHERE status = 'active'

Deleting Records

For delete records you can use some of the follow examples:

DELETE FROM Profile WHERE surname.toLowerCase() = 'uknown'
DELETE FROM Leads WHERE age > 120
DELETE FROM CLUSTER:Archive
DELETE FROM #13:45 RETURN BEFORE