Using Insert to Add Data to Database Tables
To insert new rows of data into a database table, use the insert statement. For example, this statement adds a row to the Personnel table, transferring the contents of simple fields Lname, Fname, and Empnum to table columns last, first, and empnum, respectively:
insert into personnel (last, first, empnum)
values (lname, fname, empnum);
Appending values to a database table from a table field generally involves using the insert statement along with the unloadtable statement, which is described in
Processing an Entire Table Field or Array with Unloadtable and
unloadtable Statement--Loop Through Rows and Execute Statements on page 184. Unloadtable can also be used with arrays.
Last modified date: 04/03/2024