We may use the SQL INSERT INTO command to add a record to a table in a database.
We want to add a new record to the Customers table in the Northwind database. We first create a
form that contains the fields we want to collect data from:
When the user presses the submit button the form is sent to a file called "demo_add.html".
The "demo_add.html" file contains the code that will add a new record to the Customers
If you use the SQL INSERT command be aware of the following:
In a MS Access database, you can enter zero-length strings ("") in Text, Hyperlink, and
Memo fields IF you set the AllowZeroLength property to Yes.
Note: Not all databases support zero-length strings and may cause an error when a record
with blank fields is added. It is important to check what data types your database
Your Query was successfully sent!