Inserting Data

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Retrieving and Editing Data >

Inserting Data

In DatabaseSpy, you have several possibilities to populate your tables with data:

 

Import database data from CSV or XML files, see Importing Database Data
Manually add new rows directly into the Result grid. You can also paste into the Result grid cell ranges copied from another Result grid or from external files such as Microsoft Excel spreadsheets, see Adding and Copying Rows.

 

When you want to add only a few rows of data, you can also generate INSERT statements and enter the values manually in the SQL Editor. You can enter data for a particular column or for the entire row of a table.

 

 

To insert data using INSERT statements:

1.Connect to the database and show the respective data source in the Online Browser.
2.Right-click the table and select Show in new SQL Editor | Insert from the context menu. Alternatively, hold down the right mouse button, drag the table into an open SQL Editor window and select Insert from the context menu. An INSERT INTO... statement is generated in the SQL Editor.
3.Enter the desired values in the VALUES ( , , , , ) part of the statement (the number of commas depends on the number of columns in the respective table). If required, check the data type of the individual columns in the Properties window of the Online Browser.
4.Click the Execute ic_execute-sql button to execute the statement and to insert the data into the database.
5.Optionally, save the SQL statement if you need to insert the same kind of data frequently, see Opening, Saving, and Closing SQL Files.

 

 

To insert data only into specific columns of a table:

1.Connect to the database and show the respective data source in the Online Browser.
2.In the Online Browser, expand the table you want to edit to and select the column(s) into which you want to insert data.
3.Right-click and select Show in new SQL Editor | Insert from the context menu. Alternatively, hold down the right mouse button, drag the column(s) into an open SQL Editor window and select Insert from the context menu. An INSERT INTO... statement is generated in the SQL Editor.
4.Enter the desired value(s) in the VALUES ( ) part of the statement. You may also have to enter the primary key for the new table row. Add the name and the value of the primary key to the statement in this case.

 

Note:If your table contains columns that are not nullable, you must also enter values for these columns.

 

5.Click the Execute ic_execute-sql button to execute the statement and to insert the data into the database.
6.Optionally, save the SQL statement if you need to insert the same kind of data frequently, see Opening, Saving, and Closing SQL Files.

© 2019 Altova GmbH