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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Queries and data modification » Data manipulation statements » Addition of data using INSERT


Inserting values into all columns of a row

You can insert values into all the columns of a row using the INSERT statement.


You must have INSERT privilege on the table. If the ON EXISTING UPDATE clause is specified, UPDATE privilege on the table is also required.

Type the values in the same order as the column names in the original CREATE TABLE statement.

Surround the values with parentheses.

Enclose all character data in single quotes.

Use a separate INSERT statement for each row you add.

  • Execute an INSERT statement that includes values for each column.


The specified values are inserted into each column of a new row.


The following INSERT statement adds a new row to the Departments table, giving a value for every column in the row:

VALUES ( 702, 'Eastern Sales', 902 );

 See also