Insert

<< Click to Display Table of Contents >>

Navigation:  Additional References > Database Primer >

Insert

Previous pageReturn to chapter overviewNext page

 

The SQL Insert statement allows new data to be added into a database table. Before new data records can be inserted into a database, a database table must first be created to house the data. Based on our example above, let's assume the user would like to insert a new record into the Persons database table. The user would create and issue the following SQL Insert statement:

 

INSERT INTO Persons(4, 'Ford', 'Debby', '165 W Maple St', ‘Los Angeles')

 

Note that the sequence of the fields in the SQL Insert statement must match that of the Persons database table.