Sybase 12.4.2 Manuale Utente

Using the INSERT statement

 

The 

INSERT

 statement allows you to insert data without first putting it into a 

flat file. Using this command, you can either:

•

Insert a specified set of values row by row

•

Insert directly from database tables

See the sections that follow for details of these two forms of the command.

To add specified values to a table row by row, use the 

INSERT

 statement with 

this syntax:

INSERT [ INTO ]
[ 

owner.] table_name

[ (

column_name, ...) ]

... VALUES (

expression...)

 Adaptive Server IQ inserts the first value you specify into the first column you 
specify, the second value you specify into the second column, and so on. If you 
omit the list of column names, the values are inserted into the table columns in 
the order in which the columns were created (the same order as 

SELECT *

 

would retrieve). Adaptive Server IQ inserts the row into the table wherever 
room is available.

 Values can be  NULL, any positive or negative number, or a literal. 

•

Enclose values for 

CHAR

, 

VARCHAR

, 

DATE

, 

TIME

, and 

TIMESTAMP

 or 

DATETIME 

columns in single or double quotation marks. To indicate a 

value with a quotation in it use a different set of quotes for the outer quote, 
such as “Smith' s”.