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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Statement Reference

UltraLite DROP TABLE statement Next Page

UltraLite INSERT statement


Inserts a single row into a table or to insert rows from a query result set.

Syntax

INSERT [ INTO ]
table-name [ ( column-name, ... ) ]
{ VALUES ( expression, ... ) | SELECT statement }

Remarks

If the optional list of column names is given, the values are inserted one for one into the specified columns. If the list of column names is not specified, the values are inserted into the table columns in the order they were created (the same order as retrieved with SELECT *). The row is inserted into the table at an arbitrary position.

You must use either the VALUES expression or SELECT statement. You cannot use both.

Character strings inserted into tables are always stored in the same case as they are entered, regardless of whether the database is case sensitive.

See also
Examples

The following statement adds an Eastern Sales department to the database.

INSERT
INTO department ( dept_id, dept_name )
VALUES ( 230, 'Eastern Sales' )