Data rows can be inserted into an un-columnized table create with the CREATE TABLE-command. For supported data types see _datetypes link.
Note: INSERT INTO does NOT work with a table that’s created with the IMPORT statement as that table already is columnized.
Syntax:
INSERT INTO (column1, column2, column3, …) VALUES (value1,value2,value3, …)
Example:
CREATE TABLE customer (customerno int, customername string)
INSERT INTO customer (customerno,customername) VALUES (1,'Smith')
INSERT INTO customer (customerno,customername) VALUES (2,'Jones')
COLUMNIZE customer
Comments
Please sign in to leave a comment.