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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Query and modify data » 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 in Interactive SQL.


Type the values in the same order as the column names in the original CREATE TABLE statement, that is, first the ID number, then the name, then the department head ID.

Surround the values by parentheses.

Enclose all character data in single quotes.

Use a separate insert statement for each row you add.

Context and remarks


 Insert values into all columns of a row
  • Execute an INSERT statement that includes values for each column. For example, the following INSERT statement adds a new row to the Departments table, giving a value for every column in the row:

    INSERT INTO Departments
    VALUES ( 702, 'Eastern Sales', 902 );


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



 See also