Adding New Data to the Database

Let’s imagine that in the sales database, a salesperson named “Mary Jones” made a new sale on October 15, 2023. They sold a “New Smartphone” worth 800 under the “Electronics” category. To store a record of this new transaction for future reference, we utilize the SQL INSERT INTO statement. This statement is essential for the addition of new records to our database tables.

The INSERT INTO statement

The typical structure of the INSERT INTO statement is outlined as follows: