How to insert a record using the Admin console Datastore Viewer using GQL

Question

Is it possible to INSERT or UPDATE a entity in the datastore using the Admin > Datastore Viewer.

E.g. executing something like

INSERT INTO table VALUES (Foo='Bar')

Answer 1

Not with GQL, but it is possible to INSERT and UPDATE entities with the Datastore Viewer.

To INSERT: After clicking on the Datastore Viewer, click the tab Create on top, select a Kind, press Next, fill the values and press Save Entity.

To UPDATE: In the Datastore Viewer, click on an ID/Name identifier, change the values and press Save Entity.

Answer 2

No you can't; GQL is a SQL-like language just for retrieving entities or keys.

You can INSERT, UPDATE or DELETE entities using the Datastore Viewer or from your application code.