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.
INSERT INTO (column1, column2, column3, …) VALUES (value1,value2,value3, …)
CREATE TABLE customer (customerno int, customername string)
INSERT INTO customer (customerno,customername) VALUES (1,'Smith')
INSERT INTO customer (customerno,customername) VALUES (2,'Jones')
Please sign in to leave a comment.