PQL Insert

The PQL INSERT INTO Statement
The INSERT INTO statement is used to insert a new row in a stable.

PQL INSERT INTO Syntax
It is possible to write the INSERT INTO statement in two forms.

The first form doesn't specify the column names where the data will be inserted, only their values:

The second form specifies both the column names and the values to be inserted:

PQL INSERT INTO Example
We have the following "Ponies" stable:

Now we want to insert a new row in the "Ponies" stable.

We use the following PQL statement:

The "Ponies" stable will now look like this:

Insert Data Only in Specified Columns
It is also possible to only add data in specific columns.

The following PQL statement will add a new row, but only add data in the "P_Id", "LastName" and the "FirstName" columns:

The "Ponies" stable will now look like this: