Documentation Home
X DevAPI User Guide
Download this Manual
PDF (US Ltr) - 1.4Mb
PDF (A4) - 1.4Mb


X DevAPI User Guide  /  Working with Relational Tables  /  Syntax of the SQL CRUD Functions

6.1 Syntax of the SQL CRUD Functions

The following SQL CRUD functions are available in X DevAPI.

Table.insert()

The Table.insert() method works like an INSERT statement in SQL. It is used to store data in a relational table in the database. It is executed by the execute() function.

The following example shows how to use the Table.insert() function. The example assumes that the test schema exists and is assigned to the variable db, and that an empty table called my_table exists.

MySQL Shell JavaScript Code

Press CTRL+C to copy
// Accessing an existing table var myTable = db.getTable('my_table'); // Insert a row of data. myTable.insert(['id', 'name']). values(1, 'Imani'). values(2, 'Adam'). execute();

MySQL Shell Python Code

Press CTRL+C to copy
# Accessing an existing table myTable = db.get_table('my_table') # Insert a row of data. myTable.insert(['id', 'name']).values(1, 'Imani').values(2, 'Adam').execute()

Node.js JavaScript Code

Press CTRL+C to copy
// Accessing an existing table var myTable = db.getTable('my_table'); // Insert a row of data. myTable.insert(['id', 'name']). values(1, 'Imani'). values(2, 'Adam'). execute();

C# Code

Press CTRL+C to copy
// Assumptions: test schema assigned to db, empty my_table table exists // Accessing an existing table var myTable = db.GetTable("my_table"); // Insert a row of data. myTable.Insert("id", "name") .Values(1, "Imani") .Values(2, "Adam") .Execute();

Python Code

Press CTRL+C to copy
# Accessing an existing table my_table = db.get_table('my_table') # Insert a row of data. my_table.insert(['id', 'name']).values(1, 'Imani').values(2, 'Adam').execute()

Java Code

Press CTRL+C to copy
// Accessing an existing table Table myTable = db.getTable("my_table"); // Insert a row of data. myTable.insert("id", "name") .values(1, "Imani") .values(2, "Adam") .execute();

C++ Code

Press CTRL+C to copy
// Accessing an existing table var myTable = db.getTable("my_table"); // Insert a row of data. myTable.insert("id", "name") .values(1, "Imani") .values(2, "Adam") .execute();

Figure 6.1 Table.insert() Syntax Diagram

Content is described in the surrounding text.

Table.select()

The Table.select() method works like a SELECT statement in SQL. Notice that Table.select() and collection.find() use different methods for sorting results: Table.select() uses the method orderBy(), reminiscent of the ORDER BY keyword in SQL, while the sort() method is used to sort the results returned by Collection.find().

Figure 6.2 Table.select() Syntax Diagram

Content is described in the surrounding text.

Table.update()

The Table.update() method works like an UPDATE statement in SQL.

Figure 6.3 Table.update() Syntax Diagram

Content is described in the surrounding text.

Table.delete()

The Table.delete() method works like a DELETE statement in SQL.

Figure 6.4 Table.delete() Syntax Diagram

Content is described in the surrounding text.