Using a language command, insert adds a new row to a table or view.
insert [into] database.[owner.]{table_name|view_name}[(column_list)] values (value1, [,value2]...)
Any valid object in the catalog can be substituted for table_name or view_name.
is optional.
is a list of one or more columns to which data is to be added. The columns can be in any order, but the incoming data (whether in a values clause or a select clause) is in the same order.
is a keyword that introduces a list of expressions.
insert titles (title_id, title, type, pub_id, notes, pubdate,contract) values (docid, docno, docdate)
Not defined.
Copyright © 2005. Sybase Inc. All rights reserved. |