Inserting Records

Basic SQL Queries Using the INSERT Command

[EE] This section will cover basic INSERT commands using SQL statements and will include examples to help with the explanation.

Once again, a basic knowledge of SQL is recommended.

The INSERT command is followed by the INTO keyword which specifies the table to insert data into.

The sample below is what will be displayed if the SQL operation is executed.

After the values have been entered, click the Insert button. This will create a new record for the table.

If there are required fields (indicated by a red asterisk) they need to be given a value in order for the row to be inserted.