Inserting Rows

To insert a row, issue INSERT or INSERT SELECT. You can also use the ttBulkCp utility.

The following example demonstrates how to insert a row in the table customer.

Command> INSERT INTO customer VALUES(23125, 'John Smith';

Note:

When inserting multiple rows into a table, it is more efficient to use prepared commands and parameters in your code. Create indexes after the bulk load is completed.