The INSERT statement lets you add rows to the database. Because you include the import data for your destination table directly in the INSERT statement, it is considered interactive input. You can also use the INSERT statement with remote data access to import data from another database rather than a file.
Use the INSERT statement to import data when you:
want to import small amounts of data into a single table
are flexible with your file formats
want to import remote data from an external database rather than from a file
For more information, see INSERT statement.
Changes are recorded in the transaction log when you use the INSERT statement. This means that if there is a media failure involving the database file, you can recover information about the changes you made from the transaction log.
For more information, see The transaction log.
This example shows you how to import data using the INSERT statement. With this INSERT statement, you add data to the Departments table of the SQL Anywhere sample database.
Ensure that the destination table exists.
Execute an INSERT statement. For example,
The following example inserts a new row into the Departments table in the SQL Anywhere sample database.
INSERT INTO Departments ( DepartmentID, DepartmentName, DepartmentHeadID ) VALUES ( 700, 'Training', 501) SELECT * FROM Departments;
Inserting values adds the new data to the existing table.