Inserting data into a table

This option allows you to insert data into a table. Using this option, you can insert a given value to a given column. To complete the other columns of the same row, you should use the "Update" option from the "Select" list. Columns in the table that are not assigned any value are set to their default value or NULL.

To insert data into a table, choose "Insert" from the "Select" list and select the table you want to add the data to. From the "Column Name" list, choose the column you want to add a value to. Enter the value into the "Column Value" textbox and click the "Build SQL Query" button. After reviewing the SQL Query, click the "Run SQL Query" button to complete the operation. The result of the operation will appear at the bottom of the page.