Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Querying and modifying data » Adding, changing, and deleting data

 

Adding data using INSERT

You add rows to the database using the INSERT statement. The INSERT statement has two forms: you can use the VALUES keyword or a SELECT statement:

 INSERT using values
 INSERT from SELECT

Inserting values into all columns of a row
Inserting values into specific columns
Adding new rows with SELECT
Inserting documents and images